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 two errors:
Notice: Use of undefined constant require_once_DIR_ - assumed 'require_once_DIR_' in C:\wamp64\www\android_connect\get_all_products.php on line 3
Fatal error: Class 'DB_CONNECT' not found in C:\wamp64\www\android_connect\get_all_products.php on line 4
delete_products.php
<?php
respose = array();
is(isset($_POST['pid'])){
$pid=$_POST['pid'];
require_once_DIR_.'/db_connect.php';
$db=new DB_CONNECT();
$result=mysql_querry("DELETE FROM products WHERE pid=$pid");
if (mysql_affected_rows() > 0) {
$response["success"] = 1;
$response["message"] = "Product successfully deleted";
echo json_encode($response);
} else {
$response["success"] = 0;
$response["message"] = "No product found";
echo json_encode($response);
}
}else{
$response["success"] = 0;
$response["message"] = "Required field(s) is missing";
echo json_encode($response);
}
?>
which is giving error:
Parse error: syntax error, unexpected '=' in C:\wamp64\www\android_connect\delete_product.php on line 2
These are some of many files i have tried uploading. Please help and thank you in advance.
What I have tried:
Tried rewriting the code again and reuploading files.