-
- <?php
- $db=new mysqli('localhost','root','');
- $db->select_db('timed');
- $search="select * from biao";
- $result = $db->query($search);
- $num_results = $result->num_rows;
- for ($i=0;$i<$num_results;$i++)
- {
- $row = $result->fetch_assoc();
- echo "name =".stripslashes($row['name'])."<br />";
- echo "time =".stripslashes($row['time'])."<p />";
- };
- //after change
- echo "after changed /'vin'+ 20 min/<p />";
- $results = $db->query("select time from biao where name = 'vin'");
- $row = $results->fetch_assoc();
- $tim = stripslashes($row['time']);
- $db->query("update biao set time=DATE_ADD('$tim',INTERVAL 20 minute) where name = 'vin'");
- $search="select * from biao";
- $result = $db->query($search);
- $num_results = $result->num_rows;
- for ($i=0;$i<$num_results;$i++)
- {
- $row = $result->fetch_assoc();
- echo "name =".stripslashes($row['name'])."<br />";
- echo "time =".stripslashes($row['time'])."<p />";
- };
- ?>
- <?php
- $db=new mysqli('localhost','root','');
- $db->select_db('timed');
- $search="select * from biao";
- $result = $db->query($search);
- $num_results = $result->num_rows;
- for ($i=0;$i<$num_results;$i++)
- {
- $row = $result->fetch_assoc();
- echo "name =".stripslashes($row['name'])."<br />";
- echo "time =".stripslashes($row['time'])."<p />";
- };
- //after change
- echo "after changed /'vin'+ 20 min/<p />";
- $results = $db->query("select time from biao where name = 'vin'");
- $row = $results->fetch_assoc();
- $tim = stripslashes($row['time']);
- $db->query("update biao set time=DATE_ADD('$tim',INTERVAL 20 minute) where name = 'vin'");
- $search="select * from biao";
- $result = $db->query($search);
- $num_results = $result->num_rows;
- for ($i=0;$i<$num_results;$i++)
- {
- $row = $result->fetch_assoc();
- echo "name =".stripslashes($row['name'])."<br />";
- echo "time =".stripslashes($row['time'])."<p />";
- };
- ?>