U mean to say instead of every MySQL i have to write mysqli?

php script with cron job.

php script will check for remainder logic when to trigger.

and cron job will make sure that this script runs in background at defined intervals.

is this resolved or need help dear??

Tq sir … I try now

Abhishek Garg:
Hey I just wanted to ask one question!

How much is the approximate revenue AdSense gives?

Like minimum to minimum

For around 1000 views

Which are really interactive and spend 15-20 mins average on website

<?php
$con=new mysqli(‘localhost’,’root’,”,’video_upload’) or die(‘mysqli_error($con)’);
$query=”SELECT * FROM videos”;
echo $query;
$res=mysql_query($query,$con);

?>

wrong query dear.

it wont work.

yeah

dm me.i will help u as well u understand this thing.

my doubt is that echo $querry; wil only print a string?

dm me.i will help u. as well make u understand this thing.

thats not a issue admin. i dont want to clutter dats y.

ipsita ur using two things mysqli as well as mysql

thats the main issue.

in res

use mysqli_query.

also in mysqli con comes first

like mysqli_query($con, $query);

try this once

to fetch reault

result* you need to use
mysqli_fetch_object(); for data in object form

I thought mysqli use for db connection. And Mysql_ query () function is different

mysql is deprecated.

let me know if further help required.

U mean to say instead of every MySQL i have to write mysqli?

exactly.

you have to use mysqli

Ok thank you

Sure

Bro i had issues so I shared the code.

Next time . I ll search in w3 school for sure

Can any one help me?

I have some problems in laravel

anyone here who is having experince in magento ?

Yes

Mysql is vulnerable to sql injection

Can anybody tell me how to show multiple products ordered by customer according to user ID of customer in php

Yes I can

OK how to do it

You need to create a order table and insert all the order details with user id in this table.

Done kar diya

Fir kya karna hai

And then run select query with where clause like “SELECT * FROM orders WHERE user_id = id”

To get all the orders of the particular user.

Woh bhi kar diya

There are three tables
1. Orders table hai usme uid, oid and rest details
2. Second table ordered product hai usme uid, oid, pid hai
3. Product table hai usme pid hai
Now I want products ordered by customer from product table

Join all 3 tables using JOIN

How

It’s long query let me build that query then I’ll send you

OK