Storing information to database using JavaScript prompt function

Asked Jan 25 '16 at 15:50

Active Jan 25 '16 at 16:14

Viewed 59 times

If I were to do a JavaScript prompt and allow a user to enter the information, how do I store this information into the database?

<?php 
if(isset($_GET['cancel_req_id']))
{

    echo "<script>var reason = prompt('Reason')</script>";
  $res = "<script>document.write(reason)</script>";

              $query="UPDATE booking SET status='Cancelled', s_approval='', s_authorize='', cancellation='$res' WHERE req_id='$id'";
              $result=$conn->query($query);

                    echo "<script>alert('Booking cancelled!')</script>";
                    echo "<script>window.location=('status.php')</script>";


}
?>

this is my current code.

edited Jan 25 '16 at 16:14

asked Jan 25 '16 at 15:50

Xdf123

mysqli! i search the net and they told me to use ajax! but i am not familiar with ajax!n so if anyone could help me with ajax i would appreciate much – Xdf123 Jan 25 '16 at 15:56
then you should first search something by yourself, and only then ask here if you've some problem. what have you tried? – Federkun Jan 25 '16 at 15:57
sorry! but yea i tried to do it with ajax but it doesnt work! hahas – Xdf123 Jan 25 '16 at 15:59
**what** have you tried? post your code here – Federkun Jan 25 '16 at 16:00
@Federico hi sir i have updated the code – Xdf123 Jan 25 '16 at 16:15
http://stackoverflow.com/questions/2338942/access-a-javascript-variable-from-php – pablito.aven Jan 25 '16 at 18:38

Storing information to database using JavaScript prompt function

0 Answers0