in php code have faces 2 problem. code below:
file name: editevent.php
<?php $server_name = 'localhost'; $username ='root'; $password =''; $db_name ='reminder'; $connect_error = 'sorry, we\'re experiencing connection problems.'; $con = mysql_connect($server_name, $username, $password); if(!$con){ die($connect_error); } mysql_select_db($db_name) or die($connect_error); ?> <?php if (isset($_post['update_event'])) { $update_query = "update calendar_event set send_date = '$_post[date]', send_time = '$_post[time]', event_name = '$_post[event_name]', message = '$_post[message]', email = '$_post[email]', phone_no = '$_post[phone_no]' id= '$_post[id]'"; mysql_query($update_query, $con); } $sql = "select * calendar_event"; $mydata = mysql_query($sql, $con); while($record = mysql_fetch_array($mydata)){ ?> <html lang="en"> <head> <meta charset="utf-8"> <title>add event</title> <link rel="stylesheet" href="css/index.css"> <link rel="stylesheet" href="css/addevent.css"> <link rel="stylesheet" href="css/editevent.css"> </head> <body> <form action="editevent.php" method="post"> <ul> <div class="time_date"> <li class="date"> date: <br> <input type="date" name="date" value="<?php echo $record['send_date']; ?>"/> </li> <li class="time"> time: <br> <input type="time" name="time" value="<?php echo $record['send_time']; ?>"/> </li> </div> <li> event name: <br> <input type="text" name="event_name" style="width: 285px;" value="<?php echo $record['event_name']; ?>"/> </li> <li> message: <br> <textarea name="message" style="width: 285px; height: 100px;"><?php echo $record['message']; ?></textarea> </li> <div class="email_phoneno"> <li class="email"> email: <br> <input type="email" name="email" style="width: 150px;" placeholder="example@email.com" maxlength="30" value="<?php echo $record['email']; ?>"> </li> <li class="phoneno"> phone no: <br> <input type="tel" style="width: 100px;" name="phone_no" value="<?php echo $record['phone_no']; ?>"/> </li> </div> <div class="update_delete_button"> <li class="save_button"> <input type="submit" value="save event" name="update_event"> </li> </div> </ul> </form> <li><a href="index.php">home</a></li> </body> </html> <?php break 1; } mysql_close($con); ?> when run code shows
***notice: undefined index: `id` in `c:\xampp\htdocs\window\editevent.php` on line 19*** when avoid where clause full database table has been updated. how can solve it?
note: id auto-increment column in table.
add code inside form tag
<input type="id" type="hidden" style="width: 100px;" name="id" value="<?php echo $record['id']; ?>"/> 
Comments
Post a Comment