how to convert mysql to mysqli query

[shashigowda]

Hii..this is mysql query

$querry="SELECT CONCAT(`insert_id`, `type`) AS 'order_id' FROM orders WHERE email='$email'";
$order_id=mysql_query($querry);
    echo $order_id;

i need to convert this into ** mysqli**.
Any Help??

[shashigowda]

there??

[cereal]

Hi, use prepared statements, start from here:

• http://php.net/manual/en/mysqli.prepare.php
• http://php.net/manual/en/mysqli.quickstart.prepared-statements.php

Look at the first example in the first link, I'm not converting the code directly for you, because it's more important that you understand how it works and how the methods/functions are used.

[shashigowda]

Thank you #Cereal