Ashley
Thank you for your reply.
I was trying to get the structure of the DB into a text form, cant seem
to
find that (phpmyadmin).
This is the insert code
<?php
$caption=($_POST['caption']);
$keyword=($_POST['keyword']);
$description=($_POST['description']);
$image_file=($_POST['image_file']);
$where_taken=($_POST['where_taken']);
$dbc=mysqli_connect('', '', '', 'images');
$query="INSERT INTO images(caption, where_taken, keyword, description,
image_file) VALUES
('$caption','$where_taken','$keyword','$description','$image_file')";
if (isset($_POST['submit'])) {
$how_many = count($keyword);
echo 'keywords chosen: '.$how_many.'<br />';
if ($how_many>0) {
echo 'You chose the following keywords:<br />';
}
for ($i=0; $i<$how_many; $i++) {
echo ($i+1) . '- ' . $keyword[$i] . '<br />';
}
echo "<br />";
}
$result = mysqli_query($dbc, $query)
or die('Error querying database.');
if($result == true) {
echo "Successfully Inserted $image_file into database";
} else {
echo "Some Error Occured While Inserting Records";
}
mysqli_close($dbc);
?>
I hope that helps, and again thank you for your reply.
gary
"Ashley Sheridan" <ash@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:1271858245.20937.10.camel@xxxxxxxxxxxx
> On Wed, 2010-04-21 at 09:47 -0400, Gary wrote:
>
>> I have a form that I have a (ever growing) list of checkboxes, Here
>> is a
>> sample of the code for it.
>>
>> <input name="keyword[]" type="checkbox" value="fox" />
>>
>> It seems to go in, when I say seems to, I get a result of Array in the
>> table, the code is listed below. I have tried various solutions I
>> found
>> in
>> searching the issue, but have only been able to so far get Array.
>>
>> echo '<table border="1"><th>Id Number</th><th>Date
>> Entered</th><th>Caption</th><th>Where
>> Taken</th><th>Keywords</th><th>Description</th><th>Image</th>';
>> while ($row = mysqli_fetch_array($data)) {
>>
>> echo '<tr><td>' . $row['image_id']. '</td>';
>> echo '<td>' . $row['submitted']. '</td>';
>> echo '<td>' . $row['caption']. '</td>';
>> echo '<td>' . $row['where_taken'] . '</td>';
>> echo '<td>' . $row['keyword']. '</td>';
>> echo '<td>' . $row['description'] . '</td>';
>> if (is_file($row['image_file'])) {
>> echo '<td><img src="'.$row['image_file'].'" width="100px"
>> height="100px"/></td>';
>> }
>>
>> As a bonus question, does anyone have any idea why the image would
>> show
>> up
>> in IE8, and not FF?
>>
>> Thanks for your help.
>>
>> Gary
>>
>>
>>
>> __________ Information from ESET Smart Security, version of virus
>> signature database 5047 (20100421) __________
>>
>> The message was checked by ESET Smart Security.
>>
>> http://www.eset.com
>>
>>
>>
>>
>>
>
>
> You say you're getting an entry of Array in your table. Is this after
> performing an insert query from the form? If so, we're gonna need to
> see
> the code for that! If it's that you're retrieving from the DB and
> getting Array as the output, then it could be that you're using string
> functions on an array. However, as you said images are displaying, I
> don't think that's the case. Maybe some of the fields in the DB have a
> string literal of 'Array' as their value?
>
> As for the images not displaying correctly, have you tried to just open
> those images up in a browser using their uri? Just copy and paste it
> from the <img> tag. It might give more input on exactly what is
> happening with the image.
>
> Thanks,
> Ash
> http://www.ashleysheridan.co.uk
>
>
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 5047 (20100421) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
__________ Information from ESET NOD32 Antivirus, version of virus
signature database 5047 (20100421) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
