I am having a problem adding an image to a blog field. I keep getting:
Warning: fopen("C:\Documents and Settings\username\Desktop\campus.jpg", "r") - No such file or directory in /home/www/bns/db/films.php on line 12
Warning: stat failed for C:\Documents and Settings\username\Desktop\campus.jpg (errno=2 - No such file or directory) in /home/www/bns/db/films.php on line 12
Warning: fread(): supplied argument is not a valid File-Handle resource in /home/www/bns/db/films.php on line 12
Here is my script below
<?
if($submit){
$usr = "username";
$pwd = "password";
$db = "data1";
$host = "localhost";
$cid = mysql_connect($host,$usr,$pwd);
mysql_select_db($db,$cid);
$image = addslashes(fread(fopen($frm_poster, "r"), filesize($frm_poster)));
$SQL = " INSERT INTO films(filename,date,website,director,writer,plot,poster) ";
$SQL = $SQL . "VALUES('$frm_film','$frm_date','$frm_url','$frm_director','$frm_writer',";
$SQL = $SQL . "'$plot','$image')";
$result = mysql_query("$SQL");
}
else{
?>
<form name="films" action="<? echo $PHP_SELF?>" method="post">
Film Name: <input type="text" name="frm_film" size="50"><br>
Film Date: <input type="text" name="frm_date" size="10"><br>
Film URL: <input type="text" name="frm_url" size="50"><br>
Film Director: <input type="text" name="frm_director" size="50"><br>
Film Writer: <input type="text" name="frm_writer" size="50"><br>
Film Plot: <textarea cols=5 rows=5 name="frm_plot"></textarea><br>
Film Poster: <input type="file" name="frm_poster" size="50"><br>
<input type="submit" name="submit" value="submit">
</form>
<?
}
?>
