I need to save a variable from a json string named "msg" in my database, but I cannot catch it with $ msg = $ _POST ['msg']; How to catch him?
In addition, I want the contents of $ msg to be displayed on the webpage.
HTML
<div id="addCommentContainer"> <form id="addCommentForm" action=""> <textarea name="msg" id="msg" cols="82" title="Your comment" rows="2">Your comment...</textarea> <br /> <input type="text" name="author" title="name" value="<?php echo $_SESSION['username']; ?>" id="author" /> <br /> <div id="personal"> <input type="text" name="city" id="city" title="city (optional)" value="" /> <br /> <input type="text" name="email" id="email" title="e-mail (optional)" value="" /> <br /> <input type="text" name="url" id="url" title="website (optional)" value="" /> <input type="hidden" id="cam_id" class="hd" name="cam_id" value="<?php echo $cam_id ?>" /> </div> <input type="submit" id="submit" value="Comment" /> </form> </div>
Javascript
//if submit button is clicked $('#submit').click(function () { //start the ajax $.ajax({ //this is the php file that processes the data url: "/comment/insert.php", type: "POST", data: $("#addCommentForm").serialize(), contentType: "json", //success success: function (html) { //if returned 1/true (process success) if (html == 1) { //show the success message $('.done').fadeIn('slow'); //if process.php returned 0/false (send mail failed) } else alert('Sorry, unexpected error. Please try again later.'); } }); //cancel the submit button default behaviours return false; });
Php
$msg = $_POST['msg']; // echo $msg; $author = $_POST['author']; $email = $_POST['email']; $url = $_POST['url']; $city = $_POST['city']; // include ("/home/sionvalais/domains/skiweather.eu/public_html/v3/functions/strip.php"); if ($cam_id>1) { if ($author=='NAME') { $author='Anonymous'; } $host = gethostbyaddr($ip); // mysql_query ("set character_set_results='utf8'"); mysql_query("INSERT INTO sv_review (author,email,msg,cam_id,url,lud) VALUES ( N'".$author."', '".$email."', N'".$msg."', '".$cam_id."', '".$url."', NOW() )"); }
mark
source share