Displaying pictures

Posted on 16th Feb 2014 07:03 pm by admin

i have worked my way through storing images in directory and storing the location in mySQL db.Now i was trying to make a Image gallery for just that particular user who had uploaded those images. i am having problem with that.
Code: <?php
session_start();
$username = $_SESSION['UserName'] ;
echo "Username : ".$username."<br/><br/>";
$user=$username;//storing session in another variable
include('dbconnect.php');//Conncetion to Database

$qry = "SELECT * FROM UserImage WHERE UserName = '$user' ";
$result = mysql_query($qry,$connection);
$result2 = mysql_num_rows($result);
if($result2 == 0)
{die('Username does not exist.');}
else{

[b]/////I need help here.how do i make all those images display here[/b]


}

}
?>

Your Answer:

Login to answer

Other forums

Not Inserting into DB
I can't get my Add new Division form to submit to the database. Anyone see my issue?

Code: &a

first id from db not showing
I have a php script which displays the content of a mysql table as a html table with sorting, delete

Help with PHP and checkboxes
I am posting this for a friend of mine, i wrote a small script for her to process her form data to a

some query on multilingual website
Hi all,

Which is the simplest and easiest method to make a website multilingual,
is it put

help with variable
I've got a problem, i want to echo some images depending on the $id, however for me to get that id i

PHP & Java
Hello,

can PHP code be used inside java code?

Code: <SCRIPT LANGUAGE="Java

How to read CSS message data
Hi,
I have a requirement here. When working as a Dev angel for multiple customers its really di

Request-URI Too Large
I have created a simple submit form for a mysql database that puts a piece of code into database.<

When file included, REMOTE_ADDR is server's?
I have an index file that handles my site, basically index.php?page=ip will activate "require('

How to clone an SAP ECC using bacup tape on z/os?
We want to clone our production to a different SID using backup tape.