mysql - Storing images to directory using php -

-

i'm creating admin side website.

i have created add page , within page form few fields. 2 of these upload button me upload image. , other 1 fill box me enter url.

i have set both of them update same mysql field , fill box priority when both entered.

however. search box fine saves link correctly selecting image using select box saves file name in field in mysql example: xxxxxxxxxxxxx.png

so my website displaying these images, not display uploaded ones. because these saved on computer , not on cpanel.

so question is: how can upload image using upload box , have save /images folder have mysql display url link in relevant field?

my add.php code this:

<?php  session_start();  include_once('../include/connection.php');  if (isset($_session['logged_in'])){   if (isset($_post['title'], $_post['content'])) {         $title   = $_post['title'];         $content = nl2br($_post['content']);         if (!empty($_post['image']))         {             $image = $_post['image'];         }         else         {             $image = $_post['imageupload'];              if (isset($_files['filedata']))             {                 $filename   = $_files['filedata']['name'];                 $targetpath = "/images/" . $filename; //target directory relative script location                  $copy = copy($_files['filedata']['tmp_name'], $targetpath);                  if (!$copy)                     $error = "image not uploaded successfully";             }         }         $link     = $_post['link'];         $category = $_post['category'];         $brand    = $_post['brand'];   if (empty($title) or empty($content)) {          $error = 'all fields required!'; }else{  $query = $pdo->prepare('insert mobi (promo_title, promo_content, promo_image, promo_link, promo_cat, promo_name) values(?, ?, ?, ?, ?, ?)');  $query->bindvalue(1, $title);  $query->bindvalue(2, $content);  $query->bindvalue(3, $image);  $query->bindvalue(4, $link);  $query->bindvalue(5, $category);  $query->bindvalue(6, $brand);         $query->execute();     header('location: index.php'); }  }           ?>     <?php  if (isset($_files['filedata'])) { // , if ok     if ($_files['filedata']['error'] !== upload_err_ok)     exit('upload failed. error code: ' . $_files['image']['error']);      $filename = $_files['filedata']['name'];     $targetpath    = "../img/news/" . $filename; //target directory relative script location      $copy = copy($_files['filedata']['tmp_name'], $targetpath); } ?>  <html> <head> <title>add article</title> <link rel="stylesheet" href="../other.css" /> </head>  <body> <div class="container"> <a href="index.php" id="logo"><b>&larr; back</b></a>  <br />  <div align="center"> <h4>add article</h4>  <?php if (isset($error)) { ?>      <small style="color:#aa0000;"><?php echo $error; ?></small><br /><br /> <?php } ?>  <form action="add.php" method="post" autocomplete="off">  <input type="text" name="title" placeholder="title" /><br /><br /> <textarea rows="15" cols="50" placeholder="content" name="content"></textarea><br /><br /> <input name="imageupload" type="file" id="image" placeholder="imageupload" /> <input type="text" name="image" placeholder="image" /><br /><br /> <input type="link" name="link" placeholder="link" /><br /><br /> <input type="category" name="category" placeholder="category" /><br /><br /> <input type="category" name="brand" placeholder="brand" /><br /><br /> <input type="submit" value="add article" />  </form> </div> </div> </body> </html>   <?php }else{        header('location: index.php'); }  ?>

please help. thanks.

try having @ manual uploading files.


Comments

Post a Comment

Popular posts from this blog

wordpress - (T_ENDFOREACH) php error -

-
creating wordpress website , i'm getting following php error: parse error: syntax error, unexpected 'endforeach' (t_endforeach) in /home/soralmedia/public_html/wp-content/themes/soral media/woocommerce/myaccount/my-orders.php on line 98 here's code file: <?php /** * orders * * shows recent orders on account page. * * template can overridden copying yourtheme/woocommerce/myaccount/my-orders.php. * * however, on occasion woocommerce need update template files , (the theme developer). * need copy new files theme maintain compatibility. try this. * little possible, happen. when occurs version of template file will. * bumped , readme list important changes. * * @see http://docs.woothemes.com/document/template-structure/ * @author woothemes * @package woocommerce/templates * @version 2.5.0 */ if ( ! defined( 'abspath' ) ) { exit; } $my_orders_columns = apply_filters( 'woocommerce_my_account_my_orders_columns', array( ...
Read more

Export Excel workseet into txt file using vba - (text and numbers with formulas) -

-
i new vba have developed code use in excel move text/numbers txt file. issue have 3 functions need go same txt file. when run first function has set fs = createobject("scripting.filesystemobject") set = fs.createtextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the other 2 functions had save. set fs = createobject("scripting.filesystemobject") set = fs.savetextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the first function go txt file, other 2 error object doesn't support property or method. when changed 3 create last function goes txt file. can not figure out word use in order make other 2 functions follow txt file in order keyed. the entire code follows private sub addrecord_click() on error goto errhandler module1.nys45uploadfilename = application.getsaveasfilename(filefilter:="textfiles (*.txt), *.txt") if module1.nys45uploadfilename = "false" exit sub ...
Read more

Using django-mptt to get only the categories that have items -

-
sample structure: all uppercase: category mixed case: item root ├── books │   ├── fiction │   │   └── classics │   └── non-fiction ├── clothing └── electronics ├── laptops ├── phones │   ├── apple │   │   ├── iphone 6 │   │   ├── iphone 6 plus │   │   ├── iphone 6s │   │   └── iphone 6s plus │   ├── motorola │   │   ├── moto g4 │   │   ├── moto g4 play │   │   ├── moto g4 plus │   │   └── moto x │   └── samsung └── tablets └── apple i'm trying have index page show "electronics" category. "clothing" category shouldn't show since it's empty , "books" category shouldn't show either since, although has child categories, child categories don't have items. similarly, "electronics" page should show "phones" category. "laptops" category shouldn't show since it's empty , "tablets" category shouldn't show either since...
Read more