PHP - Easiest Question Ever

say i have a mysql table with the following fileds

user_id
picture_category
picture_title
picture_description
picture_thumb   //small image size
picture_normal  //large image size.

ok what I'm trying to do is this.

if( user_id && picture_category == the same name show all the pictures in that category as one section)
//show this category and all the images from this user_id and picture_category

so if this user_id has a new category name and new images uploaded it would show the images in the right category.

my php xml script is in the works and is looking like this so far.
<?php
include "../../connect.php";
Header('Cache-Control: no-cache');
Header('Pragma: no-cache');
$username = mysql_real_escape_string($_GET['username']);
$user_folder = mysql_real_escape_string($_GET['user_folder']);
//$password = mysql_real_escape_string($_GET['password']);
$friend = (isset($_GET['friend'])) ? ' AND b.friend = \'' . mysql_real_escape_string($_GET['friend']) . '\' ' : NULL;
$query = "SELECT * FROM accounts WHERE username = '$username'";
$results = mysql_query($query) or die("Data not found."); 
//Get the number of results from the query.
$rows = mysql_num_rows($results);




//If their is a match for the username, echo the the users xml data.
if($rows == 1) 
{
$query1 = "SELECT * FROM user_photo_gallery WHERE username = '$username'";
$query2 = "SELECT * FROM user_photo_gallery WHERE username = '$username' AND user_folder = '$user_folder'";
$results1 = mysql_query($query1) or die("Data not found."); 
$results2 = mysql_query($query2) or die("Data not found."); 
//$row = mysql_fetch_assoc($results1); 

$user_xml = "<?xml version=\"1.0\"?>\n";
$user_xml .= "<settings>\n";
$user_xml .= "<sceneHeight>600</sceneHeight>\n";
$user_xml .= "<sceneWidth>1000</sceneWidth>\n";
$user_xml .= "<titleColor>#000000</titleColor>\n";
$user_xml .= "<descriptionBgAlpha>70</descriptionBgAlpha>\n";
$user_xml .= "<showFullscreenBtn>no</showFullscreenBtn>\n";
$user_xml .= "<waterMark useImage=\"no\"><![CDATA[THIS]]></waterMark>\n";
$user_xml .= "</settings>\n";
$user_xml .="<galleries>\n";
//$sql = "SELECT a.username,a.user_folder,a.large_pic,a.small_pic,a.pic_title,a.pic_discription,b.username FROM (user_photo_gallery as a )JOIN `user_friends_list` as b ON (b.friend = a.username)WHERE (b.username = '$username' $friend AND b.status = 1) ORDER BY a.user_folder DESC";
//$result2 = mysql_query($sql);
//if(mysql_num_rows($result2) > 0) 
//{  
while ($row = mysql_fetch_assoc($results1)) 
{
$user_xml .="<gallery theName=\"". $row['user_folder'] ."\" itemsPerRow=\"3\" autoStart=\"no\" playTime=\"5\" autoResize=\"yes\" xOffset=\"5\" yOffset=\"10\" showTitleOnThumbs=\"yes\" allowDownload=\"yes\">\n";
if($row['user_folder'] =="Demo_Photos")
{
 //select all pictures where this folder name and username maybe?
while ($row1 = mysql_fetch_assoc($results2)) 
{
$user_xml .="<picture largePicture=\"". $row1['large_pic'] ."\" smallPicture=\"". $row1['small_pic'] ."\" theTitle=\"". $row1['pic_title'] ."\"><![CDATA[". $row1['pic_discription'] ."]]>\n";

$user_xml .="</picture>\n";
}
}
else
{

}
$user_xml .="</gallery>\n";
}
//}
//else
//{
//echo "Wiistream Eorror!\n";
//};
$user_xml .="</galleries>\n";
echo $user_xml; 
}
else
{
echo "Wiistream Eorror!\n";
}

?>


the real xml file should look like this.
Code: [Select]
<?xml version="1.0" encoding="utf-8"?>

<settings>

<sceneHeight>600</sceneHeight>

<sceneWidth>1000</sceneWidth>

<titleColor>#000000</titleColor>

<descriptionBgAlpha>70</descriptionBgAlpha>

<showFullscreenBtn>no</showFullscreenBtn>

<waterMark useImage="yes"><![CDATA[<font size="20">Copyright (c) 2010</font> <font color="#000000"><Strong>WiiStream</Strong></font>]]></waterMark>

</settings>



<galleries>

<gallery theName="USERS PERSONAL GALLERY TITLE" itemsPerRow="3" autoStart="no" playTime="5" autoResize="yes" xOffset="5" yOffset="10" showTitleOnThumbs="yes" allowDownload="yes">

<picture largePicture="http://acadianfury.files.wordpress.com/2007/01/mazda.jpeg" smallPicture="http://acadianfury.files.wordpress.com/2007/01/mazda.jpeg" theTitle="USERS TITLE OF PICTURE"><![CDATA[USERS DISCRIPTION OF PICTURE CAN USE TAGS]]></picture>



</gallery>

<gallery theName="USERS PERSONAL GALLERY TITLE1" itemsPerRow="3" autoStart="no" playTime="5" autoResize="yes" xOffset="5" yOffset="10" showTitleOnThumbs="yes" allowDownload="yes">

<picture largePicture="http://acadianfury.files.wordpress.com/2007/01/mazda.jpeg" smallPicture="http://acadianfury.files.wordpress.com/2007/01/mazda.jpeg" theTitle="USERS TITLE OF PICTURE"><![CDATA[USERS DISCRIPTION OF PICTURE CAN USE TAGS]]></picture>
<picture largePicture="http://acadianfury.files.wordpress.com/2007/01/mazda.jpeg" smallPicture="http://acadianfury.files.wordpress.com/2007/01/mazda.jpeg" theTitle="USERS TITLE OF PICTURE"><![CDATA[USERS DISCRIPTION OF PICTURE CAN USE TAGS]]></picture>




</gallery>

<gallery theName="USERS PERSONAL GALLERY TITLE2" itemsPerRow="3" autoStart="no" playTime="5" autoResize="yes" xOffset="5" yOffset="10" showTitleOnThumbs="yes" allowDownload="yes">

<picture largePicture="http://acadianfury.files.wordpress.com/2007/01/mazda.jpeg" smallPicture="http://acadianfury.files.wordpress.com/2007/01/mazda.jpeg" theTitle="USERS TITLE OF PICTURE"><![CDATA[USERS DISCRIPTION OF PICTURE CAN USE TAGS]]></picture>
<picture largePicture="http://acadianfury.files.wordpress.com/2007/01/mazda.jpeg" smallPicture="http://acadianfury.files.wordpress.com/2007/01/mazda.jpeg" theTitle="USERS TITLE OF PICTURE"><![CDATA[USERS DISCRIPTION OF PICTURE CAN USE TAGS]]></picture>
<picture largePicture="http://acadianfury.files.wordpress.com/2007/01/mazda.jpeg" smallPicture="http://acadianfury.files.wordpress.com/2007/01/mazda.jpeg" theTitle="USERS TITLE OF PICTURE"><![CDATA[USERS DISCRIPTION OF PICTURE CAN USE TAGS]]></picture>
<picture largePicture="http://acadianfury.files.wordpress.com/2007/01/mazda.jpeg" smallPicture="http://acadianfury.files.wordpress.com/2007/01/mazda.jpeg" theTitle="USERS TITLE OF PICTURE"><![CDATA[USERS DISCRIPTION OF PICTURE CAN USE TAGS]]></picture>


</gallery>
</galleries>

but using it with mysql it only gets the user_id and the picture_category for this user and pulls back that users data only.
I also have a join table included to join if this user has friendship with that user.
and then you would see all your pictures upload and category's. and all your friends pictures and category's.

In php, which function is best used to act something like the sql "LIKE" command? and how would that function be used like?

I'm considering getting a VPS, but I'm not entirely sure what this would be able the handle. The specs doesn't look that good to me, but my friend swears it will handle running apache/php/mysql handling large websites and databases without a problem. I want to run multiple databases that just store statistics and I'm a bit worried about the RAM and the company doesn't even mention a cpu.

Here's the specs:
256MB RAM
300GB HDD
10Mbps unmetered
1 IP Address

My friend runs two counter-strike: source servers off his VPS (same stats).. so I'm actually considering this, but it just seems like it's not powerful enough.

Oh.. forgot the most important part.. it's only $9.

I have an issue with the below code

Code: [Select]
if ($gtype == "%24L" || $gtype == "$L")
The value actually starts with the dollar sign then L, but its being read as a variable that's not assigned so it showing as blank. so the question is how to I get to check and see if the value of gtype actually is $L in a way that it wont read $L as a variable and as a value instead?

I am trying something simple, creating some horses and making them race using OOP, creating them is easy, how can i find out which one "won" based on the highest total. Here is what i got so far

Code: [Select]
<?php

class Horse
{
   public $strength;
   public $speed;
   public $agility;         

        public function create($name,$age,$odds){
            $this->name=$name;
            $this->odds=$odds;
            $this->strength=(rand(50,200) * $this->odds - $this->age);
            $this->speed=(rand(100,400) * $this->odds - $this->age);
            $this->agility=(rand(150,250) * $this->odds - $this->age);
            $all=array(0=>"$this->strength",1=>"$this->speed",2=>"$this->agility");
            echo "<b>$this->name</b> has a strength of <b>$this->strength</b>, a speed of <b>$this->speed</b> and agility at <b>$this->agility</b>. --- <b>".array_sum($all)."</b><br>";
        }
}

$mix=rand(2,6);
$a=new Horse;
  $a->create("Dave",  2, $mix);
  $a->create("Dude",  3, $mix);
  $a->create("Evan",  3, $mix);
  $a->create("Jill", 15, $mix);
  $a->create("Flex", 10, $mix);

?>

I cant figure out a way to find out who had the highest total, i would love to know what i am doing wrong.

Major breakthrough.  utf8_encode() allows me to view utf-8 characters in the browser.  Therefore, my source data file must be ISO-8859-1 encoded text, right?   Am I understanding this correctly?

<?php
//mb_internal_encoding("UTF-8");
header('Content-type: text/html; charset=utf-8');
$file = fopen('some_csv_file_created_by_excel.csv', "r");
ob_start();
while (($spec = fgetcsv($file, 100000, ",")) !== FALSE){
    echo($spec[0].' '.utf8_encode($spec[0]).'<br>');
}
$string=ob_get_clean();
?>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
        <title>utf</title>
    </head>
    <body>
        <p><?php echo($string);?></p>
    </body>
</html>

Edited by NotionCommotion, 11 January 2015 - 08:22 PM.

hi php people,

I am wondering will  if the code below will work when I call $C->getafoo() will I get foo;  I keep getting an error at this point  return $this->A->a(); saying  the method is not there

Code: [Select]
class A{
  public function a(){
    return "foo";
  }
}

class B {
  public $A;

  function __construct($A) {
    $this->A = $A;   

  }

  public function geta(){
    return $this->A->a();
  }
}


class C extends B{
  public function getafoo(){
   return geta();
 }

}
$C = new C(new A());

echo $C->getafoo();

Hello, i am currently working on a project and i have been on google and nothing has helped i am trying to detect characters in the URL so for example XSS if someone typed in the URL:

home.php?=<script>document.cookie();</script>

OR

home.php?=<?php echo file_get_contents("document.txt", "a");

How would i be able to make a kind of firewall to detect this?   and if it does then redirect to another page.   Thanks.

U guys know in forums how at the top or bottom there links to the "1 2 3 4 5 next" and stuff? and how it loads a database? how would i do that exactly? or explain to me what it could be called. cause me i have no idea :/

Hello. I'm trying to pull information out of an xml file. However I'm a bit lost in getting the actual value.

Code: [Select]
$url="http://ws.audioscrobbler.com/2.0/?method=artist.getimages&artist=Dr%20Feelgood&limit=1&autocorrect=1&api_key=c107c9b5c09cb5693b6c19409dd984c1";

$xml = simpleXML_load_file($url,"SimpleXMLElement",LIBXML_NOCDATA);

$largesquare=$xml->images->sizes->size[2];
Is what I have but its not pulling the information. The above url will give you the link to a set xml file for this example. And I want to get the info for the

Code: [Select]
<size name="largesquare" width="126" height="126">http://userserve-ak.last.fm/serve/126s/43173899.jpg</size>
I'm sure I'm doing something wrong that's a simple fix but I am lost here. In the sizes there are 6 different size options each with different names and I have no idea how to pull the one with the correct name that I need.

Thank you to who ever can help me sort this out.

Hi,

I am looking into a way of adding addons to a class I made.. I thought something like this would work, but not sure how to implement it:

Code: [Select]
<?php
class foo {
    function foobar($text) {
        $text = $text . 'b';
        return $text;
    }
}
class bar extends foo {
    function foobar($text) {
        $text = $text . 'c';
        return $text;
    }
}

$var = new bar();
$var->foobar('a'); // this would then return abc
?>

Now i want to be able to call up foo, and it calls the foobar of foo, and the foobar of bar.
is that possible?

hosh

I am trying to make my database search only search where private = '$priiv'(Usually 0,1, or 2) but it does not work
Code: [Select]

$query_search = "SELECT * FROM users WHERE username LIKE '%$idea%' OR fname LIKE '%$idea%' OR lname LIKE '%$idea%' OR tags LIKE '%$idea%' AND private = '$priiv'";

What am i doing wrong?

I am trying to make it so that it will load if the site if the site is online(EG. $siteonline = 1), and so on. I can't seem to think of how I could do this so it will work from the very top of the page's html, to the very bottom.

Like the following code is meant to list all of the stuff in that database.
<?php
$list_q = mysql_query("SELECT * FROM settings") or die (mysql_error());
while($list_f = mysql_fetch_assoc($list_q)) {
}
?>

I have my page laid out like this..
<?php 
include "includes/connect.php";
include "includes/config.php"; 
?>
<?php
    $list_q = mysql_query("SELECT * FROM settings") or die (mysql_error());
    while($list_f = mysql_fetch_assoc($list_q)) {
?>
Html content etc..
<?php 
}
include 'includes/footer.php'; ?>

But if I do it that way, It only displays what is in footer.php.

i have took a test that i think it has some errors:

can you please confirm or infirm that A is the right answer?



Question:    

The default value for __FILE__ is _______________________________.

 
   
A.    

the complete path of the currently executing script

B.    

the relative path of the currently executing script

C.    

a magical constant; it does not have a default value

D.    

the complete path of the previous executed script

E.    

the relative path of the previous executed script

Correct Answer:    C
User Answer:    A
Explanation:    The PHP engine stores the full path and filename of the currently executing script within the __FILE__ constant.

I'm creating a re classified ad site and I've hit a brick wall.  I'm trying to create a 'listing' which will contain info and pictures of the property that's for sale, but I'm unsure on how to do it.  Would I have to create different db tables to have the albums, images and listing together? Or would can I just do it all in one table?  I appreciate your help.