[RESOLVED] issue with edit php page

ianhaney

I am trying to populate a form ready to update the data and have managed to get the id number displaying in the input field but for every other input field, it displays the following

Notice: Undefined index: customer_name in /home/sites/it-doneright.co.uk/public_html/admin/repairs-tracking/edit-repair-tracking.php on line 40

I really don't get it or see where I am going wrong with it, below is the whole code on the edit-repair-tracking.php page


<form action="update-admin-repair-tracking.php" method="post">
Repair ID: <input value="<?= $_GET['id'] ?>" name="id"/>
Customer Name: <input type="text" name="customer_name" value="<?= $_GET['customer_name'] ?>">
Customer Email: <input type="text" name="customer_email" value="<?= $_GET['customer_email'] ?>">
Customer Phone: <input type="text" name="customer_phone" value="<?= $_GET['customer_phone'] ?>">
Computer Make: <input type="text" name="computer_make" value="<?= $_GET['computer_make'] ?>">
Computer Model: <input type="text" name="computer_model" value="<?= $_GET['computer_model'] ?>">
Technician:
<select name="technician" id="technician">
<option value="Not Assigned">Not Assigned</option>
<option value="Phil Roskams">Phil Roskams</option>
<option value="Ian Haney">Ian Haney</option>
</select>

Status:
<select name="status" id="status">
<option value="Not Started">Not Started</option>
<option value="In Queue">In Queue</option>
<option value="On Bench / Working">On Bench / Working</option>
<option value="Awaiting Parts">Awaiting Parts</option>
<option value="Awaiting Customer">Awaiting Customer</option>
<option value="Completed">Completed</option>
</select>

Expected Repair Date: <input type="date" name="exrdate" value="<?= $_GET['exrdate'] ?>">

Expected Repair Time: <input type="time" name="exrtime" value="<?= $_GET['exrtime'] ?>">

Expected Start Date<input type="date" name="exstdate" value="<?= $_GET['exstdate'] ?>">

Expected Start Time: <input type="time" name="exstime" value="<?= $_GET['exstime'] ?>">

Delivery Type:
<select name="deltype" id="deltype">
<option value="Self Pickup">Self Pickup</option>
<option value="Deliver to Customer">Delivery to Customer</option>
</select>

Comments:
<br>
<textarea name="comments" cols="50" rows="3" id="comments"><?= $_GET['comments'] ?></textarea>

<input type="submit" name="submit">
</form>

</body>
</html>

Can someone help me please as been trying to work out what I am missing for a good hour now

Thank you in advance

Weedpacket

You're missing values for those elements of the [font=monospace]$GET[/font] array. If your form is using [font=monospace]method="post"[/font] then you should be looking in the [font=monospace]$POST[/font] array.
Of course, you can't simply assume that they'll always be there anyway: you should check they exist before you use them, and have some suitable alternative to use if they don't.

ianhaney

Ok so if I replace $GET to $POST instead, I did a var dump code and that outputted the following if it helps

array(1) { ["id"]=> string(2) "20" }

Also below is the code from the view page that calls the edit page

<?php
ini_set('display_startup_errors',1);
ini_set('display_errors',1);
error_reporting(-1);
?>

<!DOCTYPE html>
<html>
<head>
<title>IT Done Right Admin Repair Tracking</title>

<link rel="stylesheet"href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.11.2/themes/blitzer/jquery-ui.css"/>
<script src="//code.jquery.com/jquery-1.10.2.js"></script>
<script src="//code.jquery.com/ui/1.11.2/jquery-ui.js"></script>

<script src="js/jquery.ui.timepicker.js"></script>
<link rel="stylesheet"href="css/jquery.ui.timepicker.css"/>

<link rel="stylesheet" type="text/css" media="screen" href="css/styles.css" />

<script>
$(document).ready(function() {
                  $('#exrtime').timepicker({
					defaultTime: '12:00',
  					showLeadingZero: true,
					showNowButton: true,
  				    showCloseButton: true,
  	    			showDeselectButton: true,
  					showOn: 'both',
  				});

			$('#exstime').timepicker({
				defaultTime: '12:00',
				showLeadingZero: true,
				showNowButton: true,
			    showCloseButton: true,
    			showDeselectButton: true,
				showOn: 'both',
			});
});
</script>

</head>
<body>

<div id="logo">
<img src="images/logo/it-done-right.jpg" alt="" title="">
</div>

<?
session_start();
if($_SESSION['user']==''){
 header("Location:../index.php");
}else{
 include("../config.php");
 $sql=$dbh->prepare("SELECT * FROM users WHERE id=?");
 $sql->execute(array($_SESSION['user']));
 while($r=$sql->fetch()){
  echo "<div class='home-content'>";
  echo "<center><h2>Hello, ".$r['username']."</h2>";
  echo "<a href='../logout.php'>Log Out</a>";
  echo "<br><br>";
  echo "<a href='../home.php'>Home</a></center>";
  echo "</div>";
 }
}
?>

<?php
        $host = '';
        $user = '';
        $password = '';
        $dname = '';

    $db = new mysqli($host, $user, $password, $dname);

    if ($db->connect_errno) {
        echo "Failed to connect to MySQL: ("
        . $db->connect_errno . ") " . $db->connect_error;
    }

    $sql = "SELECT id, customer_name, customer_email, customer_phone, computer_make, computer_model, technician, status, exrdate, exrtime, exstdate, exstime, deltype, comments FROM repairs";
    $result_db = $db->query($sql) or die('Error perform query!');
    ?>

<table border="1">
            <tr>
                <th>Repair ID</th>
                <th>Customer Name</th>
                <th>Customer Email</th>
                <th>Customer Phone</th>
                <th>Computer Make</th>
                <th>Computer Model</th>
                <th>Technician</th>
                <th>Status</th>
                <th>Expected Repair Date</th>
                <th>Expected Repair Time</th>
                <th>Expected Start Date</th>
                <th>Expected Start Time</th>
                <th>Delivery Type</th>
                <th>Comments</th>
                <th>Update</th>
            </tr>
            <?php
            while ($r = $result_db->fetch_object()) {
                $update = "admin/repairs-tracking/edit-repair-tracking.php?id={$r->id}";
                echo '<tr>';
                echo '<td>' . $r->id . '</td>';
                echo '<td>' . $r->customer_name . '</td>';
                echo '<td>' . $r->customer_email . '</td>';
				echo '<td>' . $r->customer_phone . '</td>';
				echo '<td>' . $r->computer_make . '</td>';
				echo '<td>' . $r->computer_model . '</td>';
				echo '<td>' . $r->technician . '</td>';
				echo '<td>' . $r->status . '</td>';
				echo '<td>' . $r->exrdate . '</td>';
				echo '<td>' . $r->exrtime . '</td>';
				echo '<td>' . $r->exstdate . '</td>';
				echo '<td>' . $r->exstime . '</td>';
				echo '<td>' . $r->deltype . '</td>';
				echo '<td>' . $r->comments . '</td>';
                echo "<td><a href='/{$update}'>Update</a></td>";
                echo '</tr>';
            }
            $db->close();
            ?>    

        </table>
</body>
</html>