Error Handling If A Record Is Not Found

I would like to kindly seek some coding assistance. I would like to put some kind of error handling in my code if, say, an ID number was entered, but that ID number has no existing record in the database. I have entered some kind of error-checking in my code that will redirect if an ID with no record was entered, but it just doesn't work. The code doesn't affect the page functionality if I entered an ID number with existing records, it only affects it if I entered an ID with no record. Please help. Thanks.

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"); ?>

Also, I would like the EQUIPID text field on this page to be uneditable. I tried DISABLING it, but when I submit the data of this page to be processed, it shows an UNDEFINED INDEX error of my EQUIPID, seems like the EQUIPID variable is not being passed on to the PROCESSING page. I would like the EQUIPID text field to be uneditable so no one can mistakenly edit/update it. Thanks in advance.

Oct 9 '11 #1

Subscribe Post Reply

✓ answered by Antonio Bacasno

I have finally figured out the problem. It was all syntax. I've put an extra space after LOCATION (header), which PHP doesn't accept. It is now working.

2088

Antonio Bacasno

I have finally figured out the problem. It was all syntax. I've put an extra space after LOCATION (header), which PHP doesn't accept. It is now working.

Oct 10 '11 #2

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

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

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

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

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Error Handling If A Record Is Not Found

✓ answered by Antonio Bacasno

Similar topics