ghoghnuos
سه شنبه 02 تیر 1394, 14:35 عصر
سلام می شه لطفا راهنمایی کنید که چرا در این کد کوئری آپ دیت چرا کار نمی کنه؟
فایل data.php
<?php
#Include the connect.php file
include('connect.php');
#Connect to the database
//connection String
$connect = mysql_connect($hostname, $username, $password)
or die('Could not connect: ' . mysql_error());
//Select The database
$bool = mysql_select_db($database, $connect);
if ($bool === False){
print "can't find $database";
}
// get data and store in a json array
$query = "SELECT * FROM dastor_tabel";
if (isset($_POST['update']))
{
// UPDATE COMMAND
$update_query = "UPDATE `dastor_tabel` SET `name_motagahzi`='".mysql_real_escape_string($_POST['FirstName'])."',
`name_namayande`='".mysql_real_escape_string($_POST['LastName'])."',
`Title`='".mysql_real_escape_string($_POST['Title'])."' WHERE `num_file`='".mysql_real_escape_string($_POST['num_file'])."'";
$result = mysql_query($update_query) or die("SQL Error 1: " . mysql_error());
echo $result;
}
else
{
// SELECT COMMAND
$result = mysql_query($query) or die("SQL Error 1: " . mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$dastor_tabel[] = array(
'num_file' => $row['num_file'],
'name_motagahzi' => $row['name_motagahzi'],
'name_namayande' => $row['name_namayande'],
'file_add' => $row['file_add']
);
}
echo json_encode($dastor_tabel);
}
?>
فایل data.php
<?php
#Include the connect.php file
include('connect.php');
#Connect to the database
//connection String
$connect = mysql_connect($hostname, $username, $password)
or die('Could not connect: ' . mysql_error());
//Select The database
$bool = mysql_select_db($database, $connect);
if ($bool === False){
print "can't find $database";
}
// get data and store in a json array
$query = "SELECT * FROM dastor_tabel";
if (isset($_POST['update']))
{
// UPDATE COMMAND
$update_query = "UPDATE `dastor_tabel` SET `name_motagahzi`='".mysql_real_escape_string($_POST['FirstName'])."',
`name_namayande`='".mysql_real_escape_string($_POST['LastName'])."',
`Title`='".mysql_real_escape_string($_POST['Title'])."' WHERE `num_file`='".mysql_real_escape_string($_POST['num_file'])."'";
$result = mysql_query($update_query) or die("SQL Error 1: " . mysql_error());
echo $result;
}
else
{
// SELECT COMMAND
$result = mysql_query($query) or die("SQL Error 1: " . mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$dastor_tabel[] = array(
'num_file' => $row['num_file'],
'name_motagahzi' => $row['name_motagahzi'],
'name_namayande' => $row['name_namayande'],
'file_add' => $row['file_add']
);
}
echo json_encode($dastor_tabel);
}
?>