dannel77's Content - PHP Freaks

Linking into a frameset from external URL

dannel77 posted a topic in PHP Coding Help

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]

January 3, 2007

Search multiple fields..

dannel77 posted a topic in PHP Coding Help

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

Size of bullets in <li> list..

dannel77 replied to dannel77's topic in CSS Help

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

Size of bullets in <li> list..

dannel77 posted a topic in CSS Help

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

One more question about lists..

dannel77 replied to dannel77's topic in CSS Help

Problem solved :) Found some code on the net: html { overflow-x: hidden; overflow-y: auto; }

One more question about lists..

dannel77 replied to dannel77's topic in CSS Help

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?

One more question about lists..

dannel77 replied to dannel77's topic in CSS Help

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

One more question about lists..

dannel77 posted a topic in CSS Help

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]

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

dannel77 replied to dannel77's topic in CSS Help

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

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

dannel77 replied to dannel77's topic in CSS Help

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.. :-\

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

dannel77 replied to dannel77's topic in CSS Help

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..

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

dannel77 posted a topic in CSS Help

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;}

Need help with trim function to remove "whitespaces"

dannel77 replied to dannel77's topic in PHP Coding Help

Thanks man! Really appreciate it! :)

Need help with trim function to remove "whitespaces"

dannel77 posted a topic in PHP Coding Help

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>

Please help.. Modifying search function

dannel77 replied to dannel77's topic in PHP Coding Help

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>

Please help.. Modifying search function

dannel77 posted a topic in PHP Coding Help

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.. :(

Searching on page..

dannel77 posted a topic in PHP Coding Help

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>

July 20, 2006

Help with search script..please!

dannel77 replied to dannel77's topic in PHP Coding Help

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]

Help with search script..please!

dannel77 posted a topic in PHP Coding Help

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!

Need help modifying search_list.php..

dannel77 posted a topic in PHP Coding Help

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 5, 2006

Help with centering paging in IE..

dannel77 replied to dannel77's topic in PHP Coding Help

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

Help with centering paging in IE..

dannel77 posted a topic in PHP Coding Help

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

Everything 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