php add and retrieve to mysql

Thursday, July 3, 2014

I am building a small php application where you can add people and then see them on a page. When I was simply adding it went fine, but then I started using a switch and now it doesn't work to either add or retrieve. I cannot see any problem in my syntax, can anyone see something wrong?


php



<?php
$con = mysql_connect("hostWasHere","username","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("dbIsHere", $con);

try{

switch($_POST['action'])
{
case 'retrieve':
$show=mysql_query("Select * from test",$con);

while($row=mysql_fetch_array($show)){
echo "<li><b>$row[firstName]</b> : $row[lastName]</li>";
}
mysql_close($con);
break;

case 'new':
$sql="INSERT INTO test (firstName, lastName)
VALUES
('$_POST[fname]','$_POST[lname]')";

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
else
{
echo "1 record added";
}

mysql_close($con);
break;
}

}


?>


The javascript using this is :



function saveToServer()
{
alert("clicked");
$.post("api.php", {
'action' : "new",
'fname' : $('#fname').val(),
'lname' : $('#lname').val() } ,
function()
{
alert("succes");
}
);

}
function getFromServer()
{
console.log( "in get!" );
$.ajax({
type:"post",
url:"api.php",
data:"action=retrieve",
success:function(data){
$("#comment").html(data);
console.log( "success!" );
}
});

}






http://ift.tt/1xlKu0Z