Add to cart button is not sending information to data base
up vote
0
down vote
favorite
Currently im trying to create an ecommerce website by watching youtube videos. Now im at the stage where adding to cart is created. I have followed exactly as the code of the person who created the video. it worked for him but not for me. i have scanned my code with his a few times already and there wasnt any mistakes made such as wrong spelling, etc. I hope someone can guide me on this because i cannot proceed without accomplishing this stage.`function cart()
if(isset($_GET['add_cart']))
global $con;
$ip = getIp();
$pro_id = $_GET['add_cart'];
$check_pro = "select * from cart where ip_add='$ip' AND p_id='$pro_id'";
$run_check = mysqli_query ($con, $check_pro);
if(mysqli_num_rows($run_check)>0)
echo "";
else
$insert_pro = "insert into cart (p_id,ip_add) values ('$pro_id','$ip')";
$run_pro = mysqli_query($con, $insert_pro);
echo "<script>window.open('index.php','_self')</script>";
`
function getIp()
$ip = $_SERVER['REMOTE_ADDR'];
if (!empty($_SERVER['HTTP_CLIENT_IP']))
$ip = $_SERVER['HTTP_CLIENT_IP'];
elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))
$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
return $ip;
i have linked this functions in my homepage by using this code : <?php cart(); ?>
php
add a comment |
up vote
0
down vote
favorite
Currently im trying to create an ecommerce website by watching youtube videos. Now im at the stage where adding to cart is created. I have followed exactly as the code of the person who created the video. it worked for him but not for me. i have scanned my code with his a few times already and there wasnt any mistakes made such as wrong spelling, etc. I hope someone can guide me on this because i cannot proceed without accomplishing this stage.`function cart()
if(isset($_GET['add_cart']))
global $con;
$ip = getIp();
$pro_id = $_GET['add_cart'];
$check_pro = "select * from cart where ip_add='$ip' AND p_id='$pro_id'";
$run_check = mysqli_query ($con, $check_pro);
if(mysqli_num_rows($run_check)>0)
echo "";
else
$insert_pro = "insert into cart (p_id,ip_add) values ('$pro_id','$ip')";
$run_pro = mysqli_query($con, $insert_pro);
echo "<script>window.open('index.php','_self')</script>";
`
function getIp()
$ip = $_SERVER['REMOTE_ADDR'];
if (!empty($_SERVER['HTTP_CLIENT_IP']))
$ip = $_SERVER['HTTP_CLIENT_IP'];
elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))
$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
return $ip;
i have linked this functions in my homepage by using this code : <?php cart(); ?>
php
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
Currently im trying to create an ecommerce website by watching youtube videos. Now im at the stage where adding to cart is created. I have followed exactly as the code of the person who created the video. it worked for him but not for me. i have scanned my code with his a few times already and there wasnt any mistakes made such as wrong spelling, etc. I hope someone can guide me on this because i cannot proceed without accomplishing this stage.`function cart()
if(isset($_GET['add_cart']))
global $con;
$ip = getIp();
$pro_id = $_GET['add_cart'];
$check_pro = "select * from cart where ip_add='$ip' AND p_id='$pro_id'";
$run_check = mysqli_query ($con, $check_pro);
if(mysqli_num_rows($run_check)>0)
echo "";
else
$insert_pro = "insert into cart (p_id,ip_add) values ('$pro_id','$ip')";
$run_pro = mysqli_query($con, $insert_pro);
echo "<script>window.open('index.php','_self')</script>";
`
function getIp()
$ip = $_SERVER['REMOTE_ADDR'];
if (!empty($_SERVER['HTTP_CLIENT_IP']))
$ip = $_SERVER['HTTP_CLIENT_IP'];
elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))
$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
return $ip;
i have linked this functions in my homepage by using this code : <?php cart(); ?>
php
Currently im trying to create an ecommerce website by watching youtube videos. Now im at the stage where adding to cart is created. I have followed exactly as the code of the person who created the video. it worked for him but not for me. i have scanned my code with his a few times already and there wasnt any mistakes made such as wrong spelling, etc. I hope someone can guide me on this because i cannot proceed without accomplishing this stage.`function cart()
if(isset($_GET['add_cart']))
global $con;
$ip = getIp();
$pro_id = $_GET['add_cart'];
$check_pro = "select * from cart where ip_add='$ip' AND p_id='$pro_id'";
$run_check = mysqli_query ($con, $check_pro);
if(mysqli_num_rows($run_check)>0)
echo "";
else
$insert_pro = "insert into cart (p_id,ip_add) values ('$pro_id','$ip')";
$run_pro = mysqli_query($con, $insert_pro);
echo "<script>window.open('index.php','_self')</script>";
`
function getIp()
$ip = $_SERVER['REMOTE_ADDR'];
if (!empty($_SERVER['HTTP_CLIENT_IP']))
$ip = $_SERVER['HTTP_CLIENT_IP'];
elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))
$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
return $ip;
i have linked this functions in my homepage by using this code : <?php cart(); ?>
php
php
asked Nov 10 at 4:19
Ganeshwaran Selvarajah
11
11
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53235959%2fadd-to-cart-button-is-not-sending-information-to-data-base%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown