How to excute mysql query in php echo?

Question

I want to excute mysql query in php echo clause.. please help..

mysqli_query($mysqli2,$update_book); ----> does not work.

here is my code..

$mysqli2=mysqli_connect("localhost","root","","bookDB");

$update_book="UPDATE bookinfo SET Status ='No' WHERE BookName='Step by Step'";


 echo "<script language=javascript>
   var con_test = confirm('Are you ready?');
   if(con_test == true){
     mysqli_query($mysqli2,$update_book);
     alert('Complete.');
   }
   else if(con_test == false){
     alert('Canceled.');
   }
   </script>";

I wanto to chage database state by ok button.. – Yong.K Apr 18 '19 at 09:37 — Yong.K, Apr 18 '19 at 09:37
Share your html code here – Ziaur Rahman Apr 18 '19 at 09:41 — Ziaur Rahman, Apr 18 '19 at 09:41
just working in php page.. is it impossible?? – Yong.K Apr 18 '19 at 09:43 — Yong.K, Apr 18 '19 at 09:43

score 0 · Answer 1 · answered Apr 18 '19 at 09:37

0

You can't execute php code in a Javascript code.

You either need to use ajax (call a php file from the js code, check http://api.jquery.com/jquery.ajax/ for example), or redirect to another page when your confirm is clicked

answered Apr 18 '19 at 09:37

Thelt

81
5

How to excute mysql query in php echo?

1 Answers1