Databases
StackOverflow2013
Postsdbo
POhow to update in database using ajax call in php
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POhow to update in database using ajax call in php
    primarykey
    data
    text
    <p>For now my php page updates a column in DB using form $_POST but how to do it without submitting using ajax my current code is below . how to do it in ajax so that it updates in the column completed as 1 or 2 or 3 or 4</p> <pre><code>&lt;html&gt; &lt;head&gt; &lt;script language="JavaScript" type="text/javascript" src="js/jquery.js"&gt;&lt;/script&gt; &lt;script language="JavaScript" type="text/javascript"&gt; function show(){ document.getElementById("completetrips").style.display='inline'; } function hide(){ document.getElementById("completetrips").style.display='none'; } &lt;/script&gt; &lt;style&gt; .color1 { background-color:green; } .color2 { background-color:red; } .color3 { background-color:orange; } .color4 { background-color:skyblue; } &lt;/style&gt; &lt;/head&gt; &lt;body&gt; &lt;div align="center" style="font-familt:calibri; font-size: 20px"&gt; &lt;form name="select_dates" id= "select_dates" action="" method = "POST" style="font-size: 24px; font-family:calibri"&gt; &lt;select name="date"&gt; &lt;?php $date = date('d-m-Y'); $i=0; $time = strtotime($date)-6*86400; while($i&lt;5){ $time+=86400; $date1=date('d-m-Y', $time); echo '&lt;option value="'.$date1.'"&gt;'.$date1.'&lt;/option&gt;'; $i++;} echo '&lt;option value="'.$date.'" selected&gt;'.$date.'&lt;/option&gt;'; $time = strtotime($date)+0*86400; $i=0; while($i&lt;5){ $time+=86400; $date1=date('d-m-Y', $time); echo '&lt;option value="'.$date1.'"&gt;'.$date1.'&lt;/option&gt;'; $i++;} ?&gt; &lt;/select&gt; &lt;br&gt; &lt;input type="submit" id="submit" name="submit" value="submit"/&gt;&lt;br&gt; &lt;!-- my code --&gt; &lt;input type="submit" style="float:right;margin-top:80px;margin-right:10px;" id="load" name="submit" value="Refresh"/&gt; &lt;!-- end of my code --&gt; &lt;/form&gt; &lt;/div&gt; &lt;div id="clear" style="height: 5px; width:100%; bgcolor:#1c7bcc"&gt;&lt;/div&gt; &lt;/body&gt; &lt;/html&gt; &lt;?php if (isset($_POST['submit'])){ $date_today = $_POST['date']; error_reporting(E_ALL); $conn = mysql_connect('localhost', 'root', 'root') or die("error connecting1..."); mysql_select_db("demo",$conn) or die("error connecting database..."); $timezone = 'Asia/Kolkata'; date_default_timezone_set($timezone); $query = "Select * from `trips` where `date` = '$date_today' ORDER BY `trips`.`book_id` ASC"; if (!mysql_query($query)){echo "not found";} else{ $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { // if statemnet here for completed == 0 and hence hide after complettion. // display results echo '&lt;html&gt;&lt;head&gt;&lt;title&gt; Trips Today&lt;/title&gt;'; echo '&lt;div align="center" style="font-family:calibri; font-size:25px "&gt;'; echo '&lt;table align="center" &gt;&lt;tr&gt;&lt;td&gt;'; echo "Number of trips for the day: "; echo '&lt;/td&gt;&lt;td&gt;&lt;b&gt;'; echo mysql_num_rows($result)-1; echo '&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;'; echo "Day of considertaion is a "; echo '&lt;b&gt;'; echo date("l",strtotime($date_today)); echo '&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/td&gt;&lt;td&gt;'; echo $date_today; echo '&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;'; echo "&lt;/div&gt; &lt;button type='button' onclick='hide()'&gt;Hide trips&lt;/button&gt; &lt;button type='button' onclick='show()'&gt;show trips&lt;/button&gt;&lt;br&gt;"; echo "&lt;div id='completetrips' style='display:inline'&gt; "; echo "&lt;table align='center' id='tab' border='1' cellspacing='2'&gt;"; echo "&lt;tr align='center'&gt;"; echo" &lt;th align='center'&gt;Trip_id&lt;/th&gt;"; echo "&lt;th align='center'&gt;user_id&lt;/th&gt;"; echo "&lt;th&gt;book_id&lt;/th&gt;&lt;th&gt;name&lt;/th&gt;&lt;th&gt;source&lt;/th&gt;&lt;th&gt;destination&lt;/th&gt;&lt;th&gt;time&lt;/th&gt;&lt;th&gt;date&lt;/th&gt;&lt;th&gt;phone&lt;/th&gt;&lt;th&gt;group_id&lt;/th&gt;&lt;th&gt;Driver id&lt;/th&gt;&lt;th&gt;Option 1&lt;/td&gt;&lt;th&gt;Option 2&lt;/td&gt;&lt;th&gt;Option 3&lt;/td&gt;&lt;th&gt;Option 4&lt;/td&gt;&lt;/tr&gt;&lt;br&gt;"; /* my code */ while($row=mysql_fetch_assoc($result)) { ?&gt; &lt;tr align='center' class="color&lt;?=$row['completed']?&gt;"&gt;&lt;td&gt;&lt;?=$row['trip_id']?&gt;&lt;/td&gt;&lt;td&gt;&lt;?=$row['user_id']?&gt;&lt;/td&gt;&lt;td&gt;&lt;?=$row['book_id']?&gt;&lt;/td&gt;&lt;td&gt;&lt;?=$row['name']?&gt;&lt;/td&gt;&lt;td&gt;&lt;?=$row['source']?&gt;&lt;/td&gt;&lt;td&gt;&lt;?=$row['destination']?&gt;&lt;/td&gt;&lt;td&gt;&lt;?=$row['time']?&gt;&lt;/td&gt;&lt;td&gt;&lt;?=$row['date']?&gt;&lt;/td&gt;&lt;td&gt;&lt;?=$row['phone']?&gt;&lt;/td&gt;&lt;td&gt;&lt;?=$row['group_id']?&gt;&lt;/td&gt;&lt;td&gt;&lt;?=$row['driver_id']?&gt;&lt;/td&gt; &lt;td&gt; &lt;button name="completed" class="complete"&gt;Completed&lt;/button&gt;&lt;/td&gt; &lt;td&gt;&lt;button name="cancelbyus" class="cancel"&gt;Cancelled by Us&lt;/button&gt;&lt;/td&gt; &lt;td&gt;&lt;button name="cancelbycus" class="cancelcus"&gt;Cancelled by Customer&lt;/button&gt;&lt;/td&gt; &lt;td&gt;&lt;button name="completebutlate" class="completelate"&gt;Complete but Late&lt;/button&gt;&lt;/td&gt; &lt;input name="tripid" id="tripid" style="display:none" value="&lt;?=$row['trip_id']?&gt;" /&gt;&lt;/tr&gt; &lt;?PHP } }// display ends }// while rows for todAY }// if submit if(isset($_POST['completed'])) { $conn = mysql_connect('localhost', 'root', 'root') or die("error connecting1..."); mysql_select_db("cubitoindemo",$conn) or die("error connecting database..."); $tripid = $_POST['tripid']; $update_trips = "UPDATE trips SET completed = 1 where trip_id = '$tripid'"; $quer = mysql_query($update_trips); } if(isset($_POST['cancelbyus'])) { $conn = mysql_connect('localhost', 'root', 'root') or die("error connecting1..."); mysql_select_db("cubitoindemo",$conn) or die("error connecting database..."); $tripid = $_POST['tripid']; $update_trips = "UPDATE trips SET completed = 2 where trip_id = '$tripid'"; $quer = mysql_query($update_trips); } if(isset($_POST['cancelbycus'])) { $conn = mysql_connect('localhost', 'root', 'root') or die("error connecting1..."); mysql_select_db("cubitoindemo",$conn) or die("error connecting database..."); $tripid = $_POST['tripid']; $update_trips = "UPDATE trips SET completed = 3 where trip_id = '$tripid'"; $quer = mysql_query($update_trips); } if(isset($_POST['completebutlate'])) { $conn = mysql_connect('localhost', 'root', 'root') or die("error connecting1..."); mysql_select_db("cubitoindemo",$conn) or die("error connecting database..."); $tripid = $_POST['tripid']; $update_trips = "UPDATE trips SET completed = 4 where trip_id = '$tripid'"; $quer = mysql_query($update_trips); } /* end of my code */ ?&gt; &lt;/div&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USgokul
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POhow to update in database using ajax call in php
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POhow to update in database using ajax call in php
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POhow to update in database using ajax call in php
      1. This table or related slice is empty.
      1. VTDownMod
    1. COthis is a whole lot of code to be confused!
      singulars
      1. POhow to update in database using ajax call in php
      1. USGurminder Singh
    2. COWe are not here to bake a cake for you when you don't know how to.
      singulars
      1. POhow to update in database using ajax call in php
      1. USJoran Den Houting
    3. COi didnt asked you the code i was asking how that all @JoranDenHouting
      singulars
      1. POhow to update in database using ajax call in php
      1. USgokul
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload