php/mysql database to table help

firetiki

I am new to php.
I am trying to create a table where i can pull the url from a database and arrange it like this:

image1 image2 image3
image4 image5 image6

i found this earlier:

<?php

// ...
// You can choose any number here (I've changed it to
// uppercase to signify a constant)
$COLUMN_COUNT = 3;

$query1 = "SELECT id FROM bpic";

$result1 = mysql_query ($query1);

// Get the number of results returned by the query
$item_count = mysql_num_rows($result1);

// Get the number of rows in the table
$row_count = ceil($item_count/$COLUMN_COUNT);

echo '<table border="1" cellpadding="0" cellspacing="0">';
for($r = 0; $r < $row_count; $r++){

echo '<tr>';

for($c = 0; $c < $COLUMN_COUNT; $c++){

if(($item = mysql_fetch_assoc($result1)) !== false){
echo '<td>'.$item['bpic'].'</td>';

} else {
// If mysql_fetch_assoc($result1) returns false, it means
// we've come to end of our results, but we might still
// have some blanks tds to print to complete the row
echo '<td> </td>';

}
}
echo '</tr>';

}

echo '</table>';
?>

but i keep getting a thread problem with $query1 = "SELECT id FROM bpic";

that's my table and database, any help?

bastien

I don't see the connection bits

MYSQL_CONNECT and MYSQL_SELECT_DB, they are kinda required to be able to open the db to read from it

firetiki

thanks Bastien-

i found a dreamweaver extension called mxlooper that worked quite nicely.
http://firetiki.com/fd/test2.php
i'll apply that later
now i am trying to post images to a sql database from a browser so they could be added to the table.

i am working off this:
http://www.onlamp.com/pub/a/php/2000/09/15/php_mysql.html?page=1

here:
www.firetiki.com/fd/add.php

but nothing is being posted to the database.
are you familiar with that process at all?

thanks.
fitz

bastien

yes, to put images in a db and to show images from a db

firetiki

Bastien-

I am totally grateful for your help.
I am the type of person who will hammer away at this until it works but i am seriously stumped. Your code had a lot of double spaces in it so i was getting a lot of unexpected errors. i removed all the extra space and i am not getting the errors but now i am getting

Fatal error: Call to undefined function: connect() in /u/htdocs/dom123/fd/add.php on line 28

so i added a function connect() here:

$result=connect("INSERT INTO uptest (description,bin_data,filename,filesize,filetype)"."VALUES ('$image_desc','$data','$name','$size','$type')");
$id = mysql_insert_id();
}
function connect()
{

and i get this on the top of the screen:

This file has the following Database ID:

but it does not pass the information to the database.

here's what i have:

<?php echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">"; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head><title>Store binary data into SQL Database</title></head>
<body>
<?php
if ((isset($POST['submit']))&&(isset($FILES['form_data']))) {
upload();
} else {
show_form();
}//end if
function upload()
{
require("../Connections/firetiki.php");
//define variables
$image_file = '';
$image_desc = '';
$type = '';
$size = 0;
$name = '';
$image_file = $FILES['form_data']['tmp_name'];
$image_desc = $POST['form_description'];
$type = $FILES['form_data']['type'];
$size = $FILES['form_data']['size'];
$name = $FILES['form_data']['name'];
$data = fread(fopen($image_file, "r"), filesize($image_file));
$data = addslashes($data);
$result=connect("INSERT INTO uptest (description,bin_data,filename,filesize,filetype)"."VALUES ('$image_desc','$data','$name','$size','$type')");
$id = mysql_insert_id();
}
function connect()
{
print "<p>This file has the following Database ID: <b>$id</b>";
show_form();
}
function show_form()
{
?>
<form method="post" action="<?php echo $SERVER['PHP_SELF']; ?>" enctype="multipart/form-data">
File Description:<br>
<input type="text" name="form_description" size="40">
<input type="hidden" name="MAX_FILE_SIZE" value="1000000">
<br>File to upload/store in database:<br>
<input type="file" name="form_data" size="40">
<p><input type="submit" name="submit" value="submit">
<input type="button" name="move" value="Show" onClick="javascript:window.location='show_desc.php';">
</form>
<?php
}
?>
</body>
</html>

thanks
fitz

bastien

Sorry about that connect is my custom db connection function..here it is

function connect($sql)
{

$username 	= "user";
$pwd		    = "pasword";
$host 		  = "localhost";
$dbname 	  = "test";

if (!($conn=mysql_connect($host, $username, $pwd)))  { 
   printf("error connecting to DB by user = $username and pwd=$pwd");
   exit;
}
$db=mysql_select_db($dbname,$conn) or die("Unable to connect to database1"); 

$result = mysql_query($sql, $conn)or die("Unable to query local database <b>". mysql_error()."</b><br>$sql");
if (!$result){ 
	echo "database query failed."; 
}else{ 
	return $result; 
}//end if 
}//end function

firetiki

should $conn and $sql be

$conn = @mysql_pconnect($host, $username, $pwd);
$sql = "SELECT * FROM database";

because i am getting an unexpected T_VARIABLE for $sql here:

$result = mysql_query($sql,*$conn);

it didn't quite like the $db either so i used this:

$db = mysql_select_db($dbname, $conn);
if (!$db) {// open if2
** or die ('Unable to connect to database'.mysql_error());
}

Thanks Again.
Fitz

firetiki

scratch that.
i am using dreamweaver and when i pasted the code into this thing here i got an astrics after ($sql, that WAS NOT in the code but was there because when i recreated that space i did not get that error.

now i get no errors, i get this:

This file has the following Database ID: 0

and nothing is being passed to the database.
i am posting this question then i am going to go look for possible weird spaces in the first php

<?php
function connect($sql)
{// open function
$username = "username";
$pwd = "pwd";
$host = "hosting url";
$dbname = "database";
$conn = @mysql_pconnect($host, $username, $pwd);
$sql = "SELECT FROM table";
if (!($conn=mysql_connect($host, $username, $pwd))) {
printf("errorconnectingtoDBbyuser=$usernameandpwd=$pwd");
exit();
}
$db = mysql_select_db($dbname, $conn);
if (!$db) {// open if2
** or die ('Unable to connect to database'.mysql_error());
}//close if2
$result = mysql_query($sql, $conn);
if (!$result) {
echo ( "database query failed." );
} else {
return $result; }
}
?>

firetiki

this is the code from the form to see if there are any secret spaces in there.

<?php echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">"; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Store binary data into SQL Database</title>
</head>
<body>
<?php
if ((isset($POST['submit']))&&(isset($FILES['form_data']))) {
upload();
} else {
show_form();
}
function upload()
{
require("Connection");
//define variables
$image_file = '';
$image_desc = '';
$type = '';
$size = 0;
$name = '';
$image_file = $FILES['form_data']['tmp_name'];
$image_desc = $POST['form_description'];
$type = $FILES['form_data']['type'];
$size = $FILES['form_data']['size'];
$name = $FILES['form_data']['name'];
$data = fread(fopen($image_file, "r"), filesize($image_file));
$data = addslashes($data);
$result = connect("INSERT INTO uptest (description,bin_data,filename,filesize,filetype)"."VALUES ('$image_desc','$data','$name','$size','$type')");
$id = mysql_insert_id();
print "<p>This file has the following Database ID: <b>$id</b>";
show_form();
}
function show_form()
{
?>
<form method="post" action="<?php echo $SERVER['PHP_SELF']; ?>" enctype="multipart/form-data">
File Description:<br>
<input type="text" name="form_description" size="40">
<input type="hidden" name="MAX_FILE_SIZE" value="1000000">
<br>File to upload/store in *database:<br>
<input type="file" name="form_data" size="40">
<p><input type="submit" name="submit" value="submit">
<input type="button" name="move" value="Show" onClick="javascript:window.location='show_desc.php';">
</form>
<?php
}
?>
</body>
</html>