No Record Found Error Handling

Please help me. I would like to put some code that will produce an error message if the ID number entered is still non-existent, then returns to the previous page. I've tried using mysqli_num_rows, but it doesn't work, maybe I used the wrong function. Please find the attached code.

***RETRIEVE DATA OF CORRESPONDING ID NUMBER***

Expand|Select|Wrap|Line Numbers

 
<?php require_once("includes/db_connect.php"); ?>

<?php require_once("includes/functions.php"); ?>

<?php
 
    $equipid = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['equipid']))); //equipid number coming from the updatedata.php
 
    $query = "SELECT * FROM tblequipmentmasterlist ";

    $query .= "WHERE equipid =" . $equipid;

    $query .= " LIMIT 1";
 
    $query_result = mysqli_query($db_cxn, $query);
 
    if (mysqli_num_rows($query_result) == 0) {

        header ("LOCATION : updatedata.php"); //If record doesn't exist

    } else { //If a record do exist

            while ($row = mysqli_fetch_array ($query_result)) {

                    $equipname = $row['equipname'];

                    $manufacturer = $row['manufacturer'];

                    $serno = $row['serno'];

                    $modelno = $row['modelno'];

                    $capacity = $row['capacity'];

                    $curloc = $row['curlocation'];

                    $equipcode = $row['equipcode'];

                    $seqno = $row['seqno'];

                    $adddate = $row['adddate'];

                 }

            }
 
?>

<!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>

<title>EST-Equipment Intranet-Calibration-Update Equipment Record</title>

<meta http-equiv="Content-Language" content="English" />

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

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

<style type="text/css">

<!--

.style1 {

    color: #000000;

    font-size: medium;

}
 
#wrap #content .right .newequipment {

    font-family: Verdana, Arial, Helvetica, sans-serif;

    font-size: 14px;

    font-style: normal;

    font-weight: lighter;

    text-transform: capitalize;

    text-align: left;

    text-indent: 5px;

    margin: 10px;

    padding: 10px;

    width: 350px;

}

-->

</style>
 
<?php include("includes/calheader.php"); ?>
 
<h2>Update Equipment Information Form</h2>

<form action = "processform_update.php" method = "POST">

<div class="DataInput">

  <table width="707" border="0" cellpadding="0" cellspacing="0" id="Equipname6">

    <tr>

      <td width="200" class="style1">Equipment ID No.</td>

      <td width="507"><input name="equipid" type="text" id="equipid" tabindex="" value="<?php echo $equipid; ?>" size="7" />

     </tr>

  </table>

</div>

<div class="DataInput">

 <table width="707" border="0" cellpadding="0" cellspacing="0" id="Equipname">

    <tr>

      <td width="200" class="style1">Equipment Name</td>

      <td width="507">

        <input name="equipname" type="text" id="equipname" tabindex="1" value="<?php echo $equipname; ?>" size="40" />

      </td>

    </tr>

  </table>

</div>

<div class="DataInput">

 <table width="708" border="0" cellpadding="0" cellspacing="0" id="Equipname2">

    <tr>

      <td width="200" class="style1">Manufacturer</td>

      <td width="508">

        <input name="manufacturer" type="text" id="manufacturer" tabindex="2" value="<?php echo $manufacturer; ?>" size="40" />

      </td>

    </tr>

  </table>

</div>

<div class="DataInput">

 <table width="561" border="0" cellpadding="0" cellspacing="0" id="Equipname3">

    <tr>

      <td width="200" class="style1">Serial No. (if any)</td>

      <td width="361">

      <input name="serno" type="text" id="serno" tabindex="3" value="<?php echo $serno; ?>" size="30" />

      </td>

    </tr>

  </table>

</div>

<div class="DataInput">

 <table width="561" border="0" cellpadding="0" cellspacing="0" id="Equipname4">

    <tr>

      <td width="200" class="style1">Model No. (if any)</td>

      <td width="361">

      <input name="modelno" type="text" id="modelno" tabindex="4" value="<?php echo $modelno; ?>" size="30" />

      </td>

    </tr>

  </table>

</div>

<div class="DataInput">

  <label class="style6"></label>

  <table width="707" border="0" cellpadding="0" cellspacing="0" id="Equipname5">

    <tr>

      <td width="200" class="style1">Capacity / Range</td>

      <td width="507">

      <input name="capacity" type="text" id="capacity" tabindex="5" value="<?php echo $capacity; ?>" size="40" />

      </td>

    </tr>

  </table>

</div>

<div class="DataInput">

    <label class="style6"></label>

  <table width="707" border="0" cellpadding="0" cellspacing="0" id="Equipname6">

    <tr>

      <td width="200" class="style1">Current Location</td>

      <td width="507">

      <input name="curlocation" type="text" id="curlocation" value="<?php echo $curloc; ?>" tabindex="6" size="20" />

      <a href='locationcode.php' target='_blank' class='style7'>...Click here for definition...</a> 

      </td>

    </tr>

  </table>

</div>

<div class="DataInput">

    <label class="style6"></label>

  <table width="707" border="0" cellpadding="0" cellspacing="0" id="Equipname5">

    <tr>

      <td width="200" class="style1">Equipment Code</td>

      <td width="507">

      <input name="equipcode" type="text" id="equipcode" value="<?php echo $equipcode; ?>" tabindex="7" size="20" />

      <a href='equipmentcode.php' target='_blank' class='style7'>...Click here for definition...</a> 

      </td>

    </tr>

  </table>

</div>

<div class="DataInput">

 <table width="561" border="0" cellpadding="0" cellspacing="0" id="Equipname8">

    <tr>

      <td width="200" class="style1">Sequence Number</td>

      <td width="361">

      <input name="seqno" type="text" id="seqno" tabindex="8" size="7" maxlength="7" value="<?php echo $seqno; ?>" />

      </td>

    </tr>

  </table>

</div>

<div class="DataInput">

 <label class="style6"></label>

  <table width="707" border="0" cellpadding="0" cellspacing="0" id="Equipname5">

    <tr>

      <td width="200" class="style1">Date Added</td>

      <td width="507">

      <input name="adddate" type="text" id="adddate" tabindex="9" value="<?php echo $adddate; ?>" size="20" /> 

      <strong>YYYY-MM-DD</strong> </td>

    </tr>

  </table>

</div>

<p>&nbsp;</p>

<div class="DataInput">

<input type="submit" name="submit" id="submit" value="Submit" />

</div>

</form>

<p><br />

<br />

  <br />

  <br />

  <br />

  </div>
 
<?php require("includes/footer.php"); ?>

Another thing, I would like the EQUIPID text field on this page to be un-editable. I tried disabling the EQUIPID text field, but it gives an Undefined Index error of EQUIPID, the EQUIPID variable was missing. Please advise. Thanks.

Oct 4 '11 #1

Subscribe Post Reply

1628

by: monika | last post by:

hi ... I want to do error handling in my application. I have made a complete application. but when I encounter errors (like mentioned below) I want to do error handling. how can I do it? I...

ASP / Active Server Pages

error handling-duplicate key

by: monika | last post by:

hi... when I try to insert a duplicate record I get the primary key error. which is good. but I want to generate a user friendly error ... telling the user that u have got this error because u r...

ASP / Active Server Pages

c# Error Handling

by: aaj | last post by:

Hi all I have an automated application, that runs in the middle of the night. If certain 'non system' errors occur (things like malformed files, missing files etc..), I send an automatic Email...

.NET Framework

error handling - a couple of questions:

by: WindAndWaves | last post by:

I am writing error handling procedures at the moment. Here are some questions: 1. Can you write a procedure that picks up any error and deals with it no matter where it happens in the database?...

Microsoft Access / VBA

Error Handling

by: David | last post by:

Hello I am trying to collect errors and record them in a table instead of a popup message stopping my code. It seems to work ok, but when I try to add ERR.Description to my code it fails on Syntax...

Microsoft Access / VBA

C# Error handling

by: aaj | last post by:

Hi all I have an automated application, that runs in the middle of the night. If certain 'non system' errors occur (things like malformed files, missing files etc..), I send an automatic Email...

C# / C Sharp

Another error handling question - best practice?

by: James Radke | last post by:

Hello, I am looking for guidance on best practices to incorporate effective and complete error handling in an application written in VB.NET. If I have the following function in a class module...

Visual Basic .NET

Is David Fenton right about error handling?

by: Anthony England | last post by:

I am considering general error handling routines and have written a sample function to look up an ID in a table. The function returns True if it can find the ID and create a recordset based on...

Microsoft Access / VBA

Error Handling in a DAL

by: Garth Wells | last post by:

I'm trying to create a DAL and am wondering what's the proper way to handle errors in this Insert method. public string Insert() { Database db = DatabaseFactory.CreateDatabase(); string...

ASP.NET

Automatic Error Handling in Access

by: Lysander | last post by:

Thought I would give something back with a few articles. This article is a bit of code to add error handling. When I have time, I want to write articles on multilingual databases, and Access...

Microsoft Access / VBA

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

No Record Found Error Handling

Similar topics