Aim Ene @ROBERT25

نقاط السمعة 2
تاريخ التسجيل 05/09/2018
آخر تواجد أكثر من سنة
  • PHP

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

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

  • 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"

    }

});
<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

شكرا لك

  • PHP

ارجو ان ان توضح اكثر اخي

  • PHP

شكرا لك اخي لقد نفذ الكود....

لكن سؤال بسيط : $use->sql( 'Add Username Here', 'Add Password Here' );

هل اتركه هكذا : add username here..

  • PHP

Notice: Undefined index: username in C:\Program Files (x86)\EasyPHP-Devserver-17\eds-www\control2.php on line 13

Notice: Undefined index: password in C:\Program Files (x86)\EasyPHP-Devserver-17\eds-www\control2.php on line 14

Notice: Undefined variable: connect in C:\Program Files (x86)\EasyPHP-Devserver-17\eds-www\control2.php on line 17

Warning: mysqli_query() expects parameter 1 to be mysqli, string given in C:\Program Files (x86)\EasyPHP-Devserver-17\eds-www\control2.php on line 17

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in C:\Program Files (x86)\EasyPHP-Devserver-17\eds-www\control2.php on line 18

password or username it not true, please enter the right input...