PHP - Combine Sorty By Date And By Category Feature?

I'm using the wordpress themeplate, that has feature box in main page, which it use the feature images that has been listed on the pages, and it has this little icons that swtich them around every few second,
now i need to have a small modification.

i need the hover that is appearing on the top of the small boxes to show the tittle center, and also i need it to be linked (a href) to their pages...
and the main background photo to be linked to that page as well.


please help me

url: http://www.makooliprekupec.com/en/

I had a question and couldn't really pin-point a forum to put this post in, so I hope this suits my topic.

You always hear "Facebook is rolling out a new feature"; most recently "Twitter is rolling out the New Twitter.com" but it only releases to so many people at time. Or friends will get features on Facebook before I do (like I couldn't like threaded comments until about a month after all my other friends could).

I was just wondering if anyone knows the actual method or how large sites go about releasing new features to users?

We want to add a chat feature in PHP for a social site can somebody suggest a good solution, a script maybe, where registered users when online can chat with other registered members in the friend list

I have made a script to upload a few files from the pc to my server.. like i upload big files which are generally above 50mb of size.. but most of the times as there is some problem with the internet the hours of wait is just ruined.. is there a better way to upload files.. i use the normal function

move_uploaded_file($_FILES['song1_upload']['tmp_name']

can anyone give a better idea than this?

I have made a script to upload a few files from the pc to my server.. like i upload big files which are generally above 50mb of size.. but most of the times as there is some problem with the internet the hours of wait is just ruined.. is there a better way to upload files.. or anything that if the internet connection is interupted the downloading starts from wer it stopped cuz of the problem.. please help.. i use the normal function for uploading a file

move_uploaded_file($_FILES['song1_upload']['tmp_name']

can anyone give a better idea than this?

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

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.

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.

Hi guys, im currently querying my database and if ($row) im including a file. But i would like to make it so if ($row) or a session variable is active, to include the file.

I have tried using || but ive only ever used that for regular variables and I cant get it working in the way i want.

so at the moment i have

Code: [Select]
if ($row)

(

require 'myfile';
and i would like to add || $_SESSION['email'] is active. im guessing i would use isset, but i just cannot get it working.

I just came up with this idea I got for my registration script, where when the user has complete all steps in the registration process, he/she comes to a page that displays this:
Code: [Select]
<h1>Step 3: Activate your account</h1>
<h2>Congratulations, <strong><?php echo $_SESSION["user"]["username"]; ?></strong>!</h2>
<p>An email has been sent to <strong><?php echo $_SESSION["user"]["email"]; ?></strong> with an activation key, and important information regarding your account. Please check your email to complete registration.</p>

Then this:

Code: [Select]

$email_client = preg_match ("/[@][a-zA-z0-9]{10}\.com$/", $_SESSION["user"]["email"]);
$email_link = "<a href='http://www." . $email_client . ".com'>Go to " . $email_client . " mail now!</a>";
echo "<p class='center_align'>" . $email_link . "</p>";

Basically, what it does, is it figures out what email provider the user supplied as their email, and generates a link that allows them to go to that website, without having to type it in the address bar (I think I got that idea from facebook lol; only they probably do it differently).

So anyway, It's not complete, and this is where I need someone's help...

I assign a preg_match function to $email_client, so if it finds a string like "@yahoo.com", $email_client will be true, but that's not what I want. I want $email_client to equal a string, such as "yahoo" or "aol" based off of what the preg_match function finds, WITHOUT using if/else statements.

Before I did an if/else statement for every email provider I could think of, but I think it better if I do it this way, as some people have crazy a** email names lol.

So, basically what I want to do is this:
Code: [Select]
<?php
//Step 1: Check email
preg_match("/[@][a-zA-z0-9]{10}\.com$/", $_SESSION["user"]["email"]);
//Step 2: Somehow assign the "a-zA-z0-9{10}" part to a variable
//Step 3: Generate link with that variable used in the "href" attribute and the label
?>

But I have no idea how to go about this...Help?

I would like to have the option of thanking people by the press of a button.   Currently there is a like button but that's entirely different than a thank you button.

Is PHP used to create this type is feature? I already have a MYSQL table set up, how difficult is it to create this sort of feature?

On this image, where it says 'filter your results' if a user clicks 'Detached Houses' then only detached houses will be displayed. if a user clicks 'Semi-detached' then only semi detached houses will be shown.

Whats the technical term for this type of feature, and can you point me towards any tutorials etc, would really appreciate it. thank you!

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=314222.0

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.