Jump to content

Help with JSON in PHP


fanboime

Recommended Posts

here is my insert method

public function add($values)
		{
			$sql = "insert into vehicles(`vehicle_plates`,`DA`,`type`, `model`, `driver`) values('$values')";
			
			if(!mysql_query($sql))
			{
				$this->error = mysql_error();
				return true;
			}
			
			else
			{
				return false;
			}
		}

And here is my Button click funtion

$( "#button" ).button();
		
		$( "#button" ).click(function( event ) {
		
			<?PHP
			if(isset($_POST["subBtn"]))
				{
					$fName = $g->clean($_POST["fullname"],1);
					$sDate = date('Y-m-d', strtotime($_POST["startdate"]));
					$roomNum = $g->clean($_POST["roomnumber"]);
					$driver = $g->clean($_POST["driver"],1);
					$model = $g->clean($_POST["model"],1);

					$json = '{"a":$fName, "b":$sDate, "c":$roomNum, "d":$model, "e":$driver}';
					
					$array = json_decode($json, true);
 
					$values = implode(",", $array);
					
					$g->add($values);
				}
		?>
      });

Everytime i click my button it Postsback and nothing inserts in my database...

Link to comment
https://forums.phpfreaks.com/topic/288040-help-with-json-in-php/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.