1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / wisdomvibes /
Filename : reviews.php
back
<?php

exit;
$hostname = "localhost"; 
$username = "root"; 
$password = "rp;U4q1voE"; 
$database = "eltorofashions"; 

$mysqli = new mysqli("localhost","root","rp;U4q1voE","eltorofashions");

$sql = "select * from oc_product where status = 1 order by product_id asc";
$result = $mysqli -> query($sql);


while($row = $result->fetch_assoc()){

    $count = rand(5,6);
    for($i = 1; $i <= $count; $i++){

        $int= mt_rand(1617942773,1628483573);
        $date = date("Y-m-d H:i:s",$int);

        $reviewrand = rand(1,51);
        if (strpos(strtolower($row['model']), 't-shirt') !== false) {
            $sql = "select * from reviews where id = $reviewrand and text not like '% shirt%'";
        }else{
            $sql = "select * from reviews where id = $reviewrand and (text not like '%t-shirt%' or text not like '%tshirt%')";
        }    
        
        $reviews = $mysqli -> query($sql);
        $review = $reviews->fetch_assoc();


        $userrand = rand(1,297);
        $sql = "select * from reviews_name where id = $userrand";
        $customers = $mysqli -> query($sql);
        $customer = $customers->fetch_assoc();


        $product_id = $row['product_id'];

        $rating = rand(4,5);

        
        $sql = "insert into oc_review(`product_id`,`customer_id`,`author`,`text`,`rating`,`status`,`date_added`,`date_modified`) values($product_id, 0, '".$customer['name']."', '".$review['text']."', $rating, 1, '$date', '$date')";

        echo $sql;
        $mysqli -> query($sql);
        echo "<br>";

    }

    $count = rand(3,4);
    for($i = 1; $i <= $count; $i++){

        $int= mt_rand(1617942773,1628483573);
        $date = date("Y-m-d H:i:s",$int);


        $userrand = rand(1,297);
        $sql = "select * from reviews_name where id = $userrand";
        $customers = $mysqli -> query($sql);
        $customer = $customers->fetch_assoc();


        $product_id = $row['product_id'];

        $rating = rand(4,5);

        
        $sql = "insert into oc_review(`product_id`,`customer_id`,`author`,`text`,`rating`,`status`,`date_added`,`date_modified`) values($product_id, 0, '".$customer['name']."', 'Good', $rating, 1, '$date', '$date')";

        echo $sql;
        $mysqli -> query($sql);
        echo "<br>";

    }


}