Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You want to reload the IMG source upon change. So what you need to do is to replace the <code>SRC=</code> value of the IMG tag, by adding a dummy query to avoid caching:</p> <pre><code>jQuery('#save_image').click(function(){ var image_name = jQuery('#hidden_image_name').val(); jQuery.ajax({ url:'text_image.php', data:'file='+image_name, type:'get', success:function(data){ jQuery('#image').attr('src', jQuery('#image') .attr('src')+'?'+Math.random()); } }); }); </code></pre> <p>The PHP script needs output nothing, just rewrite the image file</p> <pre><code>&lt;?php $file = 'upload_pic/'.$_GET['file']; $im = writeToImage($file, 'PHPRO rules again'); imageJPEG($im, $file, 95); // 95% quality die(); ... ?&gt; </code></pre> <p>You may want to output a JSON stating 'success' or 'failure', though, just in case.</p> <p>You also want to check that <code>$_GET['file']</code> is a valid, accessible, allowed, image. For example you might force the file to be a basename:</p> <pre><code> $file = 'upload_pic/'.basename($_GET['file']); if (!file_exists($file)) // ...no such file... if (false === getImageSize($file)) // ...doesn't look like an image... // etc. </code></pre> <h1>Another way</h1> <p>If you want to keep both original and 'captioned' image, you need to <a href="https://stackoverflow.com/questions/9648882/generating-unique-filename">create a new file</a>, and therefore output the new name so that jQuery can replace the SRC attribute.</p> <p>For example:</p> <pre><code> $new = 'upload_pic/'.uniqid().'.jpg'; ...create the file and put $im into it, as above... Header('Content-Type: application/json;charset=utf8'); die(json_serialize(array("src" =&gt; $new))); // Or if you don't want json_serialize (BUT THEN $new may only contain printable ASCII-7 characters that need no escaping. "[a-z][0-9]-_." if you want to be sure). die("{\"src\":\"{$new}\"}"); </code></pre> <p>in jQuery, <code>data</code> will now contain <code>$new</code>, so:</p> <pre><code> success:function(data){ jQuery('#image').attr('src', data.src); } </code></pre> <p>(in the page, you may need to update other fields if you want to re-caption an already-captioned image).</p>
    singulars
    1. This table or related slice is empty.
    1. POget <img> tag from @imagecreatefromjpeg?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USLSerni
    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. COI am using your first way but it is not working
      singulars
      1. PO
      1. USCuteBabyMannu
    2. COWhat happens if you invoke the PHP script from the browser (i.e. not through AJAX) with the same `file=` parameter value? That should give some hint on what's going wrong.
      singulars
      1. PO
      1. USLSerni
    3. CO@iserni First way is working fine ... :) thanks for it but I want to kepp both the files original and new so I am using second way but in second way new image is creating but this image is coming blank. I just change this code in **text_image.php** `$unique_id = rand(); $file = 'upload_pic/'.$unique_id.$_GET['file'];` and in main file this code `jQuery('#image').attr('src', data);`
      singulars
      1. PO
      1. USCuteBabyMannu
 

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