Jump to content

DB Error

cjohnson9

By cjohnson9
in PHP Coding Help

Recommended Posts

cjohnson9 Newbie

cjohnson9

Posted
Posted

Hey guys I have an error in my code and cannot figure out what it is. I am getting a syntax error message near "where asset="

 

thanks for the help in advance

<?php

/*Written by Clinton T. Johnson for Project Worldwide and George P. Johnson Companies...*/

session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>337 Department Info System</title>
<link rel="stylesheet" href="stylesheets/styles.css" type="text/css" />

            
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/slider.js"></script>
<script type="text/javascript" src="js/superfish.js"></script>
<script type="text/javascript" src="js/custom.js"></script>

</head>

<body>
<div id="container">
<div id="header">
    	<h1><a href="index.html">Pww</a></h1>
    	<h2>Asset Tracking System</h2>
        <div class="clear"></div>
  </div>
    <div id="nav">
    	<ul class="sf-menu dropdown">
        	<li class="selected"><a href="../../user/login.php">Login</a></li>
            <li class="selected"><a href="ah.php">Auburn Hills</a></li>
            <li class="selected"><a href="Loc/LA/la.php">Los Angeles</a></li>
            <li class="selected"><a href="Loc/SC/sc.php">San Carlos</a></li>
            <li class="selected"><a href="Loc/BOS/bos.php">Boston</a></li>
            <li class="selected"><a href="Loc/BNA/bna.php">Nashville</a></li>
        </ul>
  </div>
    <div id="body" class="has-slider">
      <div class="sidebar">
        <h4><span>GPJ Assets</span></h4> 
            <ul>
               
               <li>
               <li>
                 <p style="margin: 0;">  <?php

if ($_SESSION['username'])
{

echo "<p><b>My Account</b><br /><br />
  <a href=ah.php>Auburn Hills</a><br />
      <a href=Loc/LA/la.php>Los Angeles</a><br />
      <a href=Loc/SC/sc.php>San Carlos</a><br />
    <a href=Loc/BNA/bna.php>Nashville</a><br />
      <a href=../../user/logout.php>log out</a><br />
      <a href=../../user/account.php>Account Settings</a></p>";
}?>     
                 </p>
               </li>
            </ul>
            </li>
                  <h4><span>Options</span></h4>
                  <ul>
                      
                    <li>
                                           <?php
    if ($_SESSION['username'])
  {

echo "<p><b>My Account</b><br /><br />
  <a href=ah_add.php>Add Asset</a><br />
      <a href=ah_edit.php>Edit Asset</a><br />
      <a href=ah_delete.php>Delete Asset</a><br />
      <a href=../../user/account.php>Account Settings</a></p>";
}?>
    </p>
                    </li>
            </ul>
              </li>            
</div>
         <div id="content">
            <div class="box">
                <h2>Edit Auburn Hills Asset</h2>
                <br />
              <?php
		  
		  
if ($_SESSION['username'])
		   {$con = mysql_connect("localhost","root","c3rb3ru5");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("gpj_asset", $con);

//table header code
echo "
<table border='1'>
<tr>
<th>Asset ID#</th>
<th>location</th>
<th>active</th>
<th>platform</th>
<th>Make</th>
<th>Model</th>
<th>Memory</th>
<th>Warranty</th>
<th>Active User</th>
<th>Notes</th>
</tr>";

// Pagination
if(!empty($_GET["start"])){
    $start  = $_GET['start'];// To take care global variable if OFF
}else{
    $start   = 0;
}
if(!($start > 0)) { // This variable is set to zero for the first page
    $start = 0;
}

$eu   = ($start - 0);
$limit           = 5; // No of records to be shown per page.
$whathis      = $eu + $limit;
$back          = $eu - $limit;
$next          = $eu + $limit;

// to check the total number of records
$query         = mysql_query(" SELECT * FROM assets 
					WHERE location='Auburn Hills' ORDER BY asset_id ASC ") or die (mysql_error());
$total_rows     = mysql_num_rows($query);

//select the record with limitation
$query         = mysql_query(" SELECT * FROM assets 
					WHERE location='Auburn Hills' ORDER BY asset_id ASC limit $eu, $limit ") or die (mysql_error());


while($row = mysql_fetch_array($query))
	{
  echo "<tr>";
  echo "<td>" . $row['asset_id'] . "</td>";
  echo "<td>" . $row['location'] . "</td>";
  echo "<td>" . $row['active'] . "</td>";
  echo "<td>" . $row['platform'] . "</td>";
  echo "<td>" . $row['make'] . "</td>";
  echo "<td>" . $row['model'] . "</td>"; 
  echo "<td>" . $row['ram'] . "</td>";
  echo "<td>" . $row['warranty'] . "</td>";
  echo "<td>" . $row['active_user'] . "</td>";
  echo "<td>" . $row['notes'] . "</td>";
  echo "</tr>";
	}  
  echo "</table>";
//code for previous
if($back >=0) {
echo "<a href='ah_edit.php?start=$back'><font face='Verdana' size='2'>PREV</font></a>  ";
}

//code for the number of page with links
$i     = 0;
$x    = 1;
for($i=0;$i < $total_rows;$i=$i+$limit){
if($i != $eu){
    echo "<a href='ah_edit.php?start=$i'><font face='Verdana' size='2'>$x</font></a> ";
}else { 
    echo "<font face='Verdana' size='4' color=red>$x</font>";
} // Current page is not displayed as link and given font color red

$x    = $x+1;
}
//code for next
if($whathis < $total_rows) {
echo "<a href='ah_edit.php?start=$next'><font face='Verdana' size='2'>NEXT</font></a>";
}   
	}
 else  echo " <form action=../user/connect.php method=POST>
<h3>Login</h3>

<table border=0>
<tr><td>Username:</td><td> <input type=text name=username></td></tr>
<tr><td>Password:</td><td> <input type=password name=password></td></tr></table>
<input class=buttonSubmit type=submit name=submit value=submit></form>";
?>
</h2>
<?php 

 if ($_SESSION['username'])
  {   
{$con = mysql_connect("localhost","root","c3rb3ru5");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("gpj_assets", $con);
  

//process the input into variables
$submit = $_POST['edit_asset'];
$asset_id = strtolower(strip_tags(trim($_POST['asset_id'])));
$location = strip_tags(trim($_POST['location']));
$active = strip_tags(trim($_POST['status']));
$platform  = strip_tags(trim($_POST['type']));
$make  = strip_tags(trim($_POST['make']));
$model = strip_tags(trim($_POST['model']));
$Ram = strip_tags(trim($_POST['Ram']));
$warranty = strip_tags(trim($_POST['warranty']));
$active_user = strip_tags(trim($_POST['active_user']));
$notes = strip_tags(trim($_POST['notes']));



if ($submit)
{

// Check for an existing asset
$runThis = "SELECT * FROM assets WHERE asset_id = '$asset_id'";
//find the amount that match
$count = mysql_num_rows($runThis);


//Validate input
$error = false;
if ($count!=1)
{
 $error = "Don't Be rediculous, enter an existing id...";
}

else
{
   //No input errors, run query
$query = "UPDATE asset SET location = '$location', SET active = '$active', SET platform = '$platform', SET make = '$make', SET 
model = '$model', SET Ram = '$Ram', SET warranty = '$warranty', SET active_user = '$active_user', SET  notes = '$notes'
WHERE asset_id = $asset_id";
//Check if any errors occured
if($error !== false)
{
    echo "<span style=\"color:red\"> {$error}</pan>\n";
}
else
{
    echo "Edit was completed Successfully";
}
  }
}
  
  else echo " <form action=../user/connect.php method=POST>
<h3>Please Login <img src=\"images/0.410.gif\" /></h3>

<table border=0>
<tr><td>Username:</td><td> <input type=text name=username></td></tr>
<tr><td>Password:</td><td> <input type=password name=password></td></tr></table>
<input class=buttonSubmit type=submit name=submit value=submit></form>";
}
  }
?>
<form action ='ah_edit.php' method="POST">

    <table border=1>
  
<tr><td>Asset ID: *</td><td> <input type=text name="asset_id" maxlength="10" size="10">
</td></tr>

<tr><td>Location: *</td>
<td> <select name="location" id="location"> 
<option value ="Auburn Hills"> Auburn Hills</option>
<option value ="Los Angeles"> Los Angeles</option>
<option value ="San Carlos"> San Carlos</option>
<option value ="Boston"> Boston</option>
<option value ="Nashville"> Nashville</option>
</td></tr>

<tr><td>Status: *</td>
<td> <select name="status" id="status">
<option value ="active"> active</option>
<option value ="spare"> spare</option>
</td></tr>

<tr><td>Type: *</td>
<td> <select name="type" id="type">
<option value ="desktop"> desktop</option>
<option value ="laptop"> laptop</option>
<option value ="server"> server</option>
</td></tr>

<tr><td>Manufacturer:</td>
<td> <select name="make" id="make">
<option value ="Apple"> Apple</option>
<option value ="Dell"> Dell</option>
<option value ="HP"> HP</option>
<option value ="IBM"> IBM</option>
<option value ="Lenovo"> Lenovo</option>
<option value ="Custom"> Custom</option>
</td></tr>

<tr><td>Model: *</td>
<td> <select name="model" id="model">
<option value ="MB Pro">MacBook Pro</option>
<option value ="Mac Pro">Mac Pro</option>
<option value ="Dimension D-620">Dimension D-620</option>
<option value ="Dimension D-630">Dimension D-630</option>
<option value ="Optiplex 745">Optiplex 745</option>
<option value ="Optiplex 780">Optiplex 780</option>
<option value ="Dimension M90">Dimension M90</option>
<option value ="Dimension M6500">Dimension M6500</option>
<option value ="Dimension E6410">Dimension E6410</option>
<option value ="Dimension E6420">Dimension E6420</option>
</td></tr>

<tr><td>Amount of Ram:</td>
<td> <select name="Ram" id="Ram">
<option value ="not sure"> not sure</option>
<option value ="Under 1GB"> under 1GB</option>
<option value ="1 GB"> 1 GB</option>
<option value ="2 GB"> 2 GB</option>
<option value ="3 GB"> 3 GB</option>
<option value ="4 GB"> 4 GB</option>
<option value ="8 GB"> 8 GB</option>
<option value ="16 GB"> 16 GB</option>
<option value ="24 GB"> 24 GB</option>
<option value ="Above 24GB"> Above 24GB</option>
</td></tr>

<tr><td>warranty:</td><td> <input type="text" name="warranty" maxlength="20" size="20"></td></tr>

<tr><td>username:</td><td> <input type="text" name="active_user" maxlength="8" size="8"></td></tr>

<tr><td>notes:</td><td> <input type="text" name="notes" maxlength="45" size="45"></td></tr>
</table>
<br>
            <input class="buttonSubmit" type="submit" name="edit_asset" value="Update Asset">             
</form>
           </div>
        </div>
     
   <div class="clear"></div>
    </div>
    <div id="footer">
        <div class="footer-content">
    
        <span class="sitename">PWW</span>
          		<p class="footer-links">
                    <a href="ah.php">Auburn Hills</a>
                    <a href="Loc/LA/la.php">Los Angeles</a>
                    <a href="Loc/SC/sc.php">San Carlos</a>
                    <a href="Loc/BOS/bos.php">Boston</a>
                    <a href="Loc/BNA/bna.php">Nashville</a>
               	 </p>
                 <div class="clear"></div>
        </div>
        
    
    </div>
</div>
</body>
</html>

 

Link to comment
https://forums.phpfreaks.com/topic/246677-db-error/
Share on other sites
PFMaBiSmAd Advanced Member

PFMaBiSmAd

Posted
Posted

Ummm. LOL, you are not even executing the UPDATE query that I noticed was invalid.

 

There's actually no query in the posted code that contains where asset=, so it would be kind of hard to actually help with what is causing the syntax error in that query.

Link to comment
https://forums.phpfreaks.com/topic/246677-db-error/#findComment-1266833
Share on other sites
Maq Prolific Member

Maq

Posted
Posted

You're doing the same thing right above where PFM pointed out after if ($submit).

 

There is a SELECT but no actual execution to provide mysql_num_rows() with a resource id:

// Check for an existing asset
$runThis = "SELECT * FROM assets WHERE asset_id = '$asset_id'";
//find the amount that match
$count = mysql_num_rows($runThis);

Link to comment
https://forums.phpfreaks.com/topic/246677-db-error/#findComment-1266882
Share on other sites
cjohnson9 Newbie

cjohnson9

Posted
  • Author
Posted

I thought I knew why my query was not executing but now I am stuck...

 

Here is my code right now...

<?php

 if ($_SESSION['username'])
  {

{$con = mysql_connect("localhost","root","c3rb3ru5");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("gpj_asset", $con);


//process the input into variables
$submit = $_POST['edit_asset'];
$asset_id = strtolower(strip_tags(trim($_POST['asset_id'])));
$location = strip_tags(trim($_POST['location']));
$active = strip_tags(trim($_POST['status']));
$platform  = strip_tags(trim($_POST['type']));
$make  = strip_tags(trim($_POST['make']));
$model = strip_tags(trim($_POST['model']));
$Ram = strip_tags(trim($_POST['Ram']));
$warranty = strip_tags(trim($_POST['warranty']));
$active_user = strip_tags(trim($_POST['active_user']));
$notes = strip_tags(trim($_POST['notes']));


if ($submit)
{

// Check for an existing asset
$runThis = "SELECT * FROM assets WHERE asset_id = '$asset_id'";

$qr = mysql_query($runThis);

//find the amount that match
$count = mysql_num_rows($qr);


//Validate input
$error = false;
if ($count=0)
{ $error = "No record found!!!!";
}
if ($asset_id == "")
{
    $error = "Asset Id required";
}
else
{
   //No input errors, run query
$query = "UPDATE assets
SET  location = '$location', status = '$status', type = '$type', make = '$make', model='$model', 
Ram = '$Ram', warranty = '$warranty', active_user = '$active_user', notes = 'notes',
WHERE asset_id = $asset_id";

   $result = mysql_query($query);
   if (!$result)
       {
	   die('Invalid query: ' . mysql_error());
       }
}
}

//Check if any errors occured
if($error !== false)
{
    echo "<span style=\"color:red\"> {$error}</pan>\n";
}
else
{
    echo "Edit was completed Successfully";
}
  }
}

  else echo " <form action=../../user/connect.php method=POST>
<h3>Please Login <img src=\"images/0.410.gif\" /></h3>

<table border=0>
<tr><td>Username:</td><td> <input type=text name=username></td></tr>
<tr><td>Password:</td><td> <input type=password name=password></td></tr></table>
<input class=buttonSubmit type=submit name=submit value=submit></form>";

?>
<form action ='ah_edit.php' method="POST">

    <table border=1>
  
<tr><td>Asset ID: *</td><td> <input type=text name="asset_id" maxlength="10" size="10">
</td></tr>

<tr><td>Location: *</td>
<td> <select name="location" id="location"> 
<option value ="Auburn Hills"> Auburn Hills</option>
<option value ="Los Angeles"> Los Angeles</option>
<option value ="San Carlos"> San Carlos</option>
<option value ="Boston"> Boston</option>
<option value ="Nashville"> Nashville</option>
</td></tr>

<tr><td>Status: *</td>
<td> <select name="status" id="status">
<option value ="active"> active</option>
<option value ="spare"> spare</option>
</td></tr>

<tr><td>Type: *</td>
<td> <select name="type" id="type">
<option value ="desktop"> desktop</option>
<option value ="laptop"> laptop</option>
<option value ="server"> server</option>
</td></tr>

<tr><td>Manufacturer:</td>
<td> <select name="make" id="make">
<option value ="Apple"> Apple</option>
<option value ="Dell"> Dell</option>
<option value ="HP"> HP</option>
<option value ="IBM"> IBM</option>
<option value ="Lenovo"> Lenovo</option>
<option value ="Custom"> Custom</option>
</td></tr>

<tr><td>Model: *</td>
<td> <select name="model" id="model">
<option value ="MB Pro">MacBook Pro</option>
<option value ="Mac Pro">Mac Pro</option>
<option value ="Dimension D-620">Dimension D-620</option>
<option value ="Dimension D-630">Dimension D-630</option>
<option value ="Optiplex 745">Optiplex 745</option>
<option value ="Optiplex 780">Optiplex 780</option>
<option value ="Dimension M90">Dimension M90</option>
<option value ="Dimension M6500">Dimension M6500</option>
<option value ="Dimension E6410">Dimension E6410</option>
<option value ="Dimension E6420">Dimension E6420</option>
</td></tr>

<tr><td>Amount of Ram:</td>
<td> <select name="Ram" id="Ram">
<option value ="not sure"> not sure</option>
<option value ="Under 1GB"> under 1GB</option>
<option value ="1 GB"> 1 GB</option>
<option value ="2 GB"> 2 GB</option>
<option value ="3 GB"> 3 GB</option>
<option value ="4 GB"> 4 GB</option>
<option value ="8 GB"> 8 GB</option>
<option value ="16 GB"> 16 GB</option>
<option value ="24 GB"> 24 GB</option>
<option value =" 24GB+">24GB+</option>
</td></tr>

<tr><td>warranty:</td><td> <input type="text" name="warranty" maxlength="20" size="20"></td></tr>

<tr><td>username:</td><td> <input type="text" name="active_user" maxlength="8" size="8"></td></tr>

<tr><td>notes:</td><td> <input type="text" name="notes" maxlength="45" size="45"></td></tr>
</table>
<br>
            <input class="buttonSubmit" type="submit" name="edit_asset" value="Update Asset">             
</form>

 

This is what is displayed when i turn on error messaging...

Notice: Undefined index: edit_asset in /var/www/PWW/Loc/AH/ah_edit.php on line 207 Notice: Undefined index: asset_id in /var/www/PWW/Loc/AH/ah_edit.php on line 208 Notice: Undefined index: location in /var/www/PWW/Loc/AH/ah_edit.php on line 209 Notice: Undefined index: status in /var/www/PWW/Loc/AH/ah_edit.php on line 210 Notice: Undefined index: type in /var/www/PWW/Loc/AH/ah_edit.php on line 211 Notice: Undefined index: make in /var/www/PWW/Loc/AH/ah_edit.php on line 212 Notice: Undefined index: model in /var/www/PWW/Loc/AH/ah_edit.php on line 213 Notice: Undefined index: Ram in /var/www/PWW/Loc/AH/ah_edit.php on line 214 Notice: Undefined index: warranty in /var/www/PWW/Loc/AH/ah_edit.php on line 215 Notice: Undefined index: active_user in /var/www/PWW/Loc/AH/ah_edit.php on line 216 Notice: Undefined index: notes in /var/www/PWW/Loc/AH/ah_edit.php on line 217 Notice: Undefined variable: error in /var/www/PWW/Loc/AH/ah_edit.php on line 258 Notice: Undefined variable: error in /var/www/PWW/Loc/AH/ah_edit.php on line 260

 

 

Link to comment
https://forums.phpfreaks.com/topic/246677-db-error/#findComment-1267205
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.