Social Buttons
  1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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

Discussion in 'PHP' started by Matt Ridge, Feb 20, 2012.

0
  1. #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.
    SEMrush
    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
    SEMrush
  2. EricBruggema

    EricBruggema Well-Known Member

    Messages:
    1,726
    Likes Received:
    25
    Best Answers:
    13
    Trophy Points:
    125
    #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
  3. Matt Ridge

    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