Posting correctly, just not allowing to get correctly...

Matt Ridge Peon

Messages:: 166

Likes Received:: 0

Best Answers:: 1

Trophy Points:: 0

#1

Ok, for some reason a page that was once working correctly is no longer working, and I've changed nothing on it for over 2 months.

Here is the error:

Here is the code, now if you look, at the code, which is long, don't get me wrong... line 104 shows the correct line of code as far as I can tell, and the query is coming back correctly too... so I don't know why this is happening now... Can someone please help me out, it be greatly appreciated. And yes I can use a function, but honestly until I get this working, I am trying to keep the code as short as possible.


<?php
require_once('../connectvars.php');
echo '<div id="postwrap">'
?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <title>PDI NCMR - Edit</title>
      <link rel="stylesheet" type="text/css" href="../CSS/postie.css" />
</head>
<body>
   <div id="logo">
	<img src="../images/PDI_Logo_2.1.gif" alt="PDI Logo" />
</div>


<?php
  if (isset($_POST['submit'])) {
// Connect to the database
    $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	
// Enter data into the database
	$id = mysqli_real_escape_string($dbc, trim($_GET['id']));
	$ab = mysqli_real_escape_string($dbc, trim($_POST['ab']));
	$date = mysqli_real_escape_string($dbc, trim(date('Y-m-d',strtotime ($_POST['date']))));
	$part = mysqli_real_escape_string($dbc, trim($_POST['part']));
	$rev = mysqli_real_escape_string($dbc, trim($_POST['rev']));
	$partdesc = mysqli_real_escape_string($dbc, trim($_POST['partdesc']));
	$ncmrqty = mysqli_real_escape_string($dbc, trim($_POST['ncmrqty']));
	$comp = mysqli_real_escape_string($dbc, trim($_POST['comp']));
	$ncmrid = mysqli_real_escape_string($dbc, trim($_POST['ncmrid']));
	$rma = mysqli_real_escape_string($dbc, trim($_POST['rma']));
	$jno = mysqli_real_escape_string($dbc, trim($_POST['jno']));
	$fdt = mysqli_real_escape_string($dbc, trim($_POST['fdt']));
	$cof = mysqli_real_escape_string($dbc, trim($_POST['cof']));
	$fab1= mysqli_real_escape_string($dbc, trim($_POST['fab1']));
	$fab2= mysqli_real_escape_string($dbc, trim($_POST['fab2']));
	$fab3= mysqli_real_escape_string($dbc, trim($_POST['fab3']));
	$non= mysqli_real_escape_string($dbc, trim($_POST['non']));
	$dis= mysqli_real_escape_string($dbc, trim($_POST['dis']));
	$comm= mysqli_real_escape_string($dbc, trim($_POST['comm']));
	$caad= mysqli_real_escape_string($dbc, trim($_POST['caad']));
	$po= mysqli_real_escape_string($dbc, trim($_POST['po']));
	$pod = mysqli_real_escape_string($dbc, trim(date('Y-m-d',strtotime($_POST['pod']))));
	$dri = mysqli_real_escape_string($dbc, trim(date('Y-m-d',strtotime($_POST['dri']))));


	$query = "UPDATE ncmr SET ab = '$ab', date = '$date', part = '$part', rev = '$rev' , partdesc = '$partdesc' , ncmrqty = '$ncmrqty' , comp = '$comp' , ncmrid = '$ncmrid' , rma = '$rma' , jno = '$jno' , fdt = '$fdt' , cof = '$cof' , fab1 = '$fab1' , fab2 = '$fab2' , fab3 = fab3' , non = '$non' , dis = '$dis' , comm = '$comm' , caad = '$caad' , po = '$po' , pod = '$pod' , dri = '$dri'  WHERE id = '$id'";


// echo your raw query and look for obvious errors
     echo "Query is : " . $query . "<br />";
  
// and at least use a basic mechanism to trap possibles errors
       mysqli_query($dbc, $query)  or die('Query Error : ' . mysqli_error($dbc));


// Clear the data to clear the form
	$id = "";
	$ab = "";
	$date = "";
	$part = "";
	$rev = "";
	$partdesc = "";
	$ncmrqty = "";
	$comp = "";
	$ncmrid = "";
	$rma = "";
	$jno = "";
	$fdt = "";
	$cof = "";
	$fab1= "";
	$fab2= "";
	$fab3= "";
	$non= "";
	$dis= "";
	$comm= "";
	$caad= "";
	$po= "";
	$pod = "";
	$dri = "";			
// Confirm success with the user
		echo '<p>If you wish to edit more NCMRs, please <a href="list.php">go to the admin page!</a></p>';


			mysqli_close($dbc);
			}
	
  else {	
 
// Connect to the database
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
// Grab the profile data from the database
  if (!isset($_GET['id'])) {
    $query = "SELECT * FROM ncmr WHERE id = '$id'";
  }
  else {
    $query = "SELECT * FROM ncmr WHERE id = '" . $_GET['id'] . "'";
  }
// echo your raw query and look for obvious errors
     echo "Query is : " . $query . "<br />";
  
// and at least use a basic mechanism to trap possibles errors
       mysqli_query($dbc, $query)  or die('Query Error : ' . mysqli_error($dbc));


  if (mysqli_num_rows($id) == 1) { 
// The user row was found so display the user data
    $row = mysqli_fetch_array($data);
    echo'<div id="title"><h3 id="NCMR2">Non-Conforming Materials Report (NCMR:&nbsp;&nbsp;' . $row['rma'] . ')</h3></div>';
echo "<form action='".$_SERVER['PHP_SELF']."' method='post'>";
	echo '<fieldset>';
			
		echo '<div id="box1">';
			if (empty($row['ab'])) $row['ab'] = "Empty";
			if (empty($row['date'])) $row['date'] = "Empty";
			if (empty($row['part'])) $row['part'] = "Empty";
			if (empty($row['rev'])) $row['rev'] = "Empty";
			if (empty($row['partdesc'])) $row['partdesc'] = "Empty";
			if (empty($row['ncmrqty'])) $row['ncmrqty'] = "Empty";
			echo '<div id="ab"><span class="b">Added By:&nbsp;&nbsp;</span><input type="text" name="ab" value="' . $row['ab'] . '" /></div>';
			echo '<div id="date"><span class="b">Date Filed:&nbsp;&nbsp;</span><input type="text" name="date" value="' . $row['date'] . '" /></div>';
			echo '<div id="part"><span class="b">Part Number:&nbsp;&nbsp;</span><input type="text" name="part" value="' . $row['part'] . '" /></div>';
			echo '<div id="rev"><span class="b">Part Revision:&nbsp;&nbsp;</span><input type="text" name="rev" value="' . $row['rev'] . '" /></div>';
			echo '<div id="partdesc"><span class="b">Part Description:&nbsp;&nbsp;</span><textarea rows="4" cols="22">' . $row['partdesc'] . '</textarea></div>';
			echo '<div id="ncmrqty"><span class="b">NCMR Qty:&nbsp;&nbsp;</span><input type="text" name="ncmrqty" value="' . $row['ncmrqty'] . '" /></div>';
		echo '</div>';


//Company, Customer NCMR, Internal RMA, and Job Number
		echo '<div id="box2">';
			if (empty($row['comp'])) $row['comp'] = "Empty";
			if (empty($row['ncmrid'])) $row['ncmrid'] = "Empty";
			if (empty($row['rma'])) $row['rma'] = "Empty";
			if (empty($row['jno'])) $row['jno'] = "Empty";
				echo '<div id="comp"><span class="b">Company:&nbsp;&nbsp;</span><input type="text" name="comp" value="' . $row['comp'] . '" /></div>';
					echo '<div id="ncmrid"><span class="b">Customer NCMR ID:&nbsp;&nbsp;</span><input type="text" name="ncmrid" value="' . $row['ncmrid'] . '" /></div>';
					echo '<div id="rma"><span class="b">Internal RMA #:&nbsp;&nbsp;</span><input type="text" name="rma" value="' . $row['rma'] . '" /></div>';
					echo '<div id="jno"><span class="b">Job #:&nbsp;&nbsp;</span><input type="text" name="jno" value="' . $row['jno'] . '" /></div>';
		echo '</div>';
			
//Type of Failure and Class of Failure
		echo '<div id="box3">';
			echo '<h2>Failure</h2>';
				echo '<div id="cof"><span class="b">Class of Failure:&nbsp;&nbsp;</span><input type="text" name="cof"  size="15" value="' . $row['cof'] . '" /></div>';
				echo '<div id="fdt"><span class="b">Failure Due To:&nbsp;&nbsp;</span><input type="text" name="fdt"  size="15" value="' . $row['fdt'] . '" /></div>';
		echo '</div>';


//Fabricators
		echo '<div id="box4">';
			echo '<h2>Fabricators</h2>';
if ($row['fab1']="--None--")
{
    echo'<div id="fab1">';
    $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); 
    $mysqli->select_db('user');
    $result = $mysqli->query("SELECT * FROM user"); 
    echo "<SELECT name='fab1'>\n";
    while($row = $result->fetch_assoc())
    {
        echo "<option value='{$row['user']}'>{$row['user']}</option>\n";
    }
    echo "</select>\n";
    echo '</div>';
}
else
{
    echo'<div id="fab1">';
    $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); 
    $mysqli->select_db('user');
    $result = $mysqli->query("SELECT * FROM user"); 
    echo "<SELECT name='fab1'>\n";
    while($row = $result->fetch_assoc())
    {
        echo "<option value='{$row['user']}'>{$row['user']}</option>\n";
    }
    echo "</select>\n";
    echo '</div>';
}




if ($row['fab2']="--None--")
{
    echo'<div id="fab2">';
    $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); 
    $mysqli->select_db('user');
    $result = $mysqli->query("SELECT * FROM user"); 
    echo "<SELECT name='fab2'>\n";
    while($row = $result->fetch_assoc())
    {
        echo "<option value='{$row['user']}'>{$row['user']}</option>\n";
    }
    echo "</select>\n";
    echo '</div>';
}
else
{
    echo '<div id="fab2"><span class="b"></span><input type="text" name="fab1"  size="20" value="' . $row['fab1'] . '" /></div>';
    echo '</div>';
}
if ($row['fab3']="--None--")
{
    echo'<div id="fab3">';
    $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); 
    $mysqli->select_db('user');
    $result = $mysqli->query("SELECT * FROM user"); 
    echo "<SELECT name='fab3'>\n";
    while($row = $result->fetch_assoc())
    {
        echo "<option value='{$row['user']}'>{$row['user']}</option>\n";
    }
    echo "</select>\n";
    echo '</div>';
}
else
{
    echo '<div id="fab3"><span class="b"></span><input type="text" name="fab1"  size="20" value="' . $row['fab1'] . '" /></div>';
    echo '</div>';
}		echo '</div>';


//Nonconformity, Disposition, Comments and Comments & Additional Details
		echo '<div id="box5">';
			if (empty($row['non'])) $row['non'] = "Empty";
			if (empty($row['dis'])) $row['dis'] = "Empty";
			if (empty($row['comm'])) $row['comm'] = "Empty";
			if (empty($row['caad'])) $row['caad'] = "Empty";


			echo '<div id="non"><span class="b">Nonconformity:&nbsp;&nbsp;</span><textarea rows="4" cols="105">' . $row['non'] . '</textarea></div>';
			echo '<div id="dis"><span class="b">Disposition:&nbsp;&nbsp;</span><textarea rows="4" cols="105">' . $row['dis'] . '</textarea></div>';
			echo '<div id="comm"><span class="b">Comments:&nbsp;&nbsp;</span><textarea rows="4" cols="105">' . $row['comm'] . '</textarea></div>';
			echo '<div id="caad"><span class="b">Comments and/or Additional Details:&nbsp;&nbsp;</span><textarea rows="4" cols="105">' . $row['caad'] . '</textarea></div>';


				echo '<div id="podr">';
						if (empty($row['po'])) $row['po'] ="Empty";
						if (empty($row['pod'])) $row['pod'] ="Empty";
						if (empty($row['dir'])) $row['dri'] ="Empty";


					echo '<div id="po"><span class="b">PO:&nbsp;&nbsp;</span><input type="text" name="po"  size="7" value="' . $row['po'] . '" /></div>';
					echo '<div id="pod"><span class="b">PO Date:&nbsp;&nbsp;</span><input type="text" name="pod"  size="7" value="' . $row['pod'] . '" /></div>';
					echo '<div id="dri"><span class="b">Date Received:&nbsp;&nbsp;</span><input type="text" name="dri"  size="7" value="' . $row['dri'] . '" /></div>';
				echo '</div>';
			echo '<div id="button2"><input type="submit" value="Submit Edits" name="submit" /></div>';
		echo '</div>';
	echo '</fieldset>';
echo '</form>';
		}
	}


echo '</div>';


?>
</body>
</html>

Code (markup):

Matt Ridge, Feb 20, 2012 IP

EricBruggema Well-Known Member

Messages:: 1,740

Likes Received:: 28

Best Answers:: 13

Trophy Points:: 175

#2

Have you tried to executing your query in phpmyadmin? and wich line is 104?

split the code there [ / code ] line 105 start here [ code ]

EricBruggema, Feb 20, 2012 IP

Matt Ridge Peon

Messages:: 166

Likes Received:: 0

Best Answers:: 1

Trophy Points:: 0

#3

I figured what it was, it was a typo on my end, thanks for the help though

Matt Ridge, Feb 20, 2012 IP

Log in or Sign up

Advertising (learn more)

Posting correctly, just not allowing to get correctly...

Matt Ridge Peon

EricBruggema Well-Known Member

Matt Ridge Peon

Log in or Sign up

Advertising (learn more)

Posting correctly, just not allowing to get correctly...

Matt Ridge Peon

EricBruggema Well-Known Member

Matt Ridge Peon

Useful Searches