
PHP Script Help
- or -
Post a project like this2961
£30(approx. $40)
- Posted:
- Proposals: 2
- Remote
- #1471872
- Awarded
Description
Experience Level: Intermediate
General information for the website: ecommerce
Kind of development: Customization of existing website
Description of requirements/features: Working on a site with a mysql category structure as follows:
CREATE TABLE IF NOT EXISTS `shopcats` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`websiteid` int(11) NOT NULL,
`name` varchar(200) NOT NULL,
`slug` varchar(200) NOT NULL,
`parentid` int(11) NOT NULL,
`shownav` varchar(200) NOT NULL,
`order` int(11) NOT NULL,
`img` varchar(255) NOT NULL,
`content` text NOT NULL,
`metatitle` varchar(255) NOT NULL,
`metadesc` varchar(255) NOT NULL,
`metakeywords` varchar(255) NOT NULL,
`googleprod` varchar(400) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=538 ;
I am trying to create an accordion menu to output multilevel categories up to 5 levels, here is the code we have so far:
<?php
$blogcats = mysql_query("SELECT * FROM shopcats WHERE websiteid='".$thisWebsiteID."' AND shownav!='1' AND parentid='0' ORDER by `order`");
echo '';
while($blogcatsrs=mysql_fetch_array($blogcats))
{
// get current category
if($_GET['shopcat']==$blogcatsrs['slug'])
{
echo '<div class="ecomCategoryOn';
}
else
{
echo ''.$blogcatsrs['name'].'';
//get sub categories
if($_GET['shopcat']!="")
{
//get current parent
$getslug = mysql_query("SELECT * FROM shopcats WHERE websiteid='".$thisWebsiteID."' AND slug='".$_GET['shopcat']."' ORDER BY id DESC");
$getslugrs = mysql_fetch_array($getslug);
if($getslugrs['parentid']=="0")
{
$blogcatschildren = mysql_query("SELECT * FROM shopcats WHERE websiteid='".$thisWebsiteID."' AND shownav!='1' AND parentid='".$getslugrs['id']."' ORDER by `order`");
}
else
{
$blogcatschildren = mysql_query("SELECT * FROM shopcats WHERE websiteid='".$thisWebsiteID."' AND shownav!='1' AND parentid='".$getslugrs['parentid']."' ORDER by `order`");
//echo "SELECT * FROM shopcats WHERE websiteid='".$thisWebsiteID."' AND shownav!='1' AND parentid='".$getslugrs['parentid']."' ORDER by `order`";
}
while($blogcatsrschildren=mysql_fetch_array($blogcatschildren))
{
if($blogcatsrs['id'] == $blogcatsrschildren['parentid'])
{
// get current category
if($_GET['shopcat']==$blogcatsrschildren['slug'])
{
echo '<div class="ecomCategorySubOn';
}
else
{
echo ''.$blogcatsrschildren['name'].'';
//get third level
if($getslugrs['id']==$blogcatsrschildren['id'])
{
$checkthird = mysql_query("SELECT * FROM shopcats WHERE websiteid='".$thisWebsiteID."' AND shownav!='1' AND parentid='".$getslugrs['id']."' ORDER by `order`");
while($checkthirdrs=mysql_fetch_array($checkthird))
{
// get current category
if($_GET['shopcat']==$checkthirdrs['slug'])
{
echo '<div class="ecomCategorySubOn2';
}
else
{
echo ''.$checkthirdrs['name'].'';
}
}
//get third level
}
}
}
}
echo 'Show All';
echo '
And here is where this shows on the website: http://www.b-invogue.co.uk/shop/clothing/ (the category menu on the right)
Extra notes:
Kind of development: Customization of existing website
Description of requirements/features: Working on a site with a mysql category structure as follows:
CREATE TABLE IF NOT EXISTS `shopcats` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`websiteid` int(11) NOT NULL,
`name` varchar(200) NOT NULL,
`slug` varchar(200) NOT NULL,
`parentid` int(11) NOT NULL,
`shownav` varchar(200) NOT NULL,
`order` int(11) NOT NULL,
`img` varchar(255) NOT NULL,
`content` text NOT NULL,
`metatitle` varchar(255) NOT NULL,
`metadesc` varchar(255) NOT NULL,
`metakeywords` varchar(255) NOT NULL,
`googleprod` varchar(400) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=538 ;
I am trying to create an accordion menu to output multilevel categories up to 5 levels, here is the code we have so far:
<?php
$blogcats = mysql_query("SELECT * FROM shopcats WHERE websiteid='".$thisWebsiteID."' AND shownav!='1' AND parentid='0' ORDER by `order`");
echo '';
while($blogcatsrs=mysql_fetch_array($blogcats))
{
// get current category
if($_GET['shopcat']==$blogcatsrs['slug'])
{
echo '<div class="ecomCategoryOn';
}
else
{
echo ''.$blogcatsrs['name'].'';
//get sub categories
if($_GET['shopcat']!="")
{
//get current parent
$getslug = mysql_query("SELECT * FROM shopcats WHERE websiteid='".$thisWebsiteID."' AND slug='".$_GET['shopcat']."' ORDER BY id DESC");
$getslugrs = mysql_fetch_array($getslug);
if($getslugrs['parentid']=="0")
{
$blogcatschildren = mysql_query("SELECT * FROM shopcats WHERE websiteid='".$thisWebsiteID."' AND shownav!='1' AND parentid='".$getslugrs['id']."' ORDER by `order`");
}
else
{
$blogcatschildren = mysql_query("SELECT * FROM shopcats WHERE websiteid='".$thisWebsiteID."' AND shownav!='1' AND parentid='".$getslugrs['parentid']."' ORDER by `order`");
//echo "SELECT * FROM shopcats WHERE websiteid='".$thisWebsiteID."' AND shownav!='1' AND parentid='".$getslugrs['parentid']."' ORDER by `order`";
}
while($blogcatsrschildren=mysql_fetch_array($blogcatschildren))
{
if($blogcatsrs['id'] == $blogcatsrschildren['parentid'])
{
// get current category
if($_GET['shopcat']==$blogcatsrschildren['slug'])
{
echo '<div class="ecomCategorySubOn';
}
else
{
echo ''.$blogcatsrschildren['name'].'';
//get third level
if($getslugrs['id']==$blogcatsrschildren['id'])
{
$checkthird = mysql_query("SELECT * FROM shopcats WHERE websiteid='".$thisWebsiteID."' AND shownav!='1' AND parentid='".$getslugrs['id']."' ORDER by `order`");
while($checkthirdrs=mysql_fetch_array($checkthird))
{
// get current category
if($_GET['shopcat']==$checkthirdrs['slug'])
{
echo '<div class="ecomCategorySubOn2';
}
else
{
echo ''.$checkthirdrs['name'].'';
}
}
//get third level
}
}
}
}
echo 'Show All';
echo '
And here is where this shows on the website: http://www.b-invogue.co.uk/shop/clothing/ (the category menu on the right)
Extra notes:

Jack M.
100% (41)Projects Completed
57
Freelancers worked with
50
Projects awarded
33%
Last project
27 Jan 2025
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies