Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Selecting the latest entry in a single MYSQL column and assigning it to a php variable

I have a 4 column mysql table, the leftmost being the autoincrement column and I’d like to get the variable value for a column called extra for the highest auto increment value. I believe the SQL query will be:

Select extra FROM motoron2 ORDER BY id DESC LIMIT 1"

    $conn = new mysqli('localhost', 'myuser', 'mypass', 'mydb');    
    if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
    }
    $sql = "SELECT extra FROM motoron2 ORDER BY id DESC LIMIT 1";
    $stmt = $conn->prepare($sql); 
    $stmt->execute();
    $result = $stmt->get_result(); // get the mysqli result
    $variablevalue = $result->fetch_assoc(); // fetch the data 
    echo "The variable is converted to a string and its value is $variablevalue.";
    // set parameters and execute

When try to echo "The variable is converted to a string and its value is $variablevalue." I see: The variable is converted to a string and its value is Array I am expecting to see an integer here, what am I doing wrong?

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

>Solution :

The fetch_assoc() function returns an associative array so you would access the value by the name of the column:

$variablevalue['extra'];

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading