Djatmiko Ufn

Problem found: product_code on table cart the are not unique number appear but characters value <br /><b> others data are correct. Here is result :
Huawei10 pro
75000 image/huawei_mate10_pro.jpg 1 75000 <br /><b>
Problem has been solved. Thanks a lot of.

Aditya Meena

Sir when I clicked on Add to cart button product does not added to cart or database or cart number I type code 10times as you type in video so sir plz provide source code of tutorial & help your subscriber

Dean Ross

I have watched this video 3 -4 times and went through both action.php and index.php but I can't seem to get it to add to the cart database after clicking add to cart button. this my line of code, as well I am not getting a return message for success or not item has been added. Please get back to me
from Action.php
<?php

require 'config.php';

if(isset($_post['pid'])){

$pid = $_POST['pid'];

$pname = $_POST['pname'];

$pprice = $_POST['pprice'];

$pcode = $_POST['pcode'];

$pqty = $_POST['pqty'];

$pcolour = $_POST['pcolour'];

$pdis = $_POST['pdis'];

$pimage = $_POST['pimage'];

$QTY = 1;

$stmt = $conn->prepare("SELECT Product_Code FROM cart WHERE Product_Code=?");

$stmt->bind_param("s",$pcode);

$stmt->execute();

$res = $stmt->get_result();

$r = $res->fetch_assoc();

$code = $r['Product_Code'];

if(!$code){

$query = $conn->prepare(" INSERT INTO cart (Product_Code,Product_Colour,Product_Name,Product_Price,QTY,Total_Price,Product_Image) VALUES (?,?,?,?,?,?,?)");

$query->bind_param("ssssiss",$pcode,$pcolour,$pname,$pprice,$pqty,$pprice, $pimage);

$query->execute();

echo '<div class="alert alert-success alert-dismissible">

<button type="button" class="close" data-dismiss="alert">&times;</button>

<strong>The selected Item has been added </strong>

</div>';

}

else{

echo '<div class="alert alert-danger alert-dismissible">

<button type="button" class="close" data-dismiss="alert">&times;</button>

<strong>The selected Item has been already added </strong>

</div>';

}

}

?>

from index.php
<div class="container">

<div id="message"></div>

<div class="row mt-2 pb-3">

<?php

include'config.php';

$stmt = $conn->prepare("SELECT * FROM product");

$stmt->execute();

$result = $stmt->get_result();

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

?>

<div class="col-sm-6 col-md-4 col-lg-3 mb-2">

<div>

<font class="SmallB">Product code:</font>

<font class="italic"><?= $row['Product_Code']?></font>

</div>

<div class="card-deck">

<div class="card p-2 border-secondary md-2">

<img src="<?= $row['Product_Image'] ?>" class="card-img-top" height="250px">

<div class="card-body p-1">

<h4 class="card-title text-center text-info"><?= $row['Product_Name']?></h4>

<p class="para">

<?= $row['Product_Description']?>

</p>

<h5 class="card-text text-center text-danger">

PRICE <i class='fas fa-dollar-sign'

style='font-size:15px'></i><?= number_format($row['Product_Price'],2)?>

<BR>

<font class="QTY">

Quanity available is <?= $row['Product_QTY']?> </font>

</h5>

</div>

<div class="card-footer p-1">

<form action="" class="form-submit">

<input type="hidden" class="pid" id="pid" value="<?= $row['ID']?>">

<input type="hidden" class="pname" id="pname" value="<?= $row['Product_Name']?>">

<input type="hidden" class="pprice" value="<?= $row['Product_Price']?>">

<input type="hidden" class="pcode" value="<?= $row['Product_Code']?>">

<input type="hidden" class="qty" value="<?= $row['Product_QTY']?>">

<input type="hidden" class="pcolour" value="<?= $row['Product_Colour']?>">

<input type="hidden" class="pdis" value="<?= $row['Product_Description']?>">

<button class="btn btn-info btn-block addItemBtn"><i class="fas

fa-cart-plus"></i>&nbsp; Add to Cart</button>

</form>

</div>

</div>

</div>

</div>

<?php endwhile; ?>

</div>

</div>

<!– jQuery library –>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script&gt;

<!– Popper JS –>

<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script&gt;

<!– Latest compiled JavaScript –>

<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script&gt;

<script type="text/javascript">

$(document).ready(function(){

$(".addItemBtn").click(function(e){

e.preventDefault();

var $form = $(this).closest(".form-submit");

var pid =$form.find(".pid").val();

var pname =$form.find(".pname").val();

var pprice =$form.find(".pprice").val();

var pcode =$form.find(".pcode").val();

var pqty =$form.find(".pqty").val();

var pcolour =$form.find(".pcolour").val();

$.ajax({

url: 'action.php',

method: 'post',

data: {pid:pid,pname:pname,pprice:pprice,pcode:pcode,pqty:pqty,pcolour:pcolour},

success:function(response){

$("#message").html(response);

}

});

});

});

</script>

</body>

</html>

Low Zhi Lok

can you teach me how to choose the size, price, add to cart, and quantity in PHP code?

Sue Patrick

very well explained.but i will need help, am trying to empty the cart automatically after checkout is done.it seems after checkout the cart is still having previous products in it.

Antonio J. Delgad

I have too some erros, can you give me the source code,it's grateful if you send it to me by my email: antoniojd121@gmail.com Thank you so much.

Learning Redefined

Can we do it only using php ?

Deepu G Nair

thanks bro . it helps me a lot

E Shopper Sri Lanka

After Clicking Add to cart, nothing happens pls help me

φ AQ ecнo ツ

The add to cart is not updating the products to the database. I watched all first 3 videos twice, and checked the syntax.
Do you have the source code for this please?

Plutiik

Hey I contacted you on email and facebook, can you please check it? Thank you so much!

Mihailo Sredovic

I have a question, why is my code not executing from $(document).ready(function() down to the end of </html>, when I run the file there are pictures and button but bellow that is just this code written on the page.
Could you help please?

Ram Anuj

Notice: Trying to access array offset on value of type null in C:xampphtdocsmmtutsphpaction.php on line 17

Fatal error: Uncaught Error: Call to a member function bind_param() on bool in C:xampphtdocsmmtutsphpaction.php:22 Stack trace: #0 {main} thrown in C:xampphtdocsmmtutsphpaction.php on line 22
your code generate thiese error bro……

+

How would you write the code without MYSQLND? I can't use get_result()

jyotisman moitra

I want to ask one thing what for indeviduals cart when users are not logged in. as for example if we see on flipkart that they can handle indeviduals (not regiaterd user) cart separately.

Yeamin Rabbi

Notice: Trying to access array offset on value of type null in $code = $r['product_code'];

what is the problem here???

Aniket Adarsh

if you are not able to insert data into database , just check your jquery version and replace your slim version with regular version

fariyah20 shahzad

please reply me

sazzad ahmed

sir , i press add to cart button, it didnt insert into my database and not show thwe successfully massage and danger massage , my code is alredy 4 time checking i'm not code mistake so please sir your source code give me …..sazzadahmed109@gmail.com

sudhir kumar

I have some erros, can you give me the source code please! Email:-sudhirkumary7@gmail.com

vaibhav sinha

Don't make this type of video ,, which works only for you and not for users .

krethick chakravarthy

Sir Can you pls send the code

אושר רווח

After Clicking Add to cart, nothing happens. using Sublime text 3 + Xampp, Source Code of Part3 please!!

Fury Hounds

Hey, I would like to ask, why everytime i press add to cart button, it didnt insert into my database?

The only difference i had is that i used foreign keys for the name and price

Ch Mazhar Haroon

Sir please help me