Richard
I'm sorry, it looks like I sent a reply direct to you instead of the board,
a mistake on my part. Here is the message.
Richard
Thank you for your reply.
Something good is happening. When I look into the actual DB, I see in the
keyword column
a:9:{i:0;s:3:"fox";i:1;s:6:"wolves";i:2;s:8:"wildl (this is
truncated),which seems to be the values within the array.
I used your serialized suggestion for this.
However when I bring the table to the screeen of a browser, I still get
Array.
Here is the updated coed of the insert.php
<?php
$caption=($_POST['caption']);
$keyword=($_POST['keyword']);
$description=($_POST['description']);
$image_file=($_POST['image_file']);
$where_taken=($_POST['where_taken']);
$dbc=mysqli_connect('localhost', 'root', '', '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";
}
$keyword = serialize($_POST['keyword']);
mysqli_close($dbc);
and the updated display code
$query="SELECT * FROM images";
$data = mysqli_query($dbc, $query);
// Loop through the array of score data, formatting it as HTML
echo '<b>Image display information from Database</b>';
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)) {
// Display the 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>' . $keyword = unserialize($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>';
}
Thank you again for your help.
gary
"Richard Quadling" <rquadling@xxxxxxxxxxxxxx> wrote in message
news:g2u10845a341004210827nc50b743cia5f0a44f644b4903@xxxxxxxxxxxxxxxxx
On 21 April 2010 16:01, Gary <gwp@xxxxxxxxxxxxxxxx> wrote:
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
As you are using <input type="checkbox" name="keyword[]" value="fox"
/>, then you are creating an array called $_POST['keyword'].
So far so good.
When you construct your SQL statement, you are trying to put the array
into a string ...
Unfortunately, an handling an array like that will result in the array
becoming the text ...
Array
e.g.
<?php
$a = array(1,2,3);
$b = "$a $a $a";
echo $b;
?>
outputs ...
Array Array Array
So, either you need to store the keywords in a separate table and link
it to the main table by some sort of ID, or convert the array to a
string.
You could use something like ...
$keywords = implode("\t", $_POST['keyword']);
to produce a tab separated list of keywords.
You could use a comma (',') as the separator, but if any keyword
contains a comma (unlikely, but thinking ahead, keywords COULD be
keyphrases), then the comma becomes a separator on the way out.
Or you could serialize the array if you weren't interested in
processing it in the DB.
$keywords = serialize($_POST['keyword']);
On the way out of the DB, you would use ...
$keywords = explode('\t', $row['keywords']);
or
$keywords = unserialize($row['keywords']);
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
__________ 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 5048 (20100421) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
