mysql query insert id problem

Question

4.00/5 (1 vote)

See more:

I have a little problem. I found a picture upload script and edited it. But mysql query_insert_id() is not work.

main_db have 5 table.

a - b - Jant - d - e

i need table Jant's last id. How can make it ?

XML

<?php


 ini_set("memory_limit", "200000000"); // for large images so that we do not get "Allowed memory exhausted"?>
<?php
// upload the file
if ((isset($_POST["submitted_form"])) && ($_POST["submitted_form"] == "image_upload_form")) {

    // file needs to be jpg,gif,bmp,x-png and 4 MB max
    if (($_FILES["image_upload_box"]["type"] == "image/jpeg" || $_FILES["image_upload_box"]["type"] == "image/pjpeg" || $_FILES["image_upload_box"]["type"] == "image/gif" || $_FILES["image_upload_box"]["type"] == "image/x-png") && ($_FILES["image_upload_box"]["size"] < 4000000))
    {


        // some settings
        $max_upload_width = 4000;
        $max_upload_height = 3000;

        // if user chosed properly then scale down the image according to user preferances
        if(isset($_REQUEST['max_width_box']) and $_REQUEST['max_width_box']!='' and $_REQUEST['max_width_box']<=$max_upload_width){
            $max_upload_width = $_REQUEST['max_width_box'];
        }
        if(isset($_REQUEST['max_height_box']) and $_REQUEST['max_height_box']!='' and $_REQUEST['max_height_box']<=$max_upload_height){
            $max_upload_height = $_REQUEST['max_height_box'];
        }


        // if uploaded image was JPG/JPEG
        if($_FILES["image_upload_box"]["type"] == "image/jpeg" || $_FILES["image_upload_box"]["type"] == "image/pjpeg"){
            $image_source = imagecreatefromjpeg($_FILES["image_upload_box"]["tmp_name"]);
        }
        // if uploaded image was GIF
        if($_FILES["image_upload_box"]["type"] == "image/gif"){
            $image_source = imagecreatefromgif($_FILES["image_upload_box"]["tmp_name"]);
        }
        // BMP doesn't seem to be supported so remove it form above image type test (reject bmps)
        // if uploaded image was BMP
        if($_FILES["image_upload_box"]["type"] == "image/bmp"){
            $image_source = imagecreatefromwbmp($_FILES["image_upload_box"]["tmp_name"]);
        }
        // if uploaded image was PNG
        if($_FILES["image_upload_box"]["type"] == "image/x-png"){
            $image_source = imagecreatefrompng($_FILES["image_upload_box"]["tmp_name"]);
        }


        $deger=rand(10000,99999);
$remote_file = "image_files/".$deger.$_FILES["image_upload_box"]["name"];


        imagejpeg($image_source,$remote_file,100);
        chmod($remote_file,0644);



        // get width and height of original image
        list($image_width, $image_height) = getimagesize($remote_file);

        if($image_width>$max_upload_width || $image_height >$max_upload_height){
            $proportions = $image_width/$image_height;

            if($image_width>$image_height){
                $new_width = $max_upload_width;
                $new_height = round($max_upload_width/$proportions);
            }
            else{
                $new_height = $max_upload_height;
                $new_width = round($max_upload_height*$proportions);
            }


            $new_image = imagecreatetruecolor($new_width , $new_height);
            $image_source = imagecreatefromjpeg($remote_file);

            imagecopyresampled($new_image, $image_source, 0, 0, 0, 0, $new_width, $new_height, $image_width, $image_height);
            imagejpeg($new_image,$remote_file,100);

            imagedestroy($new_image);
        }

        imagedestroy($image_source);


        header("Location: submit.php?upload_message=image uploaded&upload_message_type=success&show_image=".$deger.$_FILES["image_upload_box"]["name"]);
        exit;
    }
    else{
        header("Location: submit.php?upload_message=make sure the file is jpg, gif or png and that is smaller than 4MB&upload_message_type=error");
        exit;
    }
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Image Upload with resize</title>
<style type="text/css">
<!--
body,td,th {
    font-family: Arial, Helvetica, sans-serif;
    color: #333333;
    font-size: 12px;
}

.upload_message_success {
    padding:4px;
    background-color:#009900;
    border:1px solid #006600;
    color:#FFFFFF;
    margin-top:10px;
    margin-bottom:10px;
}

.upload_message_error {
    padding:4px;
    background-color:#CE0000;
    border:1px solid #990000;
    color:#FFFFFF;
    margin-top:10px;
    margin-bottom:10px;
}

-->
</style></head>

<body>

<h1 style="margin-bottom: 0px">Resim ekleme</h1>


        <?php if(isset($_REQUEST['upload_message'])){?>
            <div class="upload_message_<?php echo $_REQUEST['upload_message_type'];?>">
            <?php echo htmlentities($_REQUEST['upload_message']);?>
            </div>
        <?php }?>


<form action="submit.php" method="post" enctype="multipart/form-data" name="image_upload_form" id="image_upload_form" style="margin-bottom:0px;">
<label>Image file, maximum 4MB. it can be jpg, gif,  png:</label><br />
          <input name="image_upload_box" type="file" id="image_upload_box" size="40" />
          <input type="submit" name="submit" value="Upload image" />

     <br />
    <br />
<br />
      <input name="max_width_box" type="text" id="max_width_box" value="130" size="4">
      x

      <input name="max_height_box" type="text" id="max_height_box" value="130" size="4">
      px.
       // Bu kısmı gerekmediği sürece 130 x 130 olarak bırakınız !<br />
  <br />
<input name="submitted_form" type="hidden" id="submitted_form" value="image_upload_form" />
          </form>




<?php if(isset($_REQUEST['show_image']) and $_REQUEST['show_image']!=''){?>
<p>
    <img src="image_files/<?php echo $_REQUEST['show_image'];?>" />
</p>
<?php }

 echo $_REQUEST['show_image'];

mysql_connect('localhost','admin','password');
mysql_select_db('main_db');



$sql = mysql_query("SHOW TABLE STATUS LIKE 'Jant'");

echo mysql_query_insert_id();

?>




</body>
</html>

Posted 5-Jun-11 6:06am

kozmikadam

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kim Togo · Accepted Answer · 2011-06-05T07:24:00

Solution 1

mysql_insert_id[^] only works with INSERT statement and auto inc on table column.

And the only SQL statement is SHOW TABLE.

Posted 5-Jun-11 7:24am

Kim Togo

Updated 5-Jun-11 8:43am

v2

Comments

kozmikadam 5-Jun-11 14:49pm

i understand. But i need last id.How can i find it ?

Kim Togo 6-Jun-11 3:10am

You can do a "SELECT MAX(id) FROM tbl", this way MySql will find the maximum value in the table "tbl"

kozmikadam 6-Jun-11 6:27am

$last_id = mysql_query("SELECT MAX(ID) FROM Jant"
echo $last_id

always return me "Resource id #3"

Kim Togo 6-Jun-11 6:28am

Can you please describe the table "Jant" ?

Kim Togo 6-Jun-11 6:48am

You are accessing the result incorrect.
Check this link
http://www.w3schools.com/php/func_mysql_fetch_array.asp

kozmikadam 6-Jun-11 7:14am

$sql = mysql_query("SELECT * from Jant ORDER BY ID DESC LIMIT 1;");

$goster=mysql_fetch_array($sql);
echo $goster['ID'];

Problem solved ! Thanks for your help.

Kim Togo 6-Jun-11 7:17am

You are welcome :-)
Please use "Accept Answer" and vote the solution. This will help other CP members to find answers to problems.

kozmikadam 6-Jun-11 6:32am

Table Jant :

ID - Name - type - marka