I have created a folder inside the wamp server setup end as "android_connect" and have uploaded my php files there. you can see the file path if you want in the errors below.. the files are :
db_config.php
<?php
define('DB_USER',"root");
define('DB_PASSWORD',"vikrant");
define('DB_DATABASE',"sys");
define('DB_SERVER',"Local instance wampmysqld64");
?>;
db_connect.php
<?php
class DB_CONNECT{
function _construct(){
$this->connect();
}
function _destruct(){
$this->close();
}
function connect(){
require_once_DIR_.'/dbconfig.php';
$con=mysql_connect(DB_SERVER, DB_USER, DB_PASSWORD) or die(mysql_error());
$db=mysql_select_db(DB_DATABASE) or die(mysql_error()) or die(mysql_error());
return $con;
}
function close(){
mysql_close();
}
}
?>;
get_all_products.php
<?php
$response=array();
require_once_DIR_.'/db_connect.php';
$db=new DB_CONNECT();
$result=mysql_querry("SELECT * FROM users") or die(mysql_error());
if(mysql_num_rows($result)>0){
$response["products"]=array();
while($row=mysql_fetch_array($result)){
$product=array();
$product["pid"]=$row["pid"];
$product["name"]=$row["name"];
$product["price"]=$row["price"];
$product["description"]=$row["description"];
$product["created_at"]=$row["created_at"];
$product["updated_at"]=$row["updated_at"];
array_push($response["products"],$product);
}
$response["success"]=1;
echo json_encode($response);
}else{
$response["success"]=0;
$response["message"]="No Product Found.";
echo json_encode($response);
}
?>;
which is giving errors:
Deprecated: mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp64\www\android_connect\get_all_products.php on line 5
Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in C:\wamp64\www\android_connect\get_all_products.php on line 5
Warning: mysql_query(): A link to the server could not be established in C:\wamp64\www\android_connect\get_all_products.php on line 5
These are some of many files i have tried uploading. Please help and thank you in advance.
What I have tried:
Tried rewritng the code and reuploading it..