Mysql database update with ajax php not working

Question

I am trying to update mysql database table with button click. But database is not getting updated...

HTML Code :

<tr >
<td>Advt Heading :</td>
<td>
<input type="hidden" name="idnew" id="idnew" value="<?=$member_data['id']?>"> //retrieved from mysql database 

<input type="text" name="advt_headingnew" id="advt_headingnew" value="<?=stripslashes($member_data['advt_heading']);?>" /> //retrieved from mysql database ...**I want to edit its previus retreived value...and update database**

<input name="submit" type="button" id="submit" value="Update" />

</td>
</tr>

SCRIPT :

<script src="http://code.jquery.com/jquery.min.js"></script>  
<script>
$(document).ready(function () { 
$('#submit').click(function(){
var advt_headingnew = $("#advt_headingnew").val();
var idnew = $("#idnew").val();


$.ajax({
     type:'POST',
     url:'update-advt-heading.php',
     data: "advt_headingnew="+advt_headingnew+"&idnew="+idnew,

     success:function( msg ) {
     alert( "Data Saved: " + msg );
        }

 });
});
});


</script>

PHP - update-advt-heading.php CODE :

<?
$user_name = "databaseusername";
$password = "databasepassword";
$database = "databasename";
$server = "localhost";

mysql_connect($server, $user_name, $password);
$db_found = mysql_select_db($database);

$heading = $_POST['advt_headingnew'];
$id=$_POST["idnew"];

if (isset($_POST['submit'])){


   $queryStr = "UPDATE tablename SET advt_heading='$heading' WHERE id='$id'";
    if ( mysql_query($qyeryStr)){
        return "success!";
    }else{
        return "failed!";
    }
}

?>

You are not sending submit value through ajax that's why your if condition fails. As a NOTE: Don't use mysql extension as it is depricated and not even supported in php7. You should use mysqli instead. — Garvit Mangal
– Garvit Mangal, Commented May 21, 2016 at 14:34

Garvit Mangal · Accepted Answer · 2016-05-21 14:40:38Z

0

Change your js code to this

    $(document).ready(function () { 
        $('#submit').click(function(){
           var advt_headingnew = $("#advt_headingnew").val();
           var idnew = $("#idnew").val();
           var submitval = $(this).val();

           $.ajax({
             type:'POST',
             url:'update-advt-heading.php',
             data: "advt_headingnew="+advt_headingnew+"&idnew="+idnew+"&submit="+submitval,

             success:function( msg ) {
                alert( "Data Saved: " + msg );
             }

          });
       });
   });

answered May 21, 2016 at 14:40

Garvit Mangal

9007 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Garvit Mangal Over a year ago

Are you getting all values correctly through ajax in php script ??

Garvit Mangal Over a year ago

try changing <? to <?= or <?php

Garvit Mangal Over a year ago

got it you misspelled $queryStr in mysql_query(..)

Dr M L M J Over a year ago

what i think ....update_advt_heading.php is not getting value of advt_headingnew and idnew...

Garvit Mangal Over a year ago

Let us continue this discussion in chat.

|

Dr M L M J · Accepted Answer · 2016-05-22 14:47:31Z

0

I have changed

var advt_headingnew = $("#advt_headingnew").val();
var idnew = $("#idnew").val();

To

var advt_headingnew = document.getElementsByName("advt_headingnew")[0].value;
var idnew = document.getElementsByName("idnew")[0].value;

NOW IT IS WORKING..

answered May 22, 2016 at 14:47

Dr M L M J

2,3875 gold badges21 silver badges41 bronze badges

Collectives™ on Stack Overflow

Mysql database update with ajax php not working

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related