[support] webform image upload - Where is kept in database?

[Néstor]

I found my answer but I used PHP coding and there is probably a
better way using webform functions.
1) I create a page of type page
2) I added the below code to obtain and display my webform information
------------------------
<?php
// set the table titles
$header = array('FIRST', 'LAST', 'COMMENT', 'ZIP', 'PHOTO');

// get data from webform_views_nestorwebform table
// this table is created by the webform_mysql_views module
// and it contains the data from a webform
$query = "SELECT first, last, comment, zip, photo FROM
{webform_views_nestorwebform} where approved=1 ORDER BY first";

$q = db_query($query);

// move the returned array to $rows
while ($r = db_fetch_array($q)) {
   $rows[] = $r;
}

for($i=0; $i<count($rows);$i++) {
  foreach($rows[$i] as $key => $value) {
    if($key == 'photo' && $value > 0) {
        $fid=$value;
        $myfile = db_fetch_object(db_query("SELECT * FROM {files} WHERE fid
= %d", $fid));
        $fname=$myfile->filename;
        $fpath=$myfile->filepath;
        $rows[$i][$key] = "<a href='$fpath'><img src='$fpath' width='50px'
height='30px'></a><Br\n";
    }
  }
}

// the theme function automatically create the table title
// and display the data for the table
print theme('table', $header, $rows);

?>
----------------------------------------

If you know a better way, please let me know,
Thanks!!!

On Tue, Oct 28, 2014 at 12:29 PM, Néstor <rotsen at gmail.com> wrote:

> when I do a select on teh webform_submitted_data table
> select * from webform_submitted_data where nid=9515 and sid=1421;
>
> the record where the image  give me the number 673
>
> nid     sid    cid   no    data
> 9515 1421  6     0     673
>
> How does that finds the path of the uploaded file?
>
> HELP?
>
> On Tue, Oct 28, 2014 at 10:51 AM, Néstor <rotsen at gmail.com> wrote:
>
>> HI guys,
>>
>> I am working with webform and so far so good but I am having the problem
>> that when I createa form using webform and the form has a image upload I
>> can not find the image url in the table.
>>
>>
>> I know where the images are on the server but nothing tells me which
>> image goes with which submission.
>>
>> If I edit the submission it shows the image path or URL but in the table
>> where do I find this.
>> I do not see it in webform or webform_submissions o
>> webform_submitted_data tables.
>>
>> Where is the image url kept on the table?
>>
>> thanks!!!
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20141029/608f564f/attachment.html