PHP - Search Category.

Hello everyone,

I am currently working on the script taken from www.phpwebcommerce.com I am only a beginner and have been using it in a little project for an online game just to help my mates be able to trade items and such.

I have managed to get almost everything sorted apart from one thing. The function which gets the categories for a drop down select box:

Code: [Select]
/*
    Generate combo box options containing the categories we have.
    if $catId is set then that category is selected
*/
function buildCategoryOptions($catId = 0)
{
    $sql = "SELECT cat_id, cat_parent_id, cat_name
            FROM tbl_category
            ORDER BY cat_id";
    $result = dbQuery($sql) or die('Cannot get Product. ' . mysql_error());
   
    $categories = array();
    while($row = dbFetchArray($result)) {
        list($id, $parentId, $name) = $row;
       
        if ($parentId == 0) {
            // we create a new array for each top level categories
            $categories[$id] = array('name' => $name, 'children' => array());
        } else {
            // the child categories are put int the parent category's array
            $categories[$parentId]['children'][] = array('id' => $id, 'name' => $name);   
        }
    }   
   
    // build combo box options
    $list = '';
    foreach ($categories as $key => $value) {
        $name     = $value['name'];
        $children = $value['children'];
       
        $list .= "<optgroup label=\"$name\">";
       
        foreach ($children as $child) {
            $list .= "<option value=\"{$child['id']}\"";
            if ($child['id'] == $catId) {
                $list.= " selected";
            }
           
            $list .= ">{$child['name']}</option>\r\n";
        }
       
        $list .= "</optgroup>";
    }
   
    return $list;
}

Basically the problem is that it only creates a category list of two levels e.g.

Parent

    Child

and I wish to be able to have more sub categories e.g.

Parent

    Child

        Child

            Child

Is there anyway of adapting this code so it can do something like that? Many thanks for any help.

I need some help with the category part on a old project .

The problem what I have at this moment that, when I click on the category all categories are showing up on the category.php page itself.

What whI wanne have when I click Uncategorised that in the category.php page only post are showing that have been made in Uncategorised category

function get_posts() {
    $sql = "SELECT 
              `blog`.`post_id` AS `id`,
              `blog`.`post_title` AS `title`,
              LEFT(`blog`.`post_body`, 512) AS `preview`,
              `blog`.`post_user` AS `user`,
              `blog_categories`.`id` AS `category_id`,
              `blog_categories`.`name` AS `category_name`,
              DATE_FORMAT(`blog`.`post_date`,  '%d-%m-%Y %H:%i') AS `date`,
              `blog_comments`.`total_comments`,           
              DATE_FORMAT(`blog_comments`.`last_comment`, '%d-%m-%Y %H:%i') AS `last_comment`
            FROM `blog`
               INNER JOIN `blog_categories` ON `blog_categories`.`id` = `blog`.`cat_id`
            LEFT JOIN ( 
                SELECT 
                   `post_id`,
                   COUNT(`comment_id`) AS `total_comments`,
                   MAX(`comment_date`) AS `last_comment`
                FROM `blog_comments`
                GROUP BY `post_id`
              ) AS `blog_comments`
              ON `blog`.`post_id` = `blog_comments`.`post_id`
              ORDER BY `blog`.`post_date` DESC";

    $posts = mysql_query($sql);

    $rows = array();
    while (($row = mysql_fetch_assoc($posts)) !== false) {
        $rows[]= array(
            'id'             => $row['id'],
            'title'          => $row['title'],
            'preview'        => $row['preview'],
            'user'           => $row['user'],   
            'date'           => $row['date'],           
            'category_id'    => $row['category_id'],    
            'category_name'  => $row['category_name'],
            'total_comments' => ($row['total_comments'] === null) ? 0 : $row['total_comments'],
            'last_comments'  => ($row['last_comment'] === null) ? 'never' : $row['last_comment']                                                            
        );
    }
    
    return $rows;
}

function get_post($pid) {
    $pid = (int)$pid;

    $sql =   "SELECT
                `post_title` AS `title`,
                `post_body` AS `body`,
                `post_user` AS `user`,
                `blog_categories`.`id` AS `category_id`,
                `blog_categories`.`name` AS `category_name`,
                DATE_FORMAT(`post_date`, '%d-%m-%Y %H:%i') AS `date`
            FROM `blog` 
                INNER JOIN `blog_categories` ON `blog_categories`.`id` = `blog`.`cat_id`
            WHERE `post_id` = '$pid'";

    $post = mysql_query($sql);
    $post = mysql_fetch_assoc($post);

    $post['blog_comments'] = get_comments($pid);

    return $post;      
}

 

The old way was like this 

   if ( isset($cat_id)) {
      $cat_id = (int) $cat_id;
      $query .= " WHERE `blog_categories`.`id` = $cat_id";
   }  

Database 

blog_categories

id | name |

----------- 

4 Uncategorised

1 Youtube

blog 

post_id | cat_id | post_title | post_body | post_user | post_date 

-----------------------------------------------------------------------------------

4 | 1 | Youtube | Youtube link | Admin | 2020-09-13 16:10:53

Web server
Apache/2.2.21 (Win64) PHP/5.3.10
MySQL-client versie: mysqlnd 5.0.8-dev - 20102224 - $Revision: 321634 $
PHP uitbreiding: mysqli Documentatie

phpMyAdmin
Versie informatie: 3.4.10.1, meest recente versie: 5.0.2

I hope someone can help me with this problem 

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 Guys (& Ladies of course) 

I'm having a problem trying to add post category to the H1 title, I have managed to butcher my theme so that the single post now removes the H1 from the title in the header & instead adds it to the post title.

But what I'd like to do now is keep the H1 blog title on all pages including home page, but I'd like to ammend the title with the addition of the post category, as follows;

currently shows "Top Rated Gadgets" on all pages.

would like it to show "Top Rated (category name)" when viewing a single post.

So if the category of the post was Asus Laptops it would show "Top Rated Asus Laptops" instead of the usual "Top Rated Gadgets"

The closest I have got to it so far is with
Code: [Select]
<?php the_category(', '); ?> but this returns a hyperlink ! Is there any method I can use that will simply return the category name as plain text..?

Any help would be much appreciated 

Thanks

I have created a form which allows people to add data to a database.  However, I want to replicate the form across several pages and give each page a category.

For example, if I have a website based on sport.  I have a page which enters information into the baseball category, a page which enters information into the ice hockey category, a page which enters information into the soccer category etc.

Can someone advise how I would do this?

Hi
How can i see which category is being used in rss feed, this is my code to parse one rss feed.

$feed_url = "http://www.foo.com/feed/";
$xml = simplexml_load_file($feed_url);
foreach ($xml->channel->item as $item) { 
$ns_content = $item->children('http://purl.org/rss/1.0/modules/content/');
$title = $item->title; // This is title
$desc = $ns_content->encoded; // This is description
$category =""; // Here i am stuck, how can i get category associated with this feed
}


How can i see its category, i see in source code it looks like this and even categories have sub categories which looks same, i wants categories names to display wihich is associated with feed:

<category><![CDATA[Health]]></category> 
<category><![CDATA[Men]]></category> 


thanks for any help.

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.

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!

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(); ?>

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 have been working on a directory/cms script (first large script to build from scratch).

I am stuck on a small part of it where is shows users a list of the listings they have put in the directory.

Below is the code that generates the table that shows the list of listings which is pulled from the 'listings' table in my database.

Code: [Select]
<?php 
### List of listings user has posted ###
if(isset($_SESSION['userlogged'])) {
$user_id = $_SESSION['userlogged'];

$sqlCommand = "SELECT listing_id, cat_id, listing_title, listing_date, showing FROM listings WHERE showing='0' AND user_id='$user_id' ORDER BY listing_id ASC"; 
$query = mysql_query($sqlCommand,$con) or die (mysql_error()); 

$ListingDisplay = '';
while ($row = mysql_fetch_array($query)) { 
    $listing_id = $row["listing_id"];
$cat_id = $row['cat_id'];

if ($cat_id == '1') { 
$cat_name = "Carpenters";
}
if ($cat_id == '2') {
$cat_name = "Stone Masons";
}
if ($cat_id == '3') {
$cat_name = "Plumbers";
}
if ($cat_id == '4') {
$cat_name = "Landscapers";
}

$listing_title = $row["listing_title"];
$listing_date = $row["listing_date"];

$ListingDisplay .= '
<tr class="listingaccount">
<td><a href="edit_listing.php?lid=' . $listing_id . '">' . $listing_id . '</a></td>
<td>' . $cat_name . '</td>
<td>' . $listing_title . '</td>
<td>' . $listing_date . '</td>
<td><a class="hoverBtn" href="edit_listing.php?lid=' . $listing_id . '"><img src="images/btnedit.png" border="0"></a></td>
<td><a class="hoverBtn" href="remove_listing.php?lid=' . $listing_id . '"><img src="images/btndelete.png" border="0"></a></td>
</tr>';

} 
mysql_free_result($query); 

?>

<table width="680" border="0" align="right" cellpadding="0" cellspacing="0">
  <tr>
    <td colspan="2"><h2>My Listings</h2></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><a href="account_add_listing.php">Add New Listing</a></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td colspan="2" valign="top">
   
   
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>Listing Code</td>
    <td>Category</td>
    <td>Title</td>
    <td>Date Entered</td>
    <td>&nbsp;</td>
  </tr>
 
    <?php echo $ListingDisplay; ?>
 
</table>
   
   
   
   </td>
  </tr>
</table>
<?php } ?>

That all works just fine, but I would like to be able to generate the categories automatically. I am thinking some sort of array, but im not quite sure how to go about it and was hoping maybe someone could give me a starting point I could work from.

My categories table is like this:

--------------------------
| cat_id | cat_name |
--------------------------

Many thanks

Eoin

I'm trying to make one big array with my websites menu that has the categorys and the products i'm using code i found at http://www.phpfreaks.com/forums/index.php?topic=326419.msg1536842#msg1536842

its working fine till i try get the sub category and its products into the array


$cats = array( 0 => array( 'categoryID' => 1, 'name' => 'Menu', 'parent' => 0)

   ,1 => array( 'categoryID' => 50, 'name' => 'Takeaway', 'parent' => 60)

  ); //root of the category
$categorys = array( 1 => array(

 1 => array( 'categoryID' => 6 , 'name' => 'Breads' , 'parent' => 1 )

   

,0 => array( 'categoryID' => 2 , 'name' => 'Drinks' , 'parent' => 1 )

,2 => array( 'categoryID' => 7 , 'name' => 'Salads' , 'parent' => 1 )

)

    ,2 => array(

0 => array( 'categoryID' => 4 , 'name' => 'Tea' , 'parent' => 2 )

,1 => array( 'categoryID' => 18 , 'name' => 'Coffee' , 'parent' => 2 )

)

); // the category themselfs
$product = array(6 => array(

0 => array('productID' => 1, 'categoryID' => 6,'name' => 'Plain Bread', 'description' => 'description')

,1 => array('productID' => 2, 'categoryID' => 6, 'name' => 'Garlic Bread', 'description' => 'description')

)

 ,7 => array(

0 => array('productID' => 44, 'categoryID' => 7, 'name' => 'Garden Salad', 'description' => 'description')

,1 => array('productID' => 45, 'categoryID' => 7, 'name' => 'Greek Salad', 'description' => 'description')

)

 ,4 => array(
            

0 => array('productID' => 74, 'categoryID' => 4, 'name' => 'Green Tea', 'description' => 'description')

)

 ,18 => array(
            

0 => array('productID' => 75, 'categoryID' => 18, 'name' => 'Espresso', 'description' => 'description')

)

 ); // the products
if(is_array($cats)) {

    foreach($cats as $cat) {

      if(is_array($categorys[$cat['categoryID']])) {

  
            foreach($categorys[$cat['categoryID']] as $category) {

if(is_array($categorys[$category['categoryID']])) {

foreach ($categorys[$category['categoryID']] as $subcat){

$subcat['product'] = $product[$subcat['categoryID']];

$subprod[] = $subcat; //have tryed using parent $subprod[$subcat['parent']] but it over rides it self each time

}

}

 $category['product'] = $product[$category['categoryID']];

 
             $category['subcategory'] = $subprod; // here is where I'm having problem

 $this_category[] = $category;
            }
        }

if(!empty($this_category)){

$ncategory[]    = array($cat,$this_category);

}

$this_category        = array();
    }

  
}
print_r($ncategory); 


thank you for your time sorry for any spelling or grammar errors

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`)
)