I am new to PHP
| From: | andy amol | Date: | Thu, 15 Apr 2004 03:33:46 +0000 |
| Subject: | I am new to PHP | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-33890@lists.php.net to get a copy of this message | ||
Hi. This is the qmail-send program at pb1.pair.com.I'm afraid I wasn't able to deliver
your message to the following addresses.This is a permanent error; I've given up. Sorry it
didn't work out.<ezmlm-php-db-digest@pair1.php.net>:ezmlm-manage: fatal: I don't
accept messages at this address (inlocal and/or inhost don't match) (#5.1.1)Hi, I have a
problem with the second file. I am not able to update the data from the php program. Any help on
that would be appreciated. Any modification which would be reduce the code like directly using the
Update command would be appreciated.thanks in advance.Here are the 3
files.////////////////////File1---------------<html><head><title>Book Update
Form</title></head><body><?$db="project";$link =
mysql_connect("localhost","name","passwd");if (!
$link)die("Couldn't connect to MySQL");mysql_select_db($db , $link)or
die("Couldn't open $db: ".mysql_error());$result = mysql_query( "SELECT * FROM
books" )or die("SELECT Error: ".mysql_error());$num_rows =
mysql_num_rows($result);print "There are $num_rows records.<P>";print
"<table width=800 border=1>\n";while ($get_info = mysql_fetch_row($result)){ print
"<tr>\n";foreach ($get_info as $field) print "\t<td><font face=arial
size=2/>$field</font></td>\n";print "</tr>\n";}print
"</table>\n";mysql_close($link);//<form method="POST"
action="book_change_form.php">?><br><form method="POST"
action="book_change_form.php"><pre>Enter ISBN Number to Edit: <input
type="text" name="id" size="10"><input type="submit"
value="Submit"><input
type="reset"></pre></form></body></html>////////////////////File
2---------------------<html><head><title>Book change
form</title></head><body><?$id=$_POST['id'];$db="project";//mysql_connect(localhost,$_POST['username'],$_POST['pass']);$link
= mysql_connect("localhost","name","passwd");if (!
$link)die("Couldn't connect to MySQL");mysql_select_db($db , $link)or
die("Couldn't open $db: ".mysql_error());$query=" SELECT * FROM books WHERE
id='$id'";$result=mysql_query($query);$num=mysql_num_rows($result);//echo
$num;$i=0;while ($i < $num){
$isbn=mysql_result($result,$i,"isbn");$title=mysql_result($result,$i,"title");$author=mysql_result($result,$i,"author");$edition=mysql_result($result,$i,"edition");$course_id=mysql_result($result,$i,"course");$quantity=mysql_result($result,$i,"quantity");$stack_no=mysql_result($result,$i,"stack_no");?><table
width="300" cellpadding="10" cellspacing="0"
border="2"><tr align="center" valign="top"><td
align="center" colspan="1" rowspan="1"
bgcolor="#64b1ff"><h3>Edit and Submit</h3><form
action="book_change_record.php" method="post"><input
type="hidden" name="username" value="<?php print
$_POST['username']?>"><input type="hidden" name="pass"
value="<?php print $_POST['pass']?>"><input type="hidden"
name="ud_id" value="<? echo "$id" ?>">ISBN: <input
type="text" name="ud_isbn" value="<? print
"$isbn"?>"><br>Title: <input type="text"
name="ud_title" value="<? print
"$title"?>"><br>Author: <input type="text"
name="ud_author" value="<? print
"$author"?>"><br>Edition: <input type="text"
name="ud_edition" value="<? print
"$edition"?>"><br>Course Id: <input type="text"
name="ud_course_id" value="<? print
"$course_id"?>"><br>Quantity: <input type="text"
name="ud_quantity" value="<? print
"$quantity"?>"><br>Stack Number:<input type="text"
name="ud_stack_no" value="<? echo
"$stack_no"?>"><br><input type="Submit"
value="Update"></form></td></tr></table><?++$i;}//end
while?></body></html>//////////////File
3------------------------------------<html><head><title>Book Change
Record</title></head><body><?$user=$_POST['username'];$password=$_POST['password'];$ud_id=$_POST['ud_id'];$ud_isbn=$_POST['ud_isbn'];$ud_title=$_POST['ud_title'];$ud_author=$_POST['ud_author'];$ud_edition=$_POST['ud_edition'];$ud_course_id=$_POST['ud_course_id'];$ud_quantity=$_POST['ud_quantity'];$ud_stack_no=$_POST['ud_stack_no'];$db="project";$link
=
mysql_connect("localhost","name","passwd");if (!
$link)die("Couldn't connect to MySQL");mysql_select_db($db , $link)or
die("Couldn't open $db: ".mysql_error());mysql_query(" UPDATE books SET
isbn='$ud_isbn' ,title='$ud_title',
author='$ud_author',edition='$ud_edition',course_id='$ud_course_id',
quantity = '$ud_quantity', stack_no = '$ud_stack_no' WHERE
isbn='$ud_id'");echo "Record Updated";mysql_close($link);?><form
method="POST" action="book_update_form.php"><input type="hidden"
name="username" value="<?php print
$_POST['username']?>"><input type="hidden" name="pass"
value="<?php print $_POST['password']?>"><input
type="submit" value="Change Another"></form><br><form
method="POST" action="book.php"><input type="hidden"
name="username" value="<?php print
$_POST['username']?>"><input type="hidden" name="pass"
value="<?php print $_POST['password']?>"><input
type="submit" value="Book
Interface"></form></body></html>------------------------------------------------------------
---------------------------------
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th