import filenames

[Raffie_s]

hi people,
I'm new here, I've created a SQL database that shows my photo's.
I have a exif export program that exports some exif information to a text file, like file location, shutterspeed etc etc.
I want to import the text file into my database.
it works fine I see all the info that I need.
only one thing:
the field filelocation is not displayed correctly, that field should be like:
f:\photo\nature\tree.jpg
but it displays this:
f:photonaturetree.jpg
he doesn't import the backslash.
how can I fix this problem???

Ralph

[planetsim]

You will need to use addslashes

[Frederick]

Backslashes in PHP are used to by PHP to interpret a non php code item. Such as the following:

Using double quotes in your statements.
echo "Hello, my name is \"Tester\". ";

Expressions so you can search for items such as periods in strings
if (ereg(".@..com",$variable)) {

Always use forward slashes in your paths. When ever you are using anything that interacts with a browser, you use forward slashes.

[Raffie_s]

cool
it seems to work
there is only one little problem:

echo '<a href="file:///'.$location.'">'.'<img src="file:///'.$location.'" width="150" height="150">';

the result of this line here is this:
I see the picture (img tag)
but the "A href" doesn't work
the picture has a blue border with means it's a Hyperlink and when I move the mouse over the hyperlink I see the target location in the statusbar below.
but when I click on the hyperlink, nothing happens. and in plain HTML the result is just fine.

anny exlenations for this??

Ralph

[Frederick]

Could you post your source code here. Am at a stand still unless I see where $location is coming from and how the value of $location is displayed.

[Raffie_s]

<?php

function getrecords(){

$sql = 'SELECT * FROM `foto` ';
echo '<br>';

$db = mysql_pconnect('localhost');
if (!$db) {
echo 'Fout: kreeg geen verbinding met de server.<br>';
echo 'MySQL retouneerde: ' . mysql_error();
exit;
}

mysql_select_db('foto');
$result = mysql_query($sql);

if (!$result) {
echo 'error: SQL_error.' . mysql_error();
exit;
}
return $result;
}

$result = getrecords();
$num_results = mysql_num_rows($result);
echo '<table border=7 bordercolordark="#330033" bordercolorlight="#3300CC" bordercolor="#990000">';
for ($i=0; $i < $num_results; $i++) {
$row = mysql_fetch_array($result);
$datepicture = $row['datepicture'];
$resolutie = $row['resolution'];
$location = $row['location'];
echo '<TR><TD>';
echo '<a href="file:///'.$location.'">'.'<img src="file:///'.$location.'" width="150" height="150">';
echo '</td><td>';
echo '<strong>Date: '.$datepicture.'</strong><br>';

echo 'Resolution photo: '.$resolution .'<br>';
echo 'Location: '.$location .'<br>';
echo '</td>'."\n";

}
echo '</table>';
?>

---

why can't I open the hyperlink and why can I see the image??

Ralph

[Frederick]

Your code:

echo '<a href="file:///'.$location.'">'.'<img src="file:///'.$location.'" width="150" height="150">';

Try this:

echo "<a href=\"file:///".rawurlencode($location)."\">'.'<img src=\"file:///\"".$location."\" width=\"150\" height=\"150\"></a>";

I see 3 items that can cause issues.
1. Try to keep in practice of using double quotes instead of singles for surrounding your code.
2. Use rawurlencode() if all fails incase there is an issue with the browser.
3. There is no closing tag for your hyperlink </a>.