
Untitled
By: a guest on
May 16th, 2012 | syntax:
None | size: 0.54 KB | hits: 9 | expires: Never
<?php
$name = $_POST['name'];
$age = $_POST['age'];
$mysqlhost = "localhost";
$mysqluser = "root";
$mysqldb = "jquery";
$mysqlpwd = "1234";
$connection = mysql_connect($mysqlhost, $mysqluser, $mysqlpwd);
mysql_select_db($mysqldb, $connection);
mysql_query('INSERT INTO contact (Name, Age) VALUES ("' . $name . '", "' . $age . '")');
$result = mysql_query("Select * from contact");
$x = array();
$i = 0;
while($array = mysql_fetch_assoc($result)) {
$x[$i] = $array;
$i++;
}
$json = json_encode(array("d"=>$x));
echo $json;
?>