[RESOLVED] Inserting into mysql field and display of field on web page

[big-dog]

I have similar problem to this but I echoing results to a page I have a form that inserts data to mysql

$query = "INSERT into `".$db_table."` (venue,address,date_1,time_1,date_2,time_2,date_3,time_3,date_4,time_4,host,host_email,venue_website,venue_phone,logo_image) VALUES ('" . $_POST['venue'] . "','" . $_POST['address'] . "','" . $_POST['date_1'] . "','" . $_POST['time_1'] . "','" . $_POST['date_2'] . "','" . $_POST['time_2'] . "','" . $_POST['date_3'] . "','" . $_POST['time_3'] . "','" . $_POST['date_4'] . "','" . $_POST['time_4'] . "','" . $_POST['host'] . "','" . $_POST['host_email'] . "','" . $_POST['venue_website'] . "','" . $_POST['venue_phone'] . "','" . $_POST['logo_image'] . "')";
mysql_query($query);
mysql_close($link);
//This sends an email with results from form summated. Which gives a link to image when clicked it shows the image.
mail("[e-mail]","Venue Form submissions","Venue data:

Venue: " . $_POST['venue'] . " 
Address: " . $_POST['address'] . " 
Date1: " . $_POST['date_1'] . " Time1: " . $_POST['time_1'] . " 
Date2: " . $_POST['date_2'] . " Time2: " . $_POST['time_2'] . " 
Date3: " . $_POST['date_3'] . " Time3: " . $_POST['time_3'] . " 
Date4: " . $_POST['date_4'] . " Time4: " . $_POST['time_4'] . " 
Host: " . $_POST['host'] . " Host Email: " . $_POST['host_email'] . " 
Venues Website: " . $_POST['venue_website'] . " 
Venues Phone: " . $_POST['venue_phone'] . " 
Venues Logo: ".$where_form_is."files/".$logo_image_filename." (original file name: " . $_FILES['logo_image']['name'] . ")

");

But if I look at the database table field logo_imagae it is empty. This echo’s the results of submitted page.

$query= 'SELECT venue, address, date_1, time_1, date_2, time_2, date_3, time_3, date_4, time_4, host, host_email, venue_website, venue_phone, logo_image FROM Venues ORDER BY date_1 ASC LIMIT 0, 100';

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)) {

if (!empty($row['venue'])) echo "<b>".$row['venue']."</b><br />\n"; 
if (!empty($row['address'])) echo $row['address']."<br />\n"; 
if (!empty($row['date_1'])) echo $row['date_1']." ";
if (!empty($row['time_1'])) echo $row['time_1']."<br />\n"; 
if (!empty($row['date_2'])) echo $row['date_2']."  ";
if (!empty($row['time_2'])) echo $row['time_2']."<br />\n"; 
if (!empty($row['date_3'])) echo $row['date_3']."  "; 
if (!empty($row['time_3'])) echo $row['time_3']."<br />\n"; 
if (!empty($row['date_4'])) echo $row['date_4']."  "; 
if (!empty($row['time_4'])) echo $row['time_4']."<br />\n"; 
if (!empty($row['host'])) echo "Host: ".$row['host']."  "; 
if (!empty($row['host_email'])) echo "Host Email: ".$row['host_email']."<br />\n"; 
if (!empty($row['venue_website'])) echo $row['venue_website']."<br />\n"; 
if (!empty($row['venue_phone'])) echo $row['venue_phone']."<br />\n"; 
if (!empty($row['logo_image'])) echo $row['logo_image']."<br />\n";
//tried this to echo image but displays X image
    echo "<img src='/venue/files/' ".$row['logo_image']." '>"; 
 echo "<hr>";
}

No image from logo_image is displayed. the image is stored in a directory I tried the answer to this org post and it gives me a X image but the actual image isn’t displayed I believe because the field is empty and doesn’t know what to get to display. So how do I insert the file name into the logo_image field and what do I do to echo the image on the page.
Table Structure
logo_image text Yes NULL

[big-dog]

I changed a couple of lines now it displays the default image but still not the uploaded image from the form that was filled out the default if no image was uploaded is noimage.gif. still think its something to do with inserting into DB but dont know what to do now.
Please help

if(empty($row['logo_image']) && true) //debug
{
echo "<img src='admin/venues/files/noimage.gif'>";  // no image
}else{
echo "<img src='venues/files/{$row['logo_image']}'>";  // found image

}

[djjjozsi]

$POST and $FILES are different.

if you send the form, and upload an image , the image's name will be placed into:

$_FILES["logo_image"]["name"];

in your INSERT query you did not used this variables => no image name inserted.

you moved the image from the temporary folder into the destination folder?

move_uploaded_file(); <-- lets see examples about this function to do it.

troubleshooting:
1: always print your SQL query to know if all the inserrted values are in.

2: handle the mysql errors, to know if the query has syntax error or has the connection.

$results=mysql_query($query) OR DIE( mysql_error() . " sql was:" . $query);

Watch this link: here

[big-dog]

Heres what I tried and now it has Array in the DB field logo_image, but it still doesnt display on page didnt know what to put here if anything differant . "')"; on the logo_image line
Code from my form process page

$query = "INSERT into `".$db_table."` (venue,address,date_1,time_1,date_2,time_2,date_3,time_3,date_4,time_4,host,host_email,venue_website,venue_phone,logo_image) VALUES ('" . $_POST['venue'] . "','" . $_POST['address'] . "','" . $_POST['date_1'] . "','" . $_POST['time_1'] . "','" . $_POST['date_2'] . "','" . $_POST['time_2'] . "','" . $_POST['date_3'] . "','" . $_POST['time_3'] . "','" . $_POST['date_4'] . "','" . $_POST['time_4'] . "','" . $_POST['host'] . "','" . $_POST['host_email'] . "','" . $_POST['venue_website'] . "','" . $_POST['venue_phone'] . "','" . $_FILES['logo_image'] . "')";
mysql_query($query);

Code from the page to display the results from form

if(empty($row['logo_image'])) //debug
{
echo "<img src='admin/venues/files/noimage.gif'>";  // no image
}else{
echo "<img src='admin/venues/files/{$row['logo_image']}'>";  // found image

}

[big-dog]

I tried this

	if (!empty($row['venue_phone'])) echo $row['venue_phone']."<br />\n";

while ( $row = mysql_fetch_array ($logo_image) )
{
$logo_image = $row["logo_image"]; //picname is the name of the field in the images table
}
if(empty($row['logo_image']) && true) //debug
{
echo "<img src='admin/venues/files/noimage.gif'>";  // no image
}else{
echo "<img src='admin/venues/files/{$row['logo_image']}'>";  // found image

}

echo "<hr>";
}

Got this error but it shows the noimage image
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /public_html/venues.php on line 61
line 61 is while ( $row = mysql_fetch_array ($logo_image) )

[djjjozsi]

$_FILES is an array, means you reach its values with its indexes.

for further info, lets prints that for testing to know all the info you have:

print "<pre>";
print_r($_FILES);
print "</pre>";

$query = "............"','" . $_POST['venue_phone'] . "','" . basename($_FILES['logo_image']['name']) . "')";
mysql_query($query);

Did you tried this site? This can do what you need in a couple of clicks:

http://phpcode.hu/teszt/table_code/

[big-dog]

guess im a dumb s!@# gus I cant connect to database with link of form and Im useing the same info I use with my org.
Also I dont know where to put the testing stuff in the code I have,but here my insert stuff I change the $POST['logo_image'] . "')"; to $FILES and it just put Array in the field not the file name

$query = "INSERT into `".$db_table."` (venue,address,date_1,time_1,date_2,time_2,date_3,time_3,date_4,time_4,host,host_email,venue_website,venue_phone,logo_image) VALUES ('" . $_POST['venue'] . "','" . $_POST['address'] . "','" . $_POST['date_1'] . "','" . $_POST['time_1'] . "','" . $_POST['date_2'] . "','" . $_POST['time_2'] . "','" . $_POST['date_3'] . "','" . $_POST['time_3'] . "','" . $_POST['date_4'] . "','" . $_POST['time_4'] . "','" . $_POST['host'] . "','" . $_POST['host_email'] . "','" . $_POST['venue_website'] . "','" . $_POST['venue_phone'] . "','" . $_POST['logo_image'] . "')";
mysql_query($query);
mysql_close($link);

[djjjozsi]

$_FILES is an array, means you can't prints its value in one step.

if you add a file field to a form, its name is:

echo "<form name=\"aaaa\" method=\"post\"  enctype=\"multipart/form-data\" action=\"?\">";
echo '<input name="f_venue" type="text" value="'.    (!empty($_POST["f_venue"]) ? htmlspecialchars($_POST["f_venue"]):"" ).'"><br />'."\n";
.........
..........
............
echo '<input name="f_logo_image" type="file"><br />'."\n";;
echo '<input name="submit" type="submit" value="submit">';
print '</form>'; 

If you press the submit button, you need to check if the $FILES array is empty...

         if(!empty($_FILES["f_logo_image"]["tmp_name"]))
         {
         move_uploaded_file($_FILES["f_logo_image"]["tmp_name"] , "venues/files/".basename($_FILES["f_logo_image"]["name"])) OR die("Could not upload");
         $f_logo_image=basename($_FILES["f_logo_image"]["name"]);
         }

then build the query:
notice that in my example i've changed the variable names then in yours:

        $sql="INSERT INTO Venues (`venue`,`address`,`date_1`,`time_1`,`date_2`,`time_2`,`date_3`,`time_3`,`date_4`,`time_4`,`host`,`host_email`,`venue_website`,`venue_phone`,`logo_image`) VALUES ('$f_venue','$f_address','$f_date_1','$f_time_1','$f_date_2','$f_time_2','$f_date_3','$f_time_3','$f_date_4','$f_time_4','$f_host','$f_host_email','$f_venue_website','$f_venue_phone','$f_logo_image') ";

    mysql_query($sql) or die(mysql_error()); 

the generated code right here

[big-dog]

Thanks for the help I got this to work

while($row = mysql_fetch_array($result)) {

if(empty($row['logo_image']) || !file_exists("files/{$row['logo_image']}"))
    {
        echo "<img src=files/noimage.gif'>";  // no image
    }else{
        echo "<img src='files/{$row['logo_image']}'>";  // found image
    }

if (!empty($row['venue'])) echo "<b>".$row['venue']."</b><br />\n"; 
if (!empty($row['address'])) echo $row['address']."<br />\n"; 
if (!empty($row['date_1'])) echo $row['date_1']."  ";
if (!empty($row['time_1'])) echo $row['time_1']."<br />\n"; 
if (!empty($row['date_2'])) echo $row['date_2']."  ";
if (!empty($row['time_2'])) echo $row['time_2']."<br />\n"; 
if (!empty($row['date_3'])) echo $row['date_3']."  "; 
if (!empty($row['time_3'])) echo $row['time_3']."<br />\n"; 
if (!empty($row['date_4'])) echo $row['date_4']."  "; 
if (!empty($row['time_4'])) echo $row['time_4']."<br />\n"; 
if (!empty($row['host'])) echo "Host: ".$row['host']."  "; 
if (!empty($row['host_email'])) echo "Host Email: ".$row['host_email']."<br />\n"; 
if (!empty($row['venue_website'])) echo $row['venue_website']."<br />\n"; 
if (!empty($row['venue_phone'])) echo $row['venue_phone']."<br />\n"; 


echo "<hr>";
}