Save canvas image to sql database with php

Question

I'am sorry if this question is stupid , but how I can save canvas image to database via php I've searched a lot but did not found anything working and useful
and here is the code that I use it just popup print form

  <script>
   function print(){
    var canvas1 = document.getElementById("testCanvas");
    var ctx1 = canvas1.getContext("2d");
    var img = canvas1.toDataURL("image/png");
    img = encodeURIComponent(img);

    $.ajax({
        url: 'upload.php',
        data: { data: img },
                type: 'post',
                success: function(data) {
                    console.log(data);
                    alert("Done");
                }
    });
    </script>
    <button onclick="print()">Click me</button><br>

Upload.php

<?php

    $data = $_POST['data'];

    $server = "localhost";
    $username = "root";
    $password = "";
    $database = "sports";
    $bd = mysql_connect($server, $username, $password) or die("1");
    $ok = mysql_select_db($database, $bd) or die("2");

     $sql = "INSERT INTO image (myimage) VALUES ($data)";
    if( ! mysql_query($sql) )
   {
       echo "Error: " . mysql_error();
   }

    echo $qry;

?>

`I've searched a lot but did not found anything` First hit on google...http://stackoverflow.com/questions/13198131/how-to-save-a-html5-canvas-as-image-on-a-server — Rick S, Jun 02 '15 at 18:31
Then I suggest you post your code that didn't work and see if you can get some help. — Rick S, Jun 02 '15 at 18:33

score 0 · Answer 1 · edited May 23 '17 at 12:21

0

You can, using AJAX. The process will be :

Javascript handle the canvas to create the image
Javascript call a url generated by your PHP
Your PHP handle the date send via POST method by the Javascript

Here is an answer that can help you : uploading canvas context as image using ajax and php

edited May 23 '17 at 12:21

Community

1
1

answered Jun 02 '15 at 18:33

Ivan Gabriele

6,433
5
39
60

Save canvas image to sql database with php

1 Answers1