dannel77

January 3, 2007

Hi,

I am trying to make it possible to link to a product page on our website from an external link, directly into the frameset of our site. If someone could help me solve this I'd be really greatful.

A direct link (from an external URL) to a product page looks like this: http://www.myhomepage.se/item_show.php?code_no=100090C

The index.php as it looks now:

[code]<frameset cols="*,900,*" framespacing="0" frameborder="0" border="0">
<frame name="left" frameborder="0" scrolling="no" src="bg_left.php" noresize marginwidth="0" marginheight="0">
<frame name="center" src="main_frame.php" frameborder="0" noresize marginwidth="0" marginheight="0">
<frame name="right" frameborder="0" scrolling="no" src="bg_right.php" noresize marginwidth="0" marginheight="0">
</frameset>[/code]

main_frame.php as it is now:

[code]<frameset rows="129,50%" border="0" frameborder="0" marginwidth="0" marginheight="0">
<frame src="top.php" name="top" noresize="noresize" marginwidth="0" marginheight="0" frameborder="0" target="main" scrolling="no">
<frameset rows="92%,40" border="0" frameborder="0">
<frameset cols="182,80%" border="0" frameborder="0">
<frame src="menu_tree.php" name="categories" marginwidth="7" marginheight="6" frameborder="0" target="main" scrolling="auto">
<frame src="main.php" name="main" marginwidth="10" marginheight="7" frameborder="0" target="_self" scrolling="auto" noresize="noresize">
</frameset>
<frameset cols="171,80%" border="0" frameborder="0">
<frame src="middle_left.php" name="cart" noresize="noresize" marginwidth="0" marginheight="0" border="0" frameborder="0" scrolling="no">
<frame src="empty.php" name="middle_right" marginwidth="0" marginheight="0" frameborder="0" target="main" scrolling="no">
</frameset>
</frameset>
</frameset>[/code]

item_show.php:

[code]<?php
// required variables
require("config.php");

$code_no = mysql_escape_string($_REQUEST['code_no']);

?>

<html>
<head>
<title>Product list</title>

<link rel="stylesheet" HREF="master_style.css">

</HEAD>
<BODY TEXT="#000000" BGCOLOR="#FFFFFF" LINK="#000000" VLINK="#000000" ALINK="#F70404">

<center>

<?php

// database connection
mysql_connect("$host","$user","$pass");

// database selection
mysql_select_db("$database");

// query to get the products of type $category
$result = mysql_query("select * from products where(code_no = '$code_no') ORDER BY 'item'");

echo "<FORM NAME=\"itemsform\">
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=16>";

while($row = mysql_fetch_row($result)) {

echo "<TR ALIGN=Left VALIGN=Top><TD><a href=\"item_show2.php?code_no=$row[2]\" TARGET=\"main\"><IMG SRC=\"medium/$row[6]\" BORDER=\"0\"></A></TD>
<TD WIDTH=\"100%\">$row[3]

$row[4]

<TABLE border=0><TD>
$txt_price $txt_currency:  $row[5]  <INPUT TYPE=\"hidden\" NAME=\"id$row[2]quant\" VALUE=\"1\"
</TD><TD Valign=top><a href=\"Javascript:top.center.cart.addItem('$row[3]','$row[5]', document.itemsform.id$row[2]quant.value, '$row[2]', '$row[7]')\"><img src=\"images/buy.gif\" border=\"0\"></a></TD></TR></TABLE>";
}
?>
</TABLE>[/code]

September 10, 2006

Hi,

I need help modifying this script so that it becomes possible to search multiple fields instead
of just one field. As it is now I can search for one specific word (within a table row) but if I
try and make a search for 2 words *with another word in between* it doesn't work. Hope I
make som sense.. :P

$searchstring = trim($searchstring);// remove leading and trailing blanks

// Nu bestämmer vi antal per sida och kollar upp totala antalet
$limit = 30; // Antal per sida
$where = "$chose LIKE '%$searchstring%' OR item LIKE '%$searchstring%' OR code_no LIKE '%$searchstring%'";

$result = @mysql_query("SELECT COUNT(*) FROM products WHERE item LIKE '%$searchstring%' OR code_no LIKE '%$searchstring%'")
or die("Error fetching number in DB ".mysql_error());
$numrows = @mysql_result($result, 0); // Antal i databasen

August 9, 2006

Thanks! I'll go through that in the morning! :)

August 9, 2006

Any way to set the size of the bullets in an <ul><li> list within the css?

August 9, 2006

Problem solved :) Found some code on the net:

html {
overflow-x: hidden;
overflow-y: auto;
}

August 8, 2006

One problem left... with the changes made I get a horizontal scrollbar at the bottom of the page in IE and I can't remove it.. How do I solve this?

August 8, 2006

Thanks guys!! When I added that DOCTYPE line to all the pages (probably item_list.php that was important) the problem was solved! :)

August 5, 2006

Another thing I was wondering about.. I took a screenshot of the page I'm working with, to show how the bullets (diamonds) of the <ul><li> list in Firefox are tilted slightly upwards, in IE they appear right to the left of the text (as they should), what could be causing this? :-\
Also Firefox seems to have a problem displaying a real disc instead of a "diamond", any way to solve this? The master_style.css contains: li{list-style: disc; }

[attachment deleted by admin]

August 4, 2006

Thanx a million man!! Worked fine with a line-height of 150%, now the lists look the same in IE and FF! :)

August 4, 2006

No, I have no or within the tags, but I found out today that if I set the font size to 1, the lists look almost the same in IE anf FF.. But since I use a fixed size of 10px IE can't "delete" the whitespace in between.. and the list is as compact with size 1 as with a font size of 10 px.. :-\

August 3, 2006

Have tried it now, but it makes now difference, the space between the lines are still there.. and the list is much
more compact in Firefox..

August 3, 2006

The list looks fine in Firefox, but in IE there are som gaps between the
lines, the list is an ordinary: <ul><li> unordered list..

I'm trying to make the lists look identical in both browsers but it's much more compact in Firefox, and in IE there appears to be some "padding" or something around every textstring.. Have searched the net for a solution and heard of this bug in IE, does somene here have a solution for this problem?

The CSS file look like this right now:

li{list-style: disc; }
li{margin: 0; padding: 0;}

July 31, 2006

Thanks man! Really appreciate it! :)

July 29, 2006

Hi, I need some help to modify this search script so that "whitespaces" (blanks) are removed when searching,
I have tried with "trim" but can't seem to get it right, any help would be appreciated, the code looks like this:

<?php

// database connection
mysql_connect("$host","$user","$pass");

// database selection
mysql_select_db("$database");

// Nu bestämmer vi antal per sida och kollar upp totala antalet
$limit = 40; // Antal per sida
$where = "$chose LIKE '%$searchstring%' OR item LIKE '%$searchstring%' OR code_no LIKE '%$searchstring%'";

$result = @mysql_query("SELECT COUNT(*) FROM products WHERE item LIKE '%$searchstring%' OR code_no LIKE '%$searchstring%'")
or die("Error fetching number in DB ".mysql_error());
$numrows = @mysql_result($result, 0); // Antal i databasen

// Sedan kollar vi om startvariabeln är satt
$start = isset($_GET['start']) && intval($_GET['start']) >= 0 ? intval($_GET['start']) : 0;

// Då räknar vi ut hur många sidor det blev
$pages = intval($numrows/$limit);
if ($numrows % $limit) {
$pages++;
}

$numlink = '';

// Hämta länk till föregående sida
if ($start > 0) {

$numlink .= '<a href="?start='.($start - $limit).'&searchstring='.$searchstring.'">« </a> ';
} else {
$numlink .= '« ';
}

// Hämta sidonummer
for ($i = 1; $i <= $pages; $i++) {
$newoffset = $limit*($i-1);
if ($start == $newoffset)
$numlink .= ''.$i.' ';
else
$numlink .= '<a href="?start='.$newoffset.'&searchstring='.$searchstring.'">'.$i.'</a> ';
}

// Hämta länk till nästa sida
if ($numrows > ($start + $limit))
$numlink .= '<a href="?start='.($start + $limit).'&searchstring='.$searchstring.'"> »</a> ';
else
$numlink .= ' » ';

$numlink = '
<div style="font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; padding: 5px 0;">
'.$numlink.'
</div>
';

// Skriv ut sidorna
echo $numlink;

?>
<table cellpadding="2" cellspacing="1" border="1" frame="border" RULES="NONE" borderstyle="color: #D5E2EC;">
<TR><TD BGCOLOR="#D5E2EC">
<TD BGCOLOR="#D5E2EC" ALIGN="left"> Art nr. </TD>
<TD BGCOLOR="#D5E2EC" ALIGN="left"> Titel </TD>
<TD BGCOLOR="#D5E2EC" ALIGN="right"> Pris SEK </TD>
<TD BGCOLOR="#D5E2EC"></TD></TR>
<?php
// Nu kan vi hämta datan från databasen och skriva ut den
$result = @mysql_query("SELECT * FROM products WHERE $where ORDER BY item ASC LIMIT $start, $limit")
or die("Error fetching data ".mysql_error());

while ($row = @mysql_fetch_array($result)){
$color = ($coloralternator++ %2 ? "D5E2EC" : "EBF1F5");
echo "<TR BGCOLOR=\"#$color\"><TD ALIGN=\"middle\"><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"><IMG SRC=\"thumbs/$row[6]\" BORDER=\"0\"></a></TD>";
echo "<TD ALIGN=\"left\"><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"> $row[2] </TD>";
echo "<TD ALIGN=\"left\"></a><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"> $row[3] </TD>";
echo "<TD ALIGN=\"right\"></a> $row[5] </TD>";
echo "<TD ALIGN=\"middle\"> <INPUT TYPE=\"hidden\" NAME=\"id$row[2]quant\" VALUE=\"1\">
<a href=\"Javascript:top.center.cart.addItem('$row[3]','$row[5]', document.itemsform.id$row[2]quant.value, '$row[2]', '$row[7]')\"><img src=\"images/buy.gif\" border=\"0\"></a> </TD></TR>";
}
"</center>"
?>
</TABLE>

July 22, 2006

thx for the tip, if you could please take a look at the code of the page and tell me where this 'chose=code_no' should be put in I'd be really grateful. I'm not sure where the "querystring" is.. The whole page (search_list.php) looks like this:

<?php
// required variables
require("config.php");

$chose_allowed = array('item', 'maingroup', 'secondgroup');
$chose = isset($_GET['chose']) && in_array($_GET['chose'], $chose_allowed) ? $_GET['chose'] : $chose_allowed[1];

$searchstring = isset($_GET['searchstring']) ? mysql_escape_string($_GET['searchstring']) : '';

?>

<html>
<head>

<title>Search List</title>

<link rel="stylesheet" HREF="master_style.css">
</HEAD>

<BODY TEXT="#000000" BGCOLOR="#FFFFFF" LINK="#000000" VLINK="#000000" ALINK="#F70404">

<FORM NAME="itemsform">

<CENTER>

<?php echo $txt_search_result ?> "<?php echo $searchstring ?>"

<HR WIDTH=95% size=1 COLOR="#000000">

<center>
<?php

// database connection
mysql_connect("$host","$user","$pass");

// database selection
mysql_select_db("$database");

// Nu bestämmer vi antal per sida och kollar upp totala antalet
$limit = 40; // Antal per sida
$where = "$chose LIKE '%$searchstring%'";

$result = @mysql_query("SELECT COUNT(*) FROM products WHERE $where")
or die("Error fetching number in DB ".mysql_error());
$numrows = @mysql_result($result, 0); // Antal i databasen

// Sedan kollar vi om startvariabeln är satt
$start = isset($_GET['start']) && intval($_GET['start']) >= 0 ? intval($_GET['start']) : 0;

// Då räknar vi ut hur många sidor det blev
$pages = intval($numrows/$limit);
if ($numrows % $limit) {
$pages++;
}

$numlink = '';

// Hämta länk till föregående sida
if ($start > 0) {

$numlink .= '<a href="?start='.($start - $limit).'&searchstring='.$searchstring.'">« </a> ';
} else {
$numlink .= '«  ';
}

// Hämta sidonummer
for ($i = 1; $i <= $pages; $i++) {
$newoffset = $limit*($i-1);
if ($start == $newoffset)
$numlink .= ''.$i.' ';
else
$numlink .= '<a href="?start='.$newoffset.'&searchstring='.$searchstring.'">'.$i.'</a> ';
}

// Hämta länk till nästa sida
if ($numrows > ($start + $limit))
$numlink .= '<a href="?start='.($start + $limit).'&searchstring='.$searchstring.'"> »</a> ';
else
$numlink .= ' » ';

$numlink = '
<div style="font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; padding: 5px 0;">
'.$numlink.'
</div>
';

// Skriv ut sidorna
echo $numlink;

?>
<table cellpadding="2" cellspacing="1" border="1" frame="border" RULES="NONE" borderstyle="color: #D5E2EC;">
<TR><TD BGCOLOR="#D5E2EC">
<TD BGCOLOR="#D5E2EC" ALIGN="left"> Art nr. </TD>
<TD BGCOLOR="#D5E2EC" ALIGN="left"> Titel </TD>
<TD BGCOLOR="#D5E2EC" ALIGN="right"> Pris SEK </TD>
<TD BGCOLOR="#D5E2EC"></TD></TR>
<?php
// Nu kan vi hämta datan från databasen och skriva ut den
$result = @mysql_query("SELECT * FROM products WHERE $where ORDER BY item ASC LIMIT $start, $limit")
or die("Error fetching data ".mysql_error());

while ($row = @mysql_fetch_array($result)){
$color = ($coloralternator++ %2 ? "D5E2EC" : "EBF1F5");
echo "<TR BGCOLOR=\"#$color\"><TD ALIGN=\"middle\"><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"><IMG SRC=\"thumbs/$row[6]\" BORDER=\"0\"></a></TD>";
echo "<TD ALIGN=\"left\"><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"> $row[2] </TD>";
echo "<TD ALIGN=\"left\"></a><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"> $row[3] </TD>";
echo "<TD ALIGN=\"right\"></a> $row[5] </TD>";
echo "<TD ALIGN=\"middle\"> <INPUT TYPE=\"hidden\" NAME=\"id$row[2]quant\" VALUE=\"1\">
<a href=\"Javascript:top.center.cart.addItem('$row[3]','$row[5]', document.itemsform.id$row[2]quant.value, '$row[2]', '$row[7]')\"><img src=\"images/buy.gif\" border=\"0\"></a>  </TD></TR>";
}
"</center>"
?>
</TABLE>

July 21, 2006

Hi!
Could someone please help me to modify this code so it'll be possible to search by articlenumber (code_no) on my homepage. Right now the search function works fine, but only when searching for "item", "maingroup" or "secondgroup".

<?php
// required variables
require("config.php");

$chose_allowed = array('item', 'maingroup', 'secondgroup');
$chose = isset($_GET['chose']) && in_array($_GET['chose'], $chose_allowed) ? $_GET['chose'] : $chose_allowed[0];

$searchstring = isset($_GET['searchstring']) ? mysql_escape_string($_GET['searchstring']) : '';

?>

Have tried to put "code_no" in the $chose_allowed row (instead of 'item') and then it works, but then it's no longer possible to search for item name.. :(

July 20, 2006

Hi,
I need some help to modify this script so people can make a search on article number (code_no) on my companys homepage, currently only item name and 'maingroup', 'secondgroup' can be searched for. I'd really appreciate any kind of help. The code looks like this:

<?php
// required variables
require("config.php");

$chose_allowed = array('item', 'maingroup', 'secondgroup');
$chose = isset($_GET['chose']) && in_array($_GET['chose'], $chose_allowed) ? $_GET['chose'] : $chose_allowed[0];

$searchstring = isset($_GET['searchstring']) ? mysql_escape_string($_GET['searchstring']) : '';

?>

<html>
<head>

<title>Search List</title>

<link rel="stylesheet" HREF="master_style.css">
</HEAD>

<BODY TEXT="#000000" BGCOLOR="#FFFFFF" LINK="#000000" VLINK="#000000" ALINK="#F70404">

<FORM NAME="itemsform">

<CENTER>

<?php echo $txt_search_result ?> "<?php echo $searchstring ?>"

<HR WIDTH=95% size=1 COLOR="#000000">

<center>
<?php

// database connection
mysql_connect("$host","$user","$pass");

// database selection
mysql_select_db("$database");

// Nu bestämmer vi antal per sida och kollar vi upp totala antalet
$limit = 40; // Antal per sida
$where = "$chose LIKE '%$searchstring%'";

$result = @mysql_query("SELECT COUNT(*) FROM products WHERE $where")
or die("Error fetching number in DB ".mysql_error());
$numrows = @mysql_result($result, 0); // Antal i databasen

// Sedan kollar vi om startvariabeln är satt
$start = isset($_GET['start']) && intval($_GET['start']) >= 0 ? intval($_GET['start']) : 0;

// Då räknar vi ut hur många sidor det blev
$pages = intval($numrows/$limit);
if ($numrows % $limit) {
$pages++;
}

$numlink = '';

// Hämta länk till föregående sida
if ($start > 0) {

$numlink .= '<a href="?start='.($start - $limit).'&searchstring='.$searchstring.'">« </a> ';
} else {
$numlink .= '« ';
}

// Hämta sidonummer
for ($i = 1; $i <= $pages; $i++) {
$newoffset = $limit*($i-1);
if ($start == $newoffset)
$numlink .= ''.$i.' ';
else
$numlink .= '<a href="?start='.$newoffset.'&searchstring='.$searchstring.'">'.$i.'</a> ';
}

// Hämta länk till nästa sida
if ($numrows > ($start + $limit))
$numlink .= '<a href="?start='.($start + $limit).'&searchstring='.$searchstring.'"> »</a> ';
else
$numlink .= ' » ';

$numlink = '
<div style="font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; padding: 5px 0;">
'.$numlink.'
</div>
';

// Skriv ut sidorna
echo $numlink;

?>
<table cellpadding="2" cellspacing="1" border="1" frame="border" RULES="NONE" borderstyle="color: #D5E2EC;">
<TR><TD BGCOLOR="#D5E2EC">
<TD BGCOLOR="#D5E2EC" ALIGN="left"> Art nr. </TD>
<TD BGCOLOR="#D5E2EC" ALIGN="left"> Titel </TD>
<TD BGCOLOR="#D5E2EC" ALIGN="right"> Pris SEK </TD>
<TD BGCOLOR="#D5E2EC"></TD></TR>
<?php
// Nu kan vi hämta datan från databasen och skriva ut den
$result = @mysql_query("SELECT * FROM products WHERE $where ORDER BY item ASC LIMIT $start, $limit")
or die("Error fetching data ".mysql_error());

while ($row = @mysql_fetch_array($result)){
$color = ($coloralternator++ %2 ? "D5E2EC" : "EBF1F5");
echo "<TR BGCOLOR=\"#$color\"><TD ALIGN=\"middle\"><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"><IMG SRC=\"thumbs/$row[6]\" BORDER=\"0\"></a></TD>";
echo "<TD ALIGN=\"left\"><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"> $row[2] </TD>";
echo "<TD ALIGN=\"left\"></a><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"> $row[3] </TD>";
echo "<TD ALIGN=\"right\"></a> $row[5] </TD>";
echo "<TD ALIGN=\"middle\"> <INPUT TYPE=\"hidden\" NAME=\"id$row[2]quant\" VALUE=\"1\">
<a href=\"Javascript:top.center.cart.addItem('$row[3]','$row[5]', document.itemsform.id$row[2]quant.value, '$row[2]', '$row[7]')\"><img src=\"images/buy.gif\" border=\"0\"></a> </TD></TR>";
}
"</center>"
?>
</TABLE>

<?php echo $numlink ?>

<HR WIDTH=95% size=1 COLOR="#000000">

<TABLE BORDER=0 CELLSPACING=2 CELLPADDING=4>
<TR>
<TD>| <a href="basket.php"><?php echo $txt_view_cart ?></a> |
<a href="order.php"><?php echo $txt_checkout ?></a> |</TD></TR></TABLE>

</CENTER>
</FORM>
</body>
</html>

April 16, 2006

The search works, but the paging of the results does not...

[!--quoteo(post=363294:date=Apr 10 2006, 08:53 AM:name=thorpe)--][div class=\'quotetop\']QUOTE(thorpe @ Apr 10 2006, 08:53 AM) [snapback]363294[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Not unless you tell us what you meen by [i]isn't working[/i].

Are you getting any errors? What are they?
[/quote]

April 10, 2006

Hi, could someone tell me why this search script with paging isn't working:

<?php

// database connection
mysql_connect("$host","$user","$pass");

// database selection
mysql_select_db("$database");

// Nu bestämmer vi antal per sida och kollar vi upp totala antalet
$limit = 30; // Antal per sida
$result = mysql_query("SELECT COUNT(*) FROM products WHERE $chose LIKE '%$searchstring%'")

or die("Error fetching number in DB ".mysql_error());
$row = @mysql_fetch_array($result);
$numrows = $row['count']; // Antal i databasen

// Sedan kollar vi om startvariabeln är satt
if (!isset($_GET['start']) || $_GET['start'] == "")
$start = 0;
else
$start = $_GET['start'];

// Då räknar vi ut hur många sidor det blev
$pages = intval($numrows/$limit);
if ($numrows%$limit)
$pages++;

// Hämta sidonummer
for ($i = 1; $i <= $pages; $i++) {
$newoffset = $limit*($i-1);
if ($start == $newoffset)
$numlink .= '| '.$i.' ';
else
$numlink .= '| <a href="?start='.$newoffset.'&maingroup='.$maingroup.'&secondgroup='.$secondgroup.'">'.$i.'</a> ';
}

// Nu kan vi hämta datan från databasen och skriva ut den
$result = mysql_query("SELECT * FROM products WHERE $chose LIKE '%$searchstring%' ORDER BY 'maingroup', 'secondgroup', 'item' LIMIT $start, $limit") or die("Error fetching data ".mysql_error());

while ($row = @mysql_fetch_array($result)){
$color = ($coloralternator++ %2 ? "D5E2EC" : "EBF1F5");
echo "<TR BGCOLOR=\"#$color\"><TD ALIGN=\"middle\"><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"><IMG SRC=\"thumbs/$row[6]\" BORDER=\"0\"></a></TD>";
echo "<TD ALIGN=\"left\"><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"> $row[2] </TD>";
echo "<TD ALIGN=\"left\"></a><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"> $row[3] </TD>";
echo "<TD ALIGN=\"right\"></a> $row[5] </TD>";
echo "<TD ALIGN=\"middle\"> <INPUT TYPE=\"hidden\" NAME=\"id$row[2]quant\" VALUE=\"1\">
<a href=\"Javascript:top.center.cart.addItem('$row[3]','$row[5]', document.itemsform.id$row[2]quant.value, '$row[2]', '$row[7]')\"><img src=\"images/buy.gif\" border=\"0\"></a>  </TD></TR>";
}
"</center>"
?>

Any help appreciated!

April 5, 2006

Hi,

I've got this searchscript for a homepage I'm working on, looks like this:

<?php

// database connection
mysql_connect("$host","$user","$pass");

// database selection
mysql_select_db("$database");

// database query to select the categories
$result = mysql_query("select * from products WHERE $chose LIKE '%$searchstring%' ORDER BY 'maingroup','secondgroup','item' LIMIT 0, 20 ") ;

// counter for how many iterations have been done
$i=0;

while($row = mysql_fetch_row($result)) {
$color = ($coloralternator++ %2 ? "D5E2EC" : "EBF1F5");
echo "<TR BGCOLOR=\"#$color\"><TD ALIGN=\"middle\"><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"><IMG SRC=\"thumbs/$row[6]\" BORDER=\"0\"></A></TD>";
echo "<TD ALIGN=\"left\"><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"> $row[2] </TD>";
echo "<TD ALIGN=\"left\"></a><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"> $row[3] </TD>";
echo "<TD ALIGN=\"right\"></a> $row[5] </TD>";
echo "<TD ALIGN=\"middle\"> <INPUT TYPE=\"hidden\" NAME=\"id$row[2]quant\" VALUE=\"1\">
<a href=\"Javascript:top.center.cart.addItem('$row[3]','$row[5]', document.itemsform.id$row[2]quant.value, '$row[2]', '$row[7]')\"><img src=\"images/buy.gif\" border=\"0\"></a> </TD></TR>";
}
?>

Could someone please help me modify this with the paging script I'm using for the product list (below). I need the paging to work with the search_list.php as well:

<?php

// database connection
mysql_connect("$host","$user","$pass");

// database selection
mysql_select_db("$database");

// Nu bestämmer vi antal per sida och kollar vi upp totala antalet
$limit = 30; // Antal per sida
$result = @mysql_query("SELECT count(*) as count FROM products WHERE maingroup = '$maingroup' AND secondgroup = '$secondgroup'")

or die("Error fetching number in DB ".mysql_error());
$row = @mysql_fetch_array($result);
$numrows = $row['count']; // Antal i databasen

// Sedan kollar vi om startvariabeln är satt
if (!isset($_GET['start']) || $_GET['start'] == "")
$start = 0;
else
$start = $_GET['start'];

// Då räknar vi ut hur många sidor det blev
$pages = intval($numrows/$limit);
if ($numrows%$limit)
$pages++;

// Hämta sidonummer
for ($i = 1; $i <= $pages; $i++) {
$newoffset = $limit*($i-1);
if ($start == $newoffset)
$numlink .= '| '.$i.' ';
else
$numlink .= '| <a href="?start='.$newoffset.'&maingroup='.$maingroup.'&secondgroup='.$secondgroup.'">'.$i.'</a> ';
}

// Skriv ut sidorna
echo $numlink;

// Nu kan vi hämta datan från databasen och skriva ut den
$result = @mysql_query("SELECT * FROM products WHERE maingroup = '$maingroup' AND secondgroup = '$secondgroup' ORDER BY item ASC LIMIT $start, $limit")
or die("Error fetching data ".mysql_error());

while ($row = @mysql_fetch_array($result)){
$color = ($coloralternator++ %2 ? "D5E2EC" : "EBF1F5");
echo "<TR BGCOLOR=\"#$color\"><TD ALIGN=\"middle\"><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"><IMG SRC=\"thumbs/$row[6]\" BORDER=\"0\"></a></TD>";
echo "<TD ALIGN=\"left\"><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"> $row[2] </TD>";
echo "<TD ALIGN=\"left\"></a><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"> $row[3] </TD>";
echo "<TD ALIGN=\"right\"></a> $row[5] </TD>";
echo "<TD ALIGN=\"middle\"> <INPUT TYPE=\"hidden\" NAME=\"id$row[2]quant\" VALUE=\"1\">
<a href=\"Javascript:top.center.cart.addItem('$row[3]','$row[5]', document.itemsform.id$row[2]quant.value, '$row[2]', '$row[7]')\"><img src=\"images/buy.gif\" border=\"0\"></a> </TD></TR>";
}
"</center>"
?>

Thank you!

April 1, 2006

Thanks alot man! I couldn't just cut and paste, but eventually it worked out.. Here is how it looks now:

 <center>
<?php

// database connection
mysql_connect("$host","$user","$pass");

// database selection
mysql_select_db("$database");

// Nu bestämmer vi antal per sida och kollar vi upp totala antalet
$limit = 30; // Antal per sida
$result = @mysql_query("SELECT count(*) as count FROM products WHERE maingroup = '$maingroup' AND secondgroup = '$secondgroup'")

or die("Error fetching number in DB ".mysql_error());
$row = @mysql_fetch_array($result);
$numrows = $row['count']; // Antal i databasen

// Sedan kollar vi om startvariabeln är satt
if (!isset($_GET['start']) || $_GET['start'] == "")
$start = 0;
else
$start = $_GET['start'];

// Då räknar vi ut hur många sidor det blev
$pages = intval($numrows/$limit);
if ($numrows%$limit)
$pages++;

// Hämta länk till förstasidan och föregående sida
if ($start > 0) {
$numlink = '<a href="?start=0&maingroup='.$maingroup.'&secondgroup='.$secondgroup.'">««</a> ';
$numlink .= '<a href="?start='.($start - $limit).'&maingroup='.$maingroup.'&secondgroup='.$secondgroup.'">«</a> ';
} else {
$numlink = '«« ';
$numlink .= '« ';
}

// Hämta sidonummer
for ($i = 1; $i <= $pages; $i++) {
$newoffset = $limit*($i-1);
if ($start == $newoffset)
$numlink .= '['.$i.'] ';
else
$numlink .= '<a href="?start='.$newoffset.'&maingroup='.$maingroup.'&secondgroup='.$secondgroup.'">'.$i.'</a> ';
}

// Hämta länk till nästa sida
if ($numrows > ($start + $limit))
$numlink .= '<a href="?start='.($start + $limit).'&maingroup='.$maingroup.'&secondgroup='.$secondgroup.'">»</a> ';
else
$numlink .= '» ';

// Hämta sista sidan
if ($start != $newoffset)
$numlink .= '<a href="?start='.$newoffset.'&maingroup='.$maingroup.'&secondgroup='.$secondgroup.'">»»</a> ';
else
$numlink .= '»» ';

// Skriv ut sidorna
echo $numlink;

// Nu kan vi hämta datan från databasen och skriva ut den
$result = @mysql_query("SELECT * FROM products WHERE maingroup = '$maingroup' AND secondgroup = '$secondgroup' ORDER BY item ASC LIMIT $start, $limit")
or die("Error fetching data ".mysql_error());

while ($row = @mysql_fetch_array($result)){
$color = ($coloralternator++ %2 ? "D5E2EC" : "EBF1F5");
echo "<TR BGCOLOR=\"#$color\"><TD ALIGN=\"middle\"><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"><IMG SRC=\"thumbs/$row[6]\" BORDER=\"0\"></a></TD>";
echo "<TD ALIGN=\"left\"><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"> $row[2] </TD>";
echo "<TD ALIGN=\"left\"></a><a href=\"item_show.php?code_no=$row[2]\" TARGET=\"main\"> $row[3] </TD>";
echo "<TD ALIGN=\"right\"></a> $row[5] </TD>";
echo "<TD ALIGN=\"middle\"> <INPUT TYPE=\"hidden\" NAME=\"id$row[2]quant\" VALUE=\"1\">
<a href=\"Javascript:top.center.cart.addItem('$row[3]','$row[5]', document.itemsform.id$row[2]quant.value, '$row[2]', '$row[7]')\"><img src=\"images/buy.gif\" border=\"0\"></a> </TD></TR>";
}
"</center>"
?>

March 31, 2006

Hi,

I'm having a small problem with this paging script I'm using, it looks alright in Firefox but IE tilts it to the left, could anyone please tell me how to get it centered in Internet Explorer as well.. Pasting only the part of the script where (I guess) I need to make the changes:

// Hämta länk till förstasidan och föregående sida
if ($start > 0) {
$numlink = '<a href="?start=0&maingroup='.$maingroup.'&secondgroup='.$secondgroup.'">««</a> ';
$numlink .= '<a href="?start='.($start - $limit).'&maingroup='.$maingroup.'&secondgroup='.$secondgroup.'">«</a> ';
} else {
$numlink = '«« ';
$numlink .= '« ';
}

// Hämta sidonummer
for ($i = 1; $i <= $pages; $i++) {
$newoffset = $limit*($i-1);
if ($start == $newoffset)
$numlink .= '['.$i.'] ';
else
$numlink .= '<a href="?start='.$newoffset.'&maingroup='.$maingroup.'&secondgroup='.$secondgroup.'">'.$i.'</a> ';
}

// Hämta länk till nästa sida
if ($numrows > ($start + $limit))
$numlink .= '<a href="?start='.($start + $limit).'&maingroup='.$maingroup.'&secondgroup='.$secondgroup.'">»</a> ';
else
$numlink .= '» ';

// Hämta sista sidan
if ($start != $newoffset)
$numlink .= '<a href="?start='.$newoffset.'&maingroup='.$maingroup.'&secondgroup='.$secondgroup.'">»»</a> ';
else
$numlink .= '»» ';

Any help really appreciated! :)

Sign In

dannel77

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by dannel77

Linking into a frameset from external URL

Search multiple fields..

Size of bullets in <li> list..

Size of bullets in <li> list..

One more question about lists..

One more question about lists..

One more question about lists..

One more question about lists..

Help with whitespaces (gaps) between <li> list objects in IE

Help with whitespaces (gaps) between <li> list objects in IE

Help with whitespaces (gaps) between <li> list objects in IE

Help with whitespaces (gaps) between <li> list objects in IE

Need help with trim function to remove "whitespaces"

Need help with trim function to remove "whitespaces"

Please help.. Modifying search function

Please help.. Modifying search function

Searching on page..

Help with search script..please!

Help with search script..please!

Need help modifying search_list.php..

Help with centering paging in IE..

Help with centering paging in IE..

Browse

Activity

Important Information