I am no stranger to programming, having done that professionally for 30+
years; however,
PHP is a new animal to me. As usual, the text I have leave a little to be
desired. The
reason for this email is to ask for a little assistance in getting over a
coding "speed
bump".
I am rewriting a shopping cart application for a local retailer. It was
originally an
informational site; but, with the request to add 2,500 items to his virtual
store shelf
I went into total rewrite mode. I had originally thought of using Access as
the data base
and mentioned this to my Java instructor last fall. He suggested I use PHP
and MySQL since
I'm on a Unix machine.
I am not developing the maintenance routine. The tables have been created
and the data
base populated. All I want to do is access the tables to effect updates,
deletes, and
additions. There is the snag. I keep getting "object not defined" from PHP.
Once I
correct this, I feel I will be in a better position to continue with the
order processing
part, which is now a client-side Javascript routine.
The code follows. If you could show me what I am going wrong, I would
certainly appreciate
the help. Matter of fact, I'd appreciate any pointers I could get.
The essence of this module is:
On initial entry, display the first 15 or so records from the data base;
Whenever the "forward" button is pressed, display the next 15 records;
Whenever the "backward" button is pressed, go backwards 15 records;
Be able to go to the first record in the file;
Be able to go to the last record in the file;
Modify a record;
Add a record;
Delete a record;
The code below is the portion that I want to be able to page forward and
backward
in the file. The table has seven entries, displayed on at a time rather
than all
seven on the page. This is because the product and customer tables have
thousands
of records and I want to be able to page through them record by record.
<?
/*
Module: show_vendor.php
Function:
1) When called from the root module [], this program displays the first
vendor in the vendors MySQL database.
2) Present the user with options of:
a) Forward paging, with wrap around;
b) Reverse paging, with wrap around;
c) Modify the displayed vendor record;
d) Add a new vendor record;
e) Delete the displayed vendor record;
*/
//class show_vendor
//{
$db_name = "healthspot";
$table_name = "vendors";
$connection = mysql_connect ("localhost","","") or die ("Couldn't
connect to localhost");
$db = mysql_select_db ($db_name, $connection) or die ("Couldn't select
$db_name");
$sql_statement =
"
SELECT Vactive, Vname, Vlogo_loc, Vlogo_height, Vlogo_width,
Valink, Vdiscount
FROM $table_name
";
$result = mysql_query ($sql_statement, $connection) or die ("Couldn't
execute msql_query: [$sql_statement]");
$rowmax = $number_of_rows = mysql_numrows($result);
$rowmax--;
$rowmin = 0;
$TableRecord = -1;
$Sequence = 2;
function Advance_retreat($operation){
GLOBAL $TableRecord;
GLOBAL $Sequence;
global $rowmax, $rowmin, $i;
GLOBAL $db_name;
GLOBAL $table_name;
GLOBAL $connection;
global $Sequence;
$Sequence = 1;
/*
print "<BR><BR>--> In function Advance_retreat before Retrieve call<BR>\n";
print "rowmax : $rowmax rowmin: $rowmin Sequence: $Sequence<br>\n";
print "operation: $operation<BR>\n";
*/
switch ($operation)
{
case 'L':
$TableRecord = $rowmax;
break;
case '1':
$TableRecord = $rowmin;
break;
case '-':
if (($TableRecord - 1) < 0){
$TableRecord = $rowmax;
} else {
--$TableRecord;
}
break;
case '+':
break;
case 'A':
break;
case 'D':
break;
case 'M':
break;
} // end of switch statement
$db = mysql_select_db ($db_name, $connection) or die ("Couldn't select
$db_name");
$sql_statement =
"
SELECT Vactive, Vname, Vlogo_loc, Vlogo_height, Vlogo_width,
Valink, Vdiscount
FROM $table_name
LIMIT $TableRecord, 1
";
$result = mysql_query ($sql_statement, $connection) or die ("Couldn't
execute msql_query: [$sql_statement]");
while ($row = mysql_fetch_array($result)){
$vactive = $row['Vactive'];
if ($vactive == 0){
$vactive = "No";
} else if ($vactive == 1){
$vactive = "Yes";
}
$vname = $row['Vname'];
$vlogo = $row['Vlogo'];
$vlogo_height = $row['Vlogo_height'];
$vlogo_width = $row['Vlogo_width'];
$valink = $row['Valink'];
$vdiscount = $row['Vdiscount'];
/*
print "RETRIEVED --> vname : $vname<BR>\n";
print "RETRIEVED --> vlogo_height: $vlogo_height<BR>\n";
print "RETRIEVED --> vdiscount : $vdiscount<BR>\n";
*/
} // end of while loop
$Sequence = 3;
$temp = $GLOBALS['vname'];
/*
print "<BR>--> In function Advance_retreat after Retrieve call<BR>\n";
print "Sequence : $Sequence<BR>\n";
print "vactive : $vactive<BR>\n";
print "vname : $vname<BR>\n";
print "vlogo : $vlogo<BR>\n";
print "vlogo_height: $vlogo_height<BR>\n";
print "vlogo_width : $vlogo_width<BR>\n";
print "valink : $valink<BR>\n";
print "vdiscount : $vdiscount<BR>\n";
print "globals[vname]: $temp<BR>\n";
*/
$display_block = "<H3 STYLE=\"position: absolute; left: 525; top:
200\">$vactive</H3>";
$display_block .= "<H3 STYLE=\"position: absolute; left: 525; top:
220\">$vname</H3>";
$display_block .= "<H3 STYLE=\"position: absolute; left: 525; top:
240\">$vlogo</H3>";
$display_block .= "<H3 STYLE=\"position: absolute; left: 525; top:
260\">$vlogo_height</H3>";
$display_block .= "<H3 STYLE=\"position: absolute; left: 525; top:
280\">$vlogo_width</H3>";
$display_block .= "<H3 STYLE=\"position: absolute; left: 525; top:
300\">$valink</H3>";
$display_block .= "<H3 STYLE=\"position: absolute; left: 525; top:
320\">$vdiscount</H3>";
echo $display_block;
} // end of Advance_Retreat function
//} end of class definition
?>
<?php Advance_retreat('1'); ?>
As the usual case with anything pertaining to IT, this should have been
done months ago.
Bob Sears
Owner
WebWyshez
[EMAIL PROTECTED]
www.on-net.net/~rsears/webwyshez/webwyshez.html
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
