أخواني الكرام
عند كتابة هذا الكود وهو ارسال نص وصورة إلى قاعدة البيانات يعطي خطأ ولا أعلم ما هو الخطأ مع العلم أن كافة المعلومات صحيحة
<html>
<head>
<body>
<?php
if($_POST['submit'] & !empty($_FILES)){
$formok=TRUE;
//inputs var
$title=$_POST['title'];
$thread=$_POST['e1m1'];
$date=date("d/m/y h:i:s");
//file vars
$path=$_FILES['upload']['tmp_name'];
$name=$_FILES['upload']['name'];
$size=$_FILES['upload']['size'];
$type=$_FILES['upload']['type'];
$error=$_FILES['upload']['error'];
if(!is_uploaded_file($path)){
$formok=false;
echo"لا يوجد ملف";
}
//check file extention
if(!in_array($type,array('image/png','image/x-png','image/gif','image/jpeg','image/pjeg')));
{
$formok=false;
echo"الملف ليس صورة";
}
if(filesize($path) >800000){
$formok=false;
echo"الملف حجمه كبير";
}
if($formok){
if($connect=mysqli_connect('localhost','root','root','flip')){
$content=file_get_contents($path);
$safetitle=mysqli_real_escape_string($connect,$title);
$safethread=mysqli_real_escape_string($connect,$thread);
$safeimage=mysqli_real_escape_string($connect,$content);
$sqltitle="insert into title(title) values ('$safetitle')";
$sqlthread="insert into threads(topic,date) values ('$safethread','$date')";
$sqlimage="insert into images(name,size,type,content) values ('$name','$size','$type','$safeimage')";
$querytitle=mysqli_query($connect,$sqltitle);
$querythread=mysqli_query($connect,$sqlthread);
$queryimage=mysqli_query($connect,$sqlimage);
if($querytitle && $querythread & $queryimage){
$imageid=mysqli_insert_id($connect);
}
mysqli_close($connect);
}
else{
echo"العملية غير صحيحة";
}
echo"تمّت العملية بنجاح";
}
?>
<script type="text/javascript" src="tiny/tiny_mce.js"></script>
<script type="text/javascript">
tinyMCE.init({
// General options
mode : "textareas",
theme : "advanced",
plugins : "autolink,lists,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,wordcount,advlist,autosave,visualblocks",
// Theme options
theme_advanced_buttons1 : "justifyleft,justifycenter,stifyright,justifyfull,styleselect,formatselect,fontselect,fontsizeselect",
theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,insertdate,inserttime,preview,|,forecolor,backcolor",
theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,print,|,ltr,rtl,|,fullscreen",
theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,pagebreak,restoredraft,visualblocks",
theme_advanced_toolbar_location : "top",
theme_advanced_toolbar_align : "left",
theme_advanced_statusbar_location : "bottom",
theme_advanced_resizing : true,
// Example content CSS (should be your site CSS)
content_css : "css/content.css",
// Drop lists for link/image/media/template dialogs
template_external_list_url : "lists/template_list.js",
external_link_list_url : "lists/link_list.js",
external_image_list_url : "lists/image_list.js",
media_external_list_url : "lists/media_list.js",
// Style formats
style_formats : [
{title : 'Bold text', inline : 'b'},
{title : 'Red text', inline : 'span', styles : {color : '#ff0000'}},
{title : 'Red header', block : 'h1', styles : {color : '#ff0000'}},
{title : 'Example 1', inline : 'span', classes : 'example1'},
{title : 'Example 2', inline : 'span', classes : 'example2'},
{title : 'Table styles'},
{title : 'Table row 1', selector : 'tr', classes : 'tablerow1'}
],
// Replace values for the template plugin
template_replace_values : {
username : "Some User",
staffid : "991234"
}
});
</script>
<form action="<?php echo $PHP_SELF;?>" method="POST" enctype="multipart/form-data" >
<p>
العنوان:
<input type="text" name="العنوان" />
</p>
<div>
<textarea id="e1m1" name="e1m1" rows="15" cols="80" style="width: 80%">
</textarea>
</div>
<p>
<input type="hidden" name="MAX_FILE_SIZE" value="800000" />
<input type="file" name="upload" />
</p>
<p>
<input type="submit" name="submit" value="أرسل" />
</p>
</form>
</body>
</head>
</html>