<?php
/*include_once('define.inc');
$conn = mysqli_connect(HOSTNAME, DBUSER, DBPWD, DBNAME) or die('Could not connect: ' . mysqli_connect_error());
mysqli_set_charset($conn,"utf8");*/
if (isset($_REQUEST['action'])) {
$task = $_REQUEST['action'];
}
switch ($task) {
case 'add_uservalidate' :
add_uservalidate();
break;
case 'check_phone' :
check_phone();
break;
case 'add_type' :
add_type();
break;
default :
echo "{failure:true}";
break;
}
function add_uservalidate(){
include_once('define.inc');
$conn = mysqli_connect(HOSTNAME, DBUSER, DBPWD, DBNAME) or die('Could not connect: ' . mysqli_connect_error());
mysqli_set_charset($conn,"utf8");
$email = $_REQUEST['email'];
$phone = $_REQUEST['phone'];
$query = "select * from Users;";
//echo $query;
$result = mysqli_query($conn,$query);
//echo json_encode($result);
$num_rows = mysqli_num_rows($result);
$alert = '';
if($num_rows > 0){
while($row = mysqli_fetch_assoc($result)){
if($email == $row['email']){
$alert = 'email found';
}
if($phone == $row['phone']){
$alert = 'phone found';
}
}
if($alert == ''){
add_user($_REQUEST);
}else{
echo $alert;
}
}else{
add_user($_REQUEST);
//echo '0 rows';
}
}
function check_phone(){
include_once('define.inc');
$conn = mysqli_connect(HOSTNAME, DBUSER, DBPWD, DBNAME) or die('Could not connect: ' . mysqli_connect_error());
$phone = $_REQUEST['phone'];
$id = $_REQUEST['id'];
/*$query = "select * from Users where phone= '".$phone."'";
$result = mysqli_query($conn , $query);
$num_rows = mysqli_num_rows($result);
if($num_rows > 0){*/
$password = md5($_REQUEST['password']);
$sql = "update Users set password = '".$password."' where id = '".$id."'";
if(mysqli_query($conn , $sql)){
echo 'success';
}else{
echo 'failed';
}
/*}
else{
echo 'failed';
}*/
}
function add_user($data){
//echo json_encode($data);
include_once('define.inc');
$conn = mysqli_connect(HOSTNAME, DBUSER, DBPWD, DBNAME) or die('Could not connect: ' . mysqli_connect_error());
mysqli_set_charset($conn,"utf8");
//echo json_encode($data);
$name = $data['name'];
$email = $data['email'];
$phone = $data['phone'];
$password = md5($data['password']);
$type = $data['type'];
$query = "insert into Users (name , email , phone , password , type) values('".$name."' , '".$email."' , '".$phone."' , '".$password."' , '".$type."');";
if(mysqli_query($conn , $query)){
echo 'success';
}else{
echo mysqli_error($conn);
}
}
function add_type(){
include_once('define.inc');
$conn = mysqli_connect(HOSTNAME, DBUSER, DBPWD, DBNAME) or die('Could not connect: ' . mysqli_connect_error());
mysqli_set_charset($conn,"utf8");
$name = $_REQUEST['name'];
$desc = $_REQEST['desc'];
$query = "select * from `Types` where name = '".$name."' and description = '".$desc."'";
$result = mysqli_query($conn , $query);
$num_rows = mysqli_num_rows($result);
if ($num_rows > 0){
echo 'failed';
}else{
$query1 = "insert into `Types` (name , description)values('".$name."' , '".$desc."');";
if(mysqli_query($conn , $query1)){
echo 'success';
}else{
echo 'not saved';
}
}
}
?>
هو ده الكود معلش انا ناسيه خالص خالص فمش عارفه اعدل فين
<?php
include('define.inc');
$conn = mysqli_connect(HOSTNAME, DBUSER, DBPWD, DBNAME) or die('Could not connect: ' . mysqli_connect_error());
mysqli_set_charset($conn,"utf8");
if (session_status() == PHP_SESSION_NONE) {
session_start();
}
?>
