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??

Recommended Answers

All 3 Replies

Re: how to convert mysql to mysqli query 80 80

there??

Re: how to convert mysql to mysqli query 80 80

Hi, use prepared statements, start from here:

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.

Re: how to convert mysql to mysqli query 80 80

Thank you #Cereal

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.