function numDisplay($num){ if ($num >= 11 && $num <= 20){ $str = 10+ ; }else if ($num >= 21 && $num <= 30){ $str = 20+ ; } return $str; } this kind of manual addition seems to be too muc...
$product_data = $mysqli->query( "SELECT p.url as url, p.description as description, p.info as info, p.note as note, p.content as content, p.name as pname, p.icon as ico...
encountered a problem today $sql = $mysqli->query( "SELECT .... " ); I have a query that I want to apply to two while, but only the first one has a response <? while ($row = mysqli_fetch_array($sql)){ ?> ...
$mail= new PHPMailer(); $mail->IsSMTP(); $mail->SMTPAuth = true; $mail->SMTPSecure = "ssl"; $mail->Host = "smtp.gmail.com"; $mail->Port = 465; $mail->CharSet = "utf8"; $mail->...
check I can t even find the method on the website how to start AUTO_INCREMENT from 0 via php mysql lookup? not in this way: CREATE TABLE `admin` ( `x` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; is the way to ...
this is the resource I found http: jsfiddle.net qF7Ff what I m doing now is to use js s filereader to generate every base64 address , each predicted to be an input name=icon [] , and then to download each video , so it will be < input name= "ico...
my question is a bit complicated the orange line is a while color line is also a while film, you can see that it has been duplicated (I use distinct, you can see that there is a problem) on the right side of the shopping list is to show the name...
$product_name = $pdo->query( "SELECT * FROM `stock` as s JOIN `product` as p ON p.prod_id = s.prod_id WHERE s.order_id = {$first_order[ order_id ]} " ); $productNameArray = null; while ($row = mysqli...
$(document).ready(function() { product_online(<?=$prodIdForOnline;?>, <?=$urlForOnline;?> ); product_update_online(<?=$prodIdForOnline;?>, <?=$urlForOnline;?> ); }); function product_online(id, url){ $( -sh...
online time() online 20 id 2 s online_status deduction time () has been higher than 30, but id 1 does not have it, but it is still found out? ...
I can use $_ SERVER [ HTTP_HOST ] to know the current web address and also $_ SERVER [ PHP_SELF ] to know which file I am loading now for example, when I am in index.php , he will show index.php if I am in admin index.php , he will show ...
Let me first review my uploading practice ~ the way to upload multiple merchandise videos is use onchange to confirm input file <input multiple type="file" id="file1" name="icons[]" class="" accept="im...
I have set two bits one is start and the other is end format is datepicker of jquery, so it will be 2018-01-01 format but now I want to make a comparison I am using the concept of an e-commerce coupon , so I need to enter the discount code so che...
$public_prod_id = C .rand(1000000000,9999999999); $_SESSION[ public_prod_id ] = $public_prod_id; $exist = mysqli_num_rows($pdo->query( "SELECT * FROM `product` WHERE `public_prod_id` = {$_SESSION[ public_prod_id ]} &q...
while ($row = mysqli_fetch_array($aa)){ $public_order_id = date( Ymd , time()).rand(1,999999); because there will be more than one br in an instant. my current idiotic approach is to use rand. , but 1999999 still has a chance to reproduce, bec...
$subtotal = $pdo->query( "SELECT s.quan as quan, s.price as price, p.store_id as store_id FROM `stock` as s JOIN product as p ON s.prod_id = p.prod_id " ); while ($row_ = mysqli_fetch_array($sub...
I have a problem now join store product product store_id product store_id The check box is store_id , but I found that even if it is the same store_id, it will print out . What I want to achieve is that just show a store_id, and as long as t...
$.ajax({ type: "GET", url: "url.php", success: function(data){ } suppose I use this to play if I print out console.log (data), I can print my echo in url.php, but if I need to receive more than two respons...
I can use $data- > { msg } to print the value of the first item, such as msg , but if I want to print the second letter, how do I write it? For example, I want to print the bin_code of card_info . { "status": 0, "msg": &quo...
SELECT * FROM `user_cart` as c JOIN `product` AS b ON c.prod_id = b.prod_id WHERE c.id = {$_SESSION["user-id"]} I have a value in product called from, which is either an or b , but what is shown now is ...