My UPDATE script just doesn't work. I just couldn't find what was wrong, every variable is declared. Please find what's wrong with my code. Thanks.
***THIS IS THE CODE FROM WHERE THE EDITING WILL TAKE PLACE***
***THIS IS THE UPDATE PROCESSING CODE*** -
<?php include("includes/db_connect.php"); ?>
-
<?php require_once("includes/functions.php"); ?>
-
-
<?php
-
-
$equipid = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['equipid'])));
-
$equipname = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['equipname'])));
-
$manufacturer = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['manufacturer'])));
-
$serno = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['serno'])));
-
$modelno = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['modelno'])));
-
$capacity = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['capacity'])));
-
$curloc = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['curlocation'])));
-
$equipcode = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['equipcode'])));
-
$seqno = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['seqno'])));
-
$addDate = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['adddate'])));
-
-
-
$query_update = "UPDATE tblequipmentmasterlist SET ";
-
$query_update .= "equipname = '{$equipname}', ";
-
$query_update .= "manufacturer = '{$manufacturer}', ";
-
$query_update .= "serno = '{$serno}', ";
-
$query_update .= "modelno = '{$modelno}', ";
-
$query_update .= "capacity = '{$capacity}', ";
-
$query_update .= "curlocation = '{$curloc}', ";
-
$query_update .= "equipcode = '{$equipcode}', ";
-
$query_update .= "seqno = '{$seqno}', ";
-
$query_update .= "adddate = '{$addDate}' ";
-
$query_update .= "WHERE 'tblequipmentmasterlist'.'equipid' = {$equipid} LIMIT 1";
-
-
-
if (mysqli_affected_rows() == 1) {
-
header ("LOCATION : updatedata.php");
-
} else {
-
print_r($_POST);
-
var_dump($_POST);
-
echo "<p>Update failed : <br />". $query_update. " <br/>Please contact the site administrator.</p>";
-
echo "<p>" . mysqli_error($db_cxn) . "</p>";
-
}
-
-
?>
-
-
<?php
-
if (isset($db_cxn)) {
-
mysqli_close($db_cxn);
-
}
-
?>
-
After you build the string, you need to execute it using the mysql_query($query_update) function.
15  2355 
If you're trying to qualify a table/field/schema name, I think you have to use ` and not '.
I tried revising the code of my PROCESSING page as per your suggestion, and still the same problem occurred. Please kindly check my code. Also, I've attached an image showing the error. -
<?php include("includes/db_connect.php"); ?>
-
<?php require_once("includes/functions.php"); ?>
-
-
<?php
-
-
$equipid = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['equipid'])));
-
$equipname = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['equipname'])));
-
$manufacturer = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['manufacturer'])));
-
$serno = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['serno'])));
-
$modelno = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['modelno'])));
-
$capacity = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['capacity'])));
-
$curloc = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['curlocation'])));
-
$equipcode = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['equipcode'])));
-
$seqno = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['seqno'])));
-
$addDate = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['adddate'])));
-
-
-
$query_update = "UPDATE `tblequipmentmasterlist` SET ";
-
$query_update .= "`equipname` = '{$equipname}', ";
-
$query_update .= "`manufacturer` = '{$manufacturer}', ";
-
$query_update .= "`serno` = '{$serno}', ";
-
$query_update .= "`modelno` = '{$modelno}', ";
-
$query_update .= "`capacity` = '{$capacity}', ";
-
$query_update .= "`curlocation` = '{$curloc}', ";
-
$query_update .= "`equipcode` = '{$equipcode}', ";
-
$query_update .= "`seqno` = '{$seqno}', ";
-
$query_update .= "`adddate` = '{$addDate}' ";
-
$query_update .= "WHERE `tblequipmentmasterlist`.`equipid` = {$equipid} LIMIT 1";
-
-
-
if (mysqli_affected_rows() == 1) {
-
header ("LOCATION : updatedata.php");
-
} else {
-
print_r($_POST);
-
var_dump($_POST);
-
echo "<p>Update failed : <br />". $query_update. " <br/>Please contact the site administrator.</p>";
-
echo "<p>" . mysqli_error($db_cxn) . "</p>";
-
}
-
-
?>
-
-
<?php
-
if (isset($db_cxn)) {
-
mysqli_close($db_cxn);
-
}
-
?>
-
I can't really see what the error says, it's too small. Have you tried outputting the SQL and running it manually through the DBMS, which I'm assuming is MySQL?
If you mean if I tried updating via the MySQL console, YES, I tried that and it works fine. I was able to update the database manually. I'm sorry about the image, I just can't have a larger image due to the forum restrictions (500 x 600) so I have to resize it before posting it here. Please find again the image on this link: http://i729.photobucket.com/albums/w...pdateError.jpg 
Also, I made some revision with the mysqli_num_rows function. Please find the code here: -
<?php include("includes/db_connect.php"); ?>
-
<?php require_once("includes/functions.php"); ?>
-
-
<?php
-
-
$equipid = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['equipid'])));
-
$equipname = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['equipname'])));
-
$manufacturer = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['manufacturer'])));
-
$serno = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['serno'])));
-
$modelno = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['modelno'])));
-
$capacity = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['capacity'])));
-
$curloc = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['curlocation'])));
-
$equipcode = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['equipcode'])));
-
$seqno = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['seqno'])));
-
$addDate = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['adddate'])));
-
-
-
$query_update = "UPDATE `tblequipmentmasterlist` SET ";
-
$query_update .= "`equipname` = '{$equipname}', ";
-
$query_update .= "`manufacturer` = '{$manufacturer}', ";
-
$query_update .= "`serno` = '{$serno}', ";
-
$query_update .= "`modelno` = '{$modelno}', ";
-
$query_update .= "`capacity` = '{$capacity}', ";
-
$query_update .= "`curlocation` = '{$curloc}', ";
-
$query_update .= "`equipcode` = '{$equipcode}', ";
-
$query_update .= "`seqno` = '{$seqno}', ";
-
$query_update .= "`adddate` = '{$addDate}' ";
-
$query_update .= "WHERE `tblequipmentmasterlist`.`equipid` = {$equipid} LIMIT 1";
-
-
-
if (mysqli_affected_rows($db_cxn) == 1) {
-
header ("LOCATION : updatedata.php"); //Record was successfully updated
-
} else {
-
print_r($_POST);
-
var_dump($_POST);
-
echo "<p>Update failed : <br />". $query_update. " <br/>Please contact the site administrator.</p>";
-
echo "<p>" . mysqli_error($db_cxn) . "</p>";
-
}
-
-
?>
-
-
<?php
-
if (isset($db_cxn)) {
-
mysqli_close($db_cxn);
-
}
-
?>
When you say that you tried updating via the MySQL console, what does that mean? What SQL string did you use? Did you output the SQL string from PHP and then use that? Or did you manually type it in?
I only tried a manual update of my database using the MySQL console to check if the commands are right and working if encoded directly in MySQL. My MySQL version has GUI (I'm using WAMP), so I can also directly check if my webpage did changed my database. Right now, I don't really know what's the problem with my code, the data variables from GETDATA page is being transferred to my PROCESSING page, as the print_r and var_dump shows from the imaged linked, but the data stops there, it doesn't get into my database, whatsoever.
Instead of the manual update, try outputting the string from PHP and then pasting that into MySQL to see if it works.
You mean the whole UPDATE string from my PHP and then pasting it to the MySQL sql query? Ok, I'll try it, thanks for the advice, hope this helps...
Yep, I'm thinking there might be an issue with the string creation. Outputting it and using what the PHP engine uses will either confirm or deny it. And then we can proceed from there.
Please find the linked images. As per your suggestion, I copied the PHP string and then pasted it on the MySQL sql query, and it successfully updated my dbase.
***The data to be be sent as an update*** 
***Update failed, copied the query string*** 
***Database doesn't show any update activity at all*** 
***Pasted the copied string*** 
***Query was a success!*** 
***Update was reflected on the main dbase*** 
I can't believe I missed this but you didn't actually run the update query in your code. You create the string but then you don't execute it.
Could you please elaborate?
After you build the string, you need to execute it using the mysql_query($query_update) function.
Wow, thanks dude, that surely solves the UPDATE problem. But, I can't make my redirect to work. When a successful update was performed, it should redirect to UPDATEDATA.PHP. What happens is it only opens a blank PROCESSFORM_UPDATE.PHP page. -
<?php include("includes/db_connect.php"); ?>
-
<?php require_once("includes/functions.php"); ?>
-
-
<?php
-
-
$equipid = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['equipid'])));
-
$equipname = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['equipname'])));
-
$manufacturer = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['manufacturer'])));
-
$serno = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['serno'])));
-
$modelno = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['modelno'])));
-
$capacity = mysqli_real_escape_string($db_cxn, trim(htmlspecialchars($_POST['capacity'])));
-
$curloc = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['curlocation'])));
-
$equipcode = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['equipcode'])));
-
$seqno = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['seqno'])));
-
$addDate = mysqli_real_escape_string($db_cxn, trim(strip_tags($_POST['adddate'])));
-
-
-
$query_update = "UPDATE `tblequipmentmasterlist` SET ";
-
$query_update .= "`equipname` = '{$equipname}', ";
-
$query_update .= "`manufacturer` = '{$manufacturer}', ";
-
$query_update .= "`serno` = '{$serno}', ";
-
$query_update .= "`modelno` = '{$modelno}', ";
-
$query_update .= "`capacity` = '{$capacity}', ";
-
$query_update .= "`curlocation` = '{$curloc}', ";
-
$query_update .= "`equipcode` = '{$equipcode}', ";
-
$query_update .= "`seqno` = '{$seqno}', ";
-
$query_update .= "`adddate` = '{$addDate}' ";
-
$query_update .= "WHERE `tblequipmentmasterlist`.`equipid` = {$equipid} LIMIT 1";
-
-
$result = mysqli_query($db_cxn, $query_update);
-
-
if (mysqli_affected_rows($db_cxn) == 1) {
-
header ("LOCATION : updatedata.php"); //Record was successfully updated
-
} else {
-
print_r($_POST);
-
var_dump($_POST);
-
echo "<p>Update failed : <br />". $query_update. " <br/>Please contact the site administrator.</p>";
-
echo "<p>" . mysqli_error($db_cxn) . "</p>";
-
}
-
-
?>
-
-
<?php
-
if (isset($db_cxn)) {
-
mysqli_close($db_cxn);
-
}
-
?>
-
Another thing, how do I make a text field uneditable? I tried DISABLING my EQUIPID text field, but then I always encounter an UNDEFINED INDEX error. I would like my EQUIPID to be uneditable to prevent errors.
I don't know about making it disabled but you can just make it a hidden field.
As for the redirect, can you make a new thread for that? We like to have one question per thread here.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Evan Dekker |
last post by:
hi all
im not why this code doesn't work:
/////////
import java.applet.*;
import java.awt.*;
public class TestApplet extends Applet {
public void init() {
|
by: Julian |
last post by:
Hi
I am trying to update a date field in my table but some how this simple code
does not work, I know the select work because if I write the fields, it will
show the data from the table but why...
|
by: Julian |
last post by:
Hi
I have code in my login.asp which sets the online field in user database to
true or 1. I am trying to use the same code in global.asa to change back the
online field to 0 but it doesn't work....
|
by: Wolfgang |
last post by:
I Created an new Page
I added 3 Textboxes
i created a link button
I added a SQL - Dataaadapter with the wizard
I created a Dataset with the wizard from the dataadapter
in the page_load -...
|
by: alexjaquet |
last post by:
Hi,
I've in my web pages an affectation to this property but it's doesn't
work (same for all the others properties I'm trying to update):
here is the complete function I call on mouseover :
...
|
by: eric.dehaan |
last post by:
Hello.
I have a Gridview on my webpage. To this gridview, I bind a
datatable. The results are correctly displayed. But after I edit
some values and trigger the event, the
values & are empty....
|
by: Pietro Ova |
last post by:
Hello,
I wrote a little program to understand the ADO.NET's mechanism. It's a common program with a datagrid, textboxes and a toolstripbar with usually buttons. The problem is that meanwhile i add...
|
by: TonyJ |
last post by:
Hello!
I'm using VS2005.
I'm looking at ADO.NET and have found some test tutorial solution on
microsoft MSDN.
The one that I'm looking at now is called Walkthrough: Saving Data to a
Database...
|
by: dougmeece |
last post by:
Morning Everyone...
I have a table that needs to be append to and also updated. All the fields in the table are populated with data from the text boxes and combo boxes on a form. The Date...
|
by: Mel |
last post by:
I have an update panel that has the UpdateMode set to "Conditional".
When I call UpdatePanel1.Update() in the VB code it does not work in
FireFox. It works just fine in Internet Explorer 6.0. Any...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
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...
|
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...
|
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...
|
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...
|
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,...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
| |
