Code:
echo "<td>".'<input type="text" name="date_from[]" class="datepicker">'."</td>";
-
-
Virenderkanger, can you be more specific with your question? Are you referring to timestamps?? :-) -
I want to save date from datepicker to database. I m using datepicker for no. of times but i m unable to save date to database. I can only save last selected date to all fields.Comment
-
how many datepicker field(s) you have in your form?Comment
-
It depends on driver name that i m fetching from database.Comment
-
if that so, put a unique id to your datepickerfield .
your $id must be the id in your database, or the incremental one.Code:<input type="text" name="date_from[]" class="datepicker" id="uniqueid_'.$id.'">
Comment
-
I tried it using counter as u described($id).Comment
-
what happened? is it still saving the last datepicker value?Comment
-
using date as array it is not saving any value. it is saving 00-00-00.Will i use this id?Comment
-
try to change the type of your date, make it varcharComment
-
It is looking impossible using varchar.Comment
-
If i use unique id then i can select date from datepicker for first field only.Comment
-
can you please post the codes you made?Comment
-
Code:<!DOCTYPE html> <html> <head> <link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css" rel="stylesheet" type="text/css"/> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script> <script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js"></script> <script> $(document).ready(function() { $(".datepicker").datepicker() }); </script> </head> <body> <?php error_reporting(E_PARSE); $status = $_POST['status']; $driver_name= $_POST['driver_name']; $from=date('y-m-d',strtotime($_POST['date_from'])); $to=date('y-m-d',strtotime($_POST['date_to'])); $conn = mysqli_connect('localhost', 'root', '', 'punbus') or die("Database not connected" . mysqli_error()); if(isset($_POST['sub'])) { foreach($status as $k=>$s){ $ins = "insert into driver_status(driver_name,status,date_from,date_to) VALUES ('".$driver_name[$k]."','$s','$from','$to')"; $quer=mysqli_query($conn,$ins); } if($quer){ echo "Updated"; }else{ echo"Unable to update.".mysqli_error($conn); } } $sel = 'select Driver_name from driver_master'; $query = mysqli_query($conn, $sel); echo "<form action='driver_status.php' method='post'>"; echo "<table cellpadding=5>"; echo "<tr>"; echo "<th>Driver Name</th>"; echo "<th>Status</th>"; echo "<th>From</th>"; echo "<th>To</th>"; echo "</tr>"; while($row=mysqli_fetch_assoc($query)){ echo "<tr><td>".$row['Driver_name'] ."<input type=\"hidden\" name=\"driver_name[]\" value=\"".$row['Driver_name']."\"/></td>"; $sel1='select d_status from status'; $query1=mysqli_query($conn,$sel1); echo "<td><select name=\"status[]\">"; while($row1=mysqli_fetch_assoc($query1)){ echo "<option value=\"".$row1['d_status']."\">".$row1['d_status']."</option>"; } echo "</select></td>"; echo "<td>".'<input type="text" name="date_from" class="datepicker"/>'."</td>"; echo "<td>".'<input type="text" name="date_to" class="datepicker"/>'."</td>"; echo "</tr>"; } echo "</table>"; echo '<input type="submit" name="sub" value="Update"/>'; echo "</form>"; ?> </body> </html>Last edited by Rabbit; Mar 11 '15, 03:40 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.Comment
-
try this one, your name also must be unique.Code:<input type="text" name="date_from_'.$id.'" class="datepicker" id="uniqueid_'.$id.'">
Comment
Comment