Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>An alternative solution if you do not have exec privileges is to use curl to grab the image, or you could use <code>file_get_contents()</code>, there are many ways, its just personal preference.</p> <p>Ive put together what your script may look like, im sure you can improve it.</p> <p><strong>insert.php</strong></p> <pre><code>&lt;?php if(isset($_POST['image']) &amp;&amp; isset($_POST['title'])){ if(substr($_POST['image'],0,4)=='http'){ $image = curlgetimage($_POST['image']); $info = pathinfo($_POST['image']); if(isset($info['extension']) &amp;&amp; ($info['extension']=='gif' || $info['extension']=='png' || $info['extension']=='jpg')){ $path='./temp/'.md5($_POST['image']).'.'.$info['extension']; file_put_contents($path,$image); if(ftp_put_image($path)===true){ //Do your database stuff, remember to escape.. unlink($path); echo 'Success'; }else{ echo 'ftp-fail'; } }else{ echo'File type not allowed'; } }else{ echo'Must start with http://'; } }else{ header('Location: http://www.example.com/'); } function ftp_put_image($file){ if(!file_exists($file)){return false;} $fp = fopen($file, 'r'); $conn_id = ftp_connect('ftp.yourhost.com'); //change $login_result = ftp_login($conn_id,'username','password'); //change $return=(ftp_fput($conn_id, $file, $fp, FTP_BINARY))?true:false; ftp_close($conn_id); fclose($fp); return $return; } function curlgetimage($url) { $header[] = 'Accept: image/gif, image/x-bitmap, image/jpeg, image/pjpeg'; $header[] = 'Connection: Keep-Alive'; $header[] = 'Content-type: application/x-www-form-urlencoded;charset=UTF-8'; $curl = curl_init($url); curl_setopt($curl, CURLOPT_URL, $url); curl_setopt($curl, CURLOPT_USERAGENT, 'YourSpiderBot/0.01 (Bla Bla Robot; http://www.example.com; spider@example.com)'); //change curl_setopt($curl, CURLOPT_HTTPHEADER, $header); curl_setopt($curl, CURLOPT_HEADER, 0); curl_setopt($curl, CURLOPT_REFERER, $url); curl_setopt($curl, CURLOPT_ENCODING, 'gzip,deflate'); curl_setopt($curl, CURLOPT_AUTOREFERER, true); curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); curl_setopt($curl, CURLOPT_TIMEOUT, 60); $return = curl_exec($curl); curl_close($curl); return $return; } ?&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. PODownload a File and Upload it with PHP and AJAX
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USLawrence Cherone
    1. USLawrence Cherone
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COWhat should I put on the curl_setopt($curl, CURLOPT_USERAGENT, 'YourSpiderBot/0.01 (Bla Bla Robot; http://www.example.com; spider@example.com)'); ? Anything that uses my domain or do I have to use specific values?
      singulars
      1. PO
      1. USrlc
    2. COThe file is never being downloaded... So i am getting the FTP error file does not exist. I don't know if it is not being downloaded by curlgetimage($url) or it is not being put by file_put_contents($path,$image)
      singulars
      1. PO
      1. USrlc
    3. CO@rlc First off you can put anything as the useragent, its polite to show yourself as a scrapper/bot but you could also masquerade as a normal browser. I did test this script with a form instead of the ` header('Location: http://www.example.com/');` maybe your form/jquery is the prob not sure, also check you have curl enabled on your server, I know xammp is not enabled by default(just need to uncomment a line) but 99% of webhosts are enabled.
      singulars
      1. PO
      1. USLawrence Cherone
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload