البيانات لا تدخل الى database

  • ROBERT25

عندما اضغط على submit تظهر هذه الرسالة : no file up,try again the file is not image,try again

insert the articles.php:

<!DOCTYPE html>

<img src="insert the articles2.php$id=<?=$imageid;?>" />
<script type="text/javascript" src="tiny/tiny_mce.js"></script>

<?php date_default_timezone_set('africa/algiers'); if(isset($_POST['submit']) && !empty($_FILES)){

$formok=TRUE;


$title=$_POST['title'];
$thread=$_POST['elm1'];
$date=date("d/m/y h:i:s");

$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 "no file up,try again"; } if(!in_array($type,array('image/JPG','image/Exif','image/JPEG','image/GIF','image/TIFF','image/BMP','image/PNG','image/PPM','image/PGM','image/PBM','image/PNM','image/webP','image/HDR','image/HEIF','image/BAT','image/BPG','image/CGM','image/SVG'))){ $formok=FALSE; echo "the file is not image,try again"; } if(filesize($path)>8000000){ $formok=FALSE; echo "the file isbig,try again"; }

if($formok){ if($connect=mysqli_connect('localhost','root','','php')){ $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 title(topic,date) VALUES('$safethread','$date')";
    $sqlimage="INSERT INTO title(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);

         echo "the insert has done"; 


    }

else {echo "there is an errors in DB";}

}

}

?> <!-- TinyMCE -->

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 : "save,newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,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"
    }
});

TITLE: ENTER THE TOPIC:

يرجى الدخول لحسابك أو تسجيل حساب لتستطيع إضافة تعليق
حساب جديد دخول

التعليقات

مجهول
  • حذف بواسطة المستخدم

<!DOCTYPE html>

<img src="insert the articles2.php$id=<?=$imageid;?>" />

<script type="text/javascript" src="tiny/tiny_mce.js"></script>

<?php

date_default_timezone_set('africa/algiers');

if(isset($_POST['submit']) && !empty($_FILES)){

$formok=TRUE;





$title=$_POST['title'];

$thread=$_POST['elm1'];

$date=date("d/m/y h:i:s");



$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 "no file up,try again";

}

if(!in_array($type,array('image/JPG','image/Exif','image/JPEG','image/GIF','image/TIFF','image/BMP','image/PNG','image/PPM','image/PGM','image/PBM','image/PNM','image/webP','image/HDR','image/HEIF','image/BAT','image/BPG','image/CGM','image/SVG'))){

$formok=FALSE;

echo "the file is not image,try again";

}

if(filesize($path)>8000000){

$formok=FALSE;

echo "the file isbig,try again";

}

if($formok){

if($connect=mysqli_connect('localhost','root','','php')){

    $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 title(topic,date) VALUES('$safethread','$date')";

    $sqlimage="INSERT INTO title(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);



         echo "the insert has done"; 





    }

else {echo "there is an errors in DB";}

}

}

?>

<!-- TinyMCE -->

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 : "save,newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,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"

    }

});
<form action="insert the articles.php"  method="post" enctype="multipart/form-data">

    TITLE:<br><br> <input type="text" name="title" />

    <div>ENTER THE TOPIC:<br><br> <textarea id="elm1" name="elm1" rows="15" cols="80" style="width: 80%"></textarea></div>

    <input type="hidden" name="MAX_FILE_SIZE" name="800000" />

    <input type="file" name="upload">

    <input type="submit" name="submit" />

</form>

الكود غير واضح ولو ارسلته كملف php افضل

لكن عندك خطأ في الفورم

<form action="insert the articles.php"

اعتقد اسم الصفحة articles.php

اكتبها هكذا وامسح ماقبلها

form action="articles.php"

لا .اسم الصفحة insert the articles .php

و لكن لم اجد من اين اضيف ملف. لو عندك حساب شخصي و تستطيع ان تعطيه لي سارسله لك .وشكرا اك

قم بوضع الملفات في ملف مضغوط وارفعها على احد مواقع الرفع او التخزين السحابي مثل Google drive

حتى يكون الكود غير واضح هنا ولا يمكن قرائته بشكل صحيح