PHP - Category/product Array

Hi there, I'm trying to get the full Product Name in the <title> of each of the product pages - I can't seem to figure out what to put in the product_info.php...  I've tried a few different options but I'm not great with php
Here's what I have currently but it creates errors...

<script language="javascript"><!--
document.write('<title><?php echo TITLE; ?> : <?php echo $product_info['products_name']; ?> </title>');
//--></script>

Hope someone can help - thanks so much!

So I am having some difficulties with a category system. I want my code to search the database an unlimited amount of times to the very last directory and then display it in tree view on my screen. I'm having some trouble because I am having to specify how many depths the code will search. How can I get it to do this on it's own? Currently my code does this...
 

<?php
// Establish SQL Connection.

$mysqli			=	mysqli_connect( $sql['host'], $sql['user'], $sql['pass'], $sql['db'] ) or die( "DARN");
$query			=	$mysqli->query( "SELECT * FROM folders ORDER BY name ASC" );
$num_rows	=	$query->num_rows;


echo "Found <b>" . $num_rows . "</b> row(s) in the database!<br>";


	while ( $row = mysqli_fetch_array( $query ) )
	{
		// DO NOT REMOVE
		$id		=	$row['id'];
		$name	=	$row['name'];
		$parent	=	$row['parent'];
		
		/***************************************************************************************************/
		
		if ( $parent == 0 )
		{
			echo $id . " " . $name . " " . $parent . "<br>";
			
			$query2	=	$mysqli->query( "SELECT * FROM folders WHERE parent = " . $id . " ORDER BY name ASC" );
			
			while ( $row2 = mysqli_fetch_array( $query2 ) )
			{
				echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" . $row2['name'] . "<br>";
			}
		}
	}
?>

I know it's messy, doing the best I can.     DB looks a little like this...   +----+---------+--------+

I have the following result that I am getting from a source.

Code: [Select]
SimpleXMLElement Object
(
    [CategoryID] => 1
    [Name] => Other
    [Order] => 0
    [link] => http://www.link.com?sub=1
)

SimpleXMLElement Object
(
    [CategoryID] => 1233916011
    [Name] => ceramic
    [Order] => 1
    [ChildCategory] => SimpleXMLElement Object
        (
            [CategoryID] => 1234016011
            [Name] => dish
            [Order] => 1
        )

    [link] => http://www.link.com?sub=13476
)

SimpleXMLElement Object
(
    [CategoryID] => 1233917011
    [Name] => laminate
    [Order] => 2
    [link] => http://www.link.com?sub=98247
)

I need to get it into a database with the following structure

Code: [Select]
id  categoryID  cName  cOrder  clink  cparent 

By using
Code: [Select]
foreach($this->resp->Store->CustomCategories->CustomCategory as $cat) {
$sub = $cat->CategoryID;
$ord = $cat->Order;
$linkto = "$stlink?fsub=$fsub";
$nm = htmlspecialchars($cat->Name);
$par=$cat->ChildCategory->Order;
$query = "INSERT INTO Cat (categoryID,cName,cOrder,clink,cparent) VALUES ('$sub','$nm','$ord','$linkto','$par')";
$result = @mysql_query ($query); // Run the query.
}

I can get
Code: [Select]
id   categoryID   cName   cOrder  clink                          cparent
1    1            Other   0       http://www.link.com?sub=1      0
2    1233916011   ceramic 1       http://www.link.com?sub=13476  0
2    1233917011   laminate 2      http://www.link.com?sub=98247  0
But I need to get the ChildCategory in there w/ cparent like
Code: [Select]
id   categoryID   cName   cOrder  clink                          cparent
1    1            Other   0       http://www.link.com?sub=1      0
2    1233916011   ceramic 1       http://www.link.com?sub=13476  0
3    1234016011   dish    1                                      1  <--- like this
4    1233917011   laminate 2      http://www.link.com?sub=98247  0
any help appreciated...

Hope I am in the right area.  I am working on a project which is sort of a business directory.  I have a category table, a sub-category table then the actual account table.  So a user clicks on the category, then selects the sub-category to view information of accounts in that category, and then be able to click to see the full profile.  Here's where I am getting stuck.  A user may be listed in more than one sub.  As an example, let's say a parent is Cars, then subs might be New, Used, Parts, etc.  Now a particular user might be listed under all three subs.  How can I link them?  I have my cat/sub linked via parent/child id's.  However, how can I get the user to be linked to multiple subs?  Would I need to create a separate table to do similar to parent/child of the categories?  If so, then how would I insert the multiple id's into the table?  I assume at this point that I would use drop downs for the subs.  I am having a real hard time wrapping my head around this so any help is greatly appreciated.

An array of "categories" is given:

    $categories = array(
        array("id" => 1, "title" => "Pants", "children" => array(
            array("id" => 2,
                "title" => "Boots",
                "children" => array(
                    array("id" => 3, "title" => "Leather"),
                    array("id" => 4, "title" => "Textile"),
                ),
            ),
            array("id" => 5, "title" => "Sneakers"),
        ),
        ),
        array(
            "id" => 6,
            "title" => "Sort",
            "children" => array(
                array(
                    "id" => 7,
                    "title" => "Balls",
                ),
            ),
        ),
    );

I need to write a function searchCategory ($categories, $id) that returns the name of the category by the category ID.

Help me please.

Hey

i want to make category pages with php.
so i have embeded youtube videos on my website
and i want to make a category so that every embeded link that is named under that category goes on the new web page
i am making.
so lets say i have a category in my table that is called "Call of duty black ops"
would the code be something like this ?

( and yes i want it to be ordered by date aswell )


Code: [Select]
$query = "SELECT *
          FROM `G4V_Videos`.`Category`.`Call of duty black ops`
          ORDER BY `Date added` DESC
          LIMIT 24";
$result = mysql_query($query);

thanks guys!

Hi Guys,

I've been using PHP for a few years now but for some reason I can never seem to get my head around arrays, basically I have a blog site that I want to show all posts that have been posted in public categories but ignore those in the private categories, I had the idea to put all the private category ID's into an array and use that to check against the posts, however my array isn't working out the way I'd hoped.

This is what I have:

$isPrivate = mysql_query("SELECT categoryID FROM mod_cat WHERE isPrivate =1") or die (mysql_error());
while ($isPrivateList = mysql_fetch_array($isPrivate, MYSQL_NUM)) {
$ignoreList = $isPrivateList;
}


However this isn't working at all. I know its wrong I just can't work out how to make it right. This is the mySQL I want to use it with:

mysql_query("SELECT COUNT(*) AS total_entries FROM mod_posts WHERE articlePosted =1 AND articleCat != $ignorelist")

Could anyone please help me?

Thanks in advance.

I'm not sure why but I copied the correct syntax from the wp codex page for it to display the date and title which it displays the titles for the categories however it only displays the date for the headlines category and don't know why. Any answers?

<?php get_header(); ?>

<div id="left">

<div id="col1">

<img id="lp" src="../images/lp.jpg" alt="Latest Promo">

<img class="newslogos" src="../images/headlines.jpg" alt="DW Headlines">

<div class="mininews">

<?php

//The Query
query_posts('category_name=headlines'); 

//The Loop
while (have_posts()) : the_post(); ?>

<h3 class="date"><?php the_date(); ?></h3>
<h4 class="title"><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><?php the_title(); ?></a></h4>

<?php endwhile;

//Reset Query
wp_reset_query();

?>

</div> <!-- End of main news div (headlines) -->

<img class="newslogos" src="../images/rumors.jpg" alt="DW Rumors">

<div class="mininews">

<?php

//The Query
query_posts('category_name=rumors'); 

//The Loop
while (have_posts()) : the_post(); ?>

<h3 class="date"><?php the_date(); ?></h3>
<h4 class="title"><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><?php the_title(); ?></a></h4>

<?php endwhile;

//Reset Query
wp_reset_query();

?>

</div> <!-- End of main news div (rumors) -->

<img class="newslogos" src="../images/columns.jpg" alt="DW Columns">

<div class="mininews">

<?php

//The Query
query_posts('category_name=columns'); 

//The Loop
while (have_posts()) : the_post(); ?>

<h3 class="date"><?php the_date(); ?></h3>
<h4 class="title"><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><?php the_title(); ?></a></h4>

<?php endwhile;

//Reset Query
wp_reset_query();

?>

</div> <!-- End of main news div (columns) -->

</div> <!-- End of col1 -->

</div> <!-- End of left -->

<div id="right">



</div>

<?php get_footer(); ?>

I have an image gallery with different categories, at the moment the list of categories is simple and just looks like this...

General (10)

I would like to be able to upload an image when making new categories and display it like this...



Can anybody help me with this, here are the pages of code...

This is the page that displays the category listing...

Code: [Select]
<?php include("config.inc.php"); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Roy Neale - Gallery</title>
<link href="style/style.css" rel="stylesheet" type="text/css"  />
<script type="text/javascript" src="js/prototype.js"></script>
<script type="text/javascript" src="js/scriptaculous.js?load=effects,builder"></script>
<script type="text/javascript" src="js/lightbox.js"></script>
<link rel="stylesheet" href="css/lightbox.css" type="text/css" media="screen" />
</head>

<body>
    <div id="head">
        <div id="headmain">   
            <div id="headleft">
                <image src="images/bannertop.jpg">
            </div>
            <div id="headright">
                <div class="navimage"><image src="images/gallery3.png" onmouseover="this.src='images/gallery2.png'" onmouseout="this.src='images/gallery3.png'"></image><!--start navimage-->
                </div><!--end navimage-->
                <div class="navimage"><image src="images/about.png" onmouseover="this.src='images/about2.png'" onmouseout="this.src='images/about.png'"></image><!--start navimage-->
                </div><!--end navimage-->
                <div class="navimage"><image src="images/contact.png" onmouseover="this.src='images/contact2.png'" onmouseout="this.src='images/contact.png'"></image><!--start navimage-->
                </div><!--end navimage-->
            </div>
        </div>
    </div>
    <div id="mid">
        <div id="midleft">
          <p>&nbsp;</p>
          <p>&nbsp;</p>
          <p>&nbsp;</p>
          Login
          <p>&nbsp;</p>
          <p align="center"><form action="gallery.php" method="post" name="loginform">
                                <label>Username: </label><input name="username" type="text" class="userpass" size="25" maxlength="25" />
                                <label>Password: </label><input name="password" type="password" class="userpass" size="25" maxlength="25" />
                                <p><label></label><input name="submit" type="submit" class="logbutton" value="LOGIN" /></p>
                        </form></p>
        </div>
        <div id="midright">
            <div id="midrighttop5">
            </div>
            <div id="midrightbottom4">
                  <?php
                // initialization
    $result_array = array();
    $counter = 0;

    $cid = (int)($_GET['cid']);
    $pid = (int)($_GET['pid']);

    // Category Listing

    if( empty($cid) && empty($pid) )
    {
        $number_of_categories_in_row = 3;

        $result = mysql_query( "SELECT c.category_id,c.category_name,COUNT(photo_id)
                        FROM gallery_category as c
                        LEFT JOIN gallery_photos as p ON p.photo_category = c.category_id
                        GROUP BY c.category_id" );
        while( $row = mysql_fetch_array( $result ) )
        {
            $result_array[] = "<a href='gallery.php?cid=".$row[0]."'>".$row[1]."</a> "."(".$row[2].")";
        }
        mysql_free_result( $result );    

        $result_final = "<tr>\n";

        foreach($result_array as $category_link)
        {
            if($counter == $number_of_categories_in_row)
            {    
                $counter = 1;
                $result_final .= "\n</tr>\n<tr>\n";
            }
            else
            $counter++;

            $result_final .= "\t<td>".$category_link."</td>\n";
        }

        if($counter)
        {
            if($number_of_categories_in_row-$counter)
            $result_final .= "\t<td colspan='".($number_of_categories_in_row-$counter)."'>&nbsp;</td>\n";

            $result_final .= "</tr>";
        }
    }


    // Thumbnail Listing

    else if( $cid && empty( $pid ) )
    {
        $number_of_thumbs_in_row = '1';

        $result = mysql_query( "SELECT photo_id,photo_caption,photo_filename FROM gallery_photos WHERE photo_category='".addslashes($cid)."'" );
        $nr = mysql_num_rows( $result );

        if( empty( $nr ) )
        {
            $result_final = "\t<tr><td>No Gallery found</td></tr>\n";
        }
        else
        {
            while( $row = mysql_fetch_array( $result ) )
            {
    $result_array[] = "<a href='".$images_dir."/full_".$row[2]."' rel=\"lightbox\"><img src='".$images_dir."/tb_".$row[2]."' border='3' style='margin: 4px;' bordercolor='silver' alt='".$row[1]."' /></a>";
            }
            mysql_free_result( $result );    

            $result_final = "<tr>\n";
    
            foreach($result_array as $thumbnail_link)
            {
                if($counter == $number_of_thumbs_in_row)
                {    
                    $counter = 1;
                    $result_final .= "\n</tr>\n<tr>\n";
                }
                else
                $counter++;

                $result_final .= $thumbnail_link;
            }
    
            if($counter)
            {
                if($number_of_photos_in_row-$counter)
            $result_final .= "\t<td colspan='".($number_of_photos_in_row-$counter)."'>&nbsp;</td>\n";

                $result_final .= "</tr>";
            }
        }
    }

    
    // Full Size View of Photo
    else if( $pid )
    {
        $result = mysql_query( "SELECT photo_caption,photo_filename FROM gallery_photos WHERE photo_id='".addslashes($pid)."'" );
        list($photo_caption, $photo_filename) = mysql_fetch_array( $result );
        $nr = mysql_num_rows( $result );
        mysql_free_result( $result );    

        if( empty( $nr ) )
        {
            $result_final = "\t<tr><td>No Photo found</td></tr>\n";
        }
        else
        {
            $result = mysql_query( "SELECT category_name FROM gallery_category WHERE category_id='".addslashes($cid)."'" );
            list($category_name) = mysql_fetch_array( $result );
            mysql_free_result( $result );    

            $result_final .= "<tr>\n\t<td>
                        <a href='gallery.php'>Categories</a> &gt; 
                        <a href='gallery.php?cid=$cid'>$category_name</a></td>\n</tr>\n";

            $result_final .= "<tr>\n\t<td align='center'>
                    <br />
                    <img src='".$images_dir."/".$photo_filename."' border='0' alt='".$photo_caption."' />
                    <br />
                    $photo_caption
                    </td>
                    </tr>";
        }
    }

    
// Final Output
echo <<<__HTML_END
                <table width='100%' border='0' align='left' style='margin: 6px;' style='padding: 5px;'>
$result_final        
</table>
            </div>
        </div>
    </div>    
    <div id="foot">
        <div id="footmain">
            <div id="footmainr">
                <image src="images/copyright.png">
            </div>
        </div>
    </div>

</body>
</html>
__HTML_END;
?>
And this is the page where i add new categories...

Code: [Select]
<?php
include("config.inc.php");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Roy Neale - Gallery</title>
<link href="style/style.css" rel="stylesheet" type="text/css"  />
</head>

<body>
    <div id="head">
        <div id="headmain">   
            <div id="headleft">
                <image src="images/bannertop.jpg">
            </div>
            <div id="headright">
                <div class="navimage"><a href="gallery.php"><img border="0" image src="images/gallery3.png" onmouseover="this.src='images/gallery2.png'" onmouseout="this.src='images/gallery3.png'"></image></a><!--start navimage-->
                </div><!--end navimage-->
                <div class="navimage"><image src="images/about.png" onmouseover="this.src='images/about2.png'" onmouseout="this.src='images/about.png'"></image><!--start navimage-->
                </div><!--end navimage-->
                <div class="navimage"><image src="images/contact.png" onmouseover="this.src='images/contact2.png'" onmouseout="this.src='images/contact.png'"></image><!--start navimage-->
                </div><!--end navimage-->
            </div>
        </div>
    </div>
    <div id="mid">
        <div id="midleft">
       
        </div>
        <div id="midright">
            <div id="midrighttop3">
            </div>
            <div id="midrightbottom2">

<?php

if (isset($_POST['submit'])):

  $category_name = $_POST['category_name'];
mysql_query( "INSERT INTO gallery_category(`category_name`) VALUES('".addslashes( $category_name )."' )" );
          
  if (@mysql_query($sql)) {
    echo('<p>New category added</p>');
  } else {
    echo('<p>New category added</p>');
  }
?>

<p><a href="<?=$_SERVER['PHP_SELF']?>">Add another category</a></p>

<?php
  else: // Allow the user to enter a new category
?>

<form action="<?=$_SERVER['PHP_SELF']?>" method="post">
<p><br />
New Category: <input type="text" name="category_name" size="20" maxlength="255"

  /><br />
<input type="submit" name="submit" value="SUBMIT" /></p>
</form>

<?php endif; ?>
            <p><a href="preupload2.php">Back to Upload</a></p>
            </div>
        </div>
    </div>   
    <div id="foot">
        <div id="footmain">
            <div id="footmainr">
                <image src="images/copyright.png">
            </div>
        </div>
    </div>

</body>
</html>
I assume i just need to edit a few mysql queries add another upload form and a few new fields or tables to my database, but i dont know how yet.

Hello,

I am trying create a news article, but I have few category in it. Can you help me to create an "add article form" which has dropdown list of category that I can choose, so when I select "Announcement" it will save the data on my mysql database under announcement table. sample html form below.

<form id="form1" name="form1" method="post" action="">
  <label>
  Category :
  <select name="category" id="category">
    <option>--- choose category ---</option>
    <option>News</option>
    <option>Announcement</option>
    <option>Sports</option>
  </select>
  </label>
  <br />
  Date: <br />
  Title:
  <label>
  <input type="text" name="title" id="title" />
  </label>
  <br />
  Body:
  <label>
  <textarea name="body" id="body" cols="45" rows="5"></textarea>
  </label>
  <br />
  <label>
  <input type="submit" name="Submit" id="Submit" value="Submit" />
  </label>
  <br />
  <br />
</form>

Can you tell me how to create the php code which support the above html.

Also, I would like to have a date and time on my article, but I want it automatically get the time and date from the computer of the client, so the user will not put it manually. can you point me to the correct code?


Thanks and hope you can help me!

Hi friends,

I have two mysql db tables, photos and album, I would like to list photos by album how do i do that ?


CREATE TABLE `album` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `album_name` varchar(95) NOT NULL,
 `album_desc` text NOT NULL,
 PRIMARY KEY (`id`)
);



CREATE TABLE `photos` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `album_id` int(11) NOT NULL,
 `thumb_name` varchar(255) NOT NULL,
 `photo_name` varchar(250) NOT NULL,
 PRIMARY KEY (`id`)
) 

Hey there, so as a personal project, I've been working on creating a forum software. You can check out what I have so far he  https://www.taziamoma.com/Forum/index.php

What I'm currently having trouble with right now is connecting a Category with a forum with the threads inside of it. For example, I have a Category that has 3 forums attached to it. How do I link that in the database and how do I indicate which threads belongs to which forums?

hi i hv built a small posting system, i hv built few categories like this

in mysql i hv these tables

Categories table:
id catname

Post Table:
id postbody posttile date  catid

so i am getting posts with catid for related posts like

http://localhost/site/index.php?action=category&cat=1

so where $_GET['cat'] is 1 it display posts from that category 1, now what i need is when i post a new post i hv choice to assign multiple categories to one post, so a post could be in cat1 and in cat2 as well . please any idea how can i do that? i was thinking to make a new rows in posts table for each category and set it to 0 or 1 , and when  i submit new post it will set 1 to those categories which i select upon writing post. but if i have like 20 categories i need to add more 20 rows in posts table.

is there any other better way i can accomplish this?
Thanks for help