Jump to content

mrbobey

Members
 View Profile  See their activity

  • Posts

    13

  • Joined

  • Last visited

 Content Type 

Posts posted by mrbobey

    HTML page Looks fine in local host when uploaded to hosting site something messy happen.

    in HTML Help

    Posted

    HTML page Looks fine in local host when uploaded to hosting site something messy happen, but it goes worst into android device. the page coded to be responsive. other pages looks fine both pc and android when uploaded to hosting site except this one page.. when i put a form into the div something happen, but it is good in localhost in hosting site is not what i wanted to be seen and also to the android,

    PHP PROBLEM ADDING VALUES INTO DATABASE

    in PHP Coding Help

    Posted

    16 minutes ago, mac_gyver said:

    there are a fairly large number of things that can cause your code to work on one system but not another and if your code is lacking validation and error handling logic, your code won't tell you why it is failing. under perfect conditions, on your development system, your code may work, but if anything goes wrong, you won't get any help from your code.

    firstly, you need to temporarily set php's error_reporting to E_ALL and set display_errors to ON, so that you will get immediate feedback if any php errors are occurring (the cheep/free web hosts may not allow you to do this.)

    you also need consistent and useful error handling for all the database statements that can fail - connection, query, prepare, and execute (which you don't currently have any error handling for.) the simplest way of adding error handling for all the database statements is to use exceptions for errors and in most cases let php catch and handle the exception, where php will use its error related settings (see the above paragraph) to control what happens with the actual error information (database statement errors will 'automatically' get displayed/logged the same as php errors.) this will let you remove the existing error handling logic and skip adding it where there is none. the exception to letting php catch the exceptions is when inserting/updating duplicate or out of range user submitted values, which is what you should be doing to detect if a product is already in the cart. in this case, your code should catch the exception, detect if the error number is for something that your code is designed to handle, then setup and display a message for the user telling them what was wrong with the data that they submitted. for all other error numbers, simply re-throw the exception and let php handle it.

    it doesn't appear that you have any validation logic? you should always trim, then validate all input data before using it. if there are no validation errors, use the submitted data. if there are validation errors, display them when you re-display the add product form(s). the only product information you insert into the cart is the product id and the quantity. all the other product data exists in the featuredlist table and should not be duplicated in the cart. 

    you have a lot of unnecessary code that isn't helping. by putting the form processing code on a different page from the add product form(s), you have more code, a bunch of redirects, and are producing a bad user experience. when you put these on the same page, there will be less code, you can eliminate all but one redirect (upon successful completion), and you can display any validation/user error messages when you re-display the add product form(s). the only redirect you should have in your post method form processing code is upon successful completion of the processing code and it should be to the exact same url of the current page. this will cause a get request for that page. if you want the user to be able to navigate to other pages, provide navigation links. if you want to display a one-time success message, store it in a session variable, then test, display, and clear the session variable at the appropriate location in the html document.

    as to another reason why your code may not work, on one system, but not another, and be giving the symptom of going back to the cart.html page - what does using a phpinfo() statement in a php script show for the output_buffering setting? because you are redirecting all over the place (which hopefully you will remove, see the above paragraph), any debugging output from your script and any non-fatal php errors will get discarded if the ouput_buffering setting is ON (any non-zero value.) you should set this to OFF.

    lastly, you should not attempt to SELECT data in order to decide if it already exists. you should set up the table with a unique composite index for the column(s) that identify the user id and product id combination, just attempt to insert the data, and detect if a duplicate index error occurred (see the above paragraph concerning catching an exception for a duplicate error.) 

    wohhh... i think my mind get explode while absorbing the necessary things that you said.. thanks alot im not getting this information through hearing from the professor or else it would be repeated :D  thank you for this... i am gladly you made effort for checking my file.. thanks alot.. im just only a newbie here where youtube and google is my instructor.. thank you sir..

    PHP PROBLEM ADDING VALUES INTO DATABASE

    in PHP Coding Help

    Posted

    4 minutes ago, requinix said:

    I was pointing out the period, not the variable.

    Imagine how much harder it will be to fix later.

    There's a really, really obvious problem here that you have to solve: being extremely careful about what user names you allow. Not only must you require letters and perhaps numbers, you can't allow certain words because it might conflict with other real tables.

    That suggests this line 

    if($row = mysqli_fetch_assoc($resultdata)){

    is happening. Possibly the INSERT is not inserting, which you can check if you paid attention to return values from the mysqli functions, but that tends to be less likely.

    if there is wrong with the code why it is working in my localhost? I am sending you the video so that you will see exactly what is happening

    sample.jpg

    PHP PROBLEM ADDING VALUES INTO DATABASE

    in PHP Coding Help

    Posted

    16 minutes ago, requinix said:

    So your working code really has ".$name" in it?

    Yes because everytime when someone register that variable to be called. and that variable has something to do with my session so that when there name is being called it point to their specific table values

    That is bad. Stop doing that. Use one table for the records from all users.

    okay, i'm just a beginner thats what it comes to my mind. thank you for the suggestion i have to change it later but definitely change the whole back.end

    The change should be simple: create one table with a name, add a column for the user ID (or if you don't have one, the name), and add appropriate WHERE conditions in the places you need that.

    What does "not working" mean? What does it do? What does it not do? What do you expect to see happen?

    my code works in my localhost(xampp) no errors. The code does when the customer buy the product that he see in the product detail page it add on his specific cart and he immediately landed on his cart page. but when i upload the website on free hosting site 000webhost and infinityfree it does not work now... I checked already the connection it is okay, i querry the product from my database into my product page, it does. but when the customer buy the product, it land only his cart page and does not saving his product into the database.. when i replace my database from my backup with values to figure it out.. it really does see it in his cart page.. but when i buy another product using the hosting site its not working anymore... but you can register into my account page and you can log.in also with your account. that is my problem.

     

    PHP PROBLEM ADDING VALUES INTO DATABASE

    in PHP Coding Help

    Posted · Edited by mrbobey

    i will post the full code for this... 

    the function that is creating the table

function createcart($conn2, $Regname){
   $sql =  "CREATE TABLE .$Regname (
            TrxID INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
            ProductName VARCHAR(50) NOT NULL,
            Price DECIMAL(4.2) NOT NULL,
            Quantity INT(6) NOT NULL,
            ProductImage VARCHAR (255) NOT NULL,
            PurchasedDate VARCHAR(10) NOT NULL,
            PurchasedStatus VARCHAR(10) NOT NULL
            )";
    if ($conn2->query($sql) === TRUE){
        header("location: ../index.html");
        exit();
    }
    else{
        header("location: ../account.html?error=CannotCreateAccount");
        exit();
    }

my productdetail.html

<?php
		$uri =  $_SERVER["REQUEST_URI"];
		$uriArray = explode('/', $uri);
		$value = $uriArray[4];
		$_SESSION["PID"] = $value;
		require_once '../connection/connection.php';
		$sql = "SELECT * FROM featuredlist WHERE ProductID = ?";
		$stmt = mysqli_stmt_init($conn1);
		if (!mysqli_stmt_prepare($stmt, $sql)) {
		 echo 'connection error';
		}
		mysqli_stmt_bind_param($stmt, "i", $value);
		mysqli_stmt_execute($stmt);
		$resultdata = mysqli_stmt_get_result($stmt);
		if($row = mysqli_fetch_assoc($resultdata)){
			$DetailName = $row["ProductName"];
			$DetailPrice = $row["Price"];
			$DetailImage = $row["ProductImage"];
			$DetailCategory = $row["Category"];
			$DetailDetail = $row["ProductDetail"];
			$_SESSION["ProdName"] = $DetailName;
			$_SESSION["ProdPrice"] = $DetailPrice;
			$_SESSION["ProdImage"] = $DetailImage;
			$_SESSION["ProdDate"] = date("y.m.d");
			$_SESSION["ProdStatus"] = 'Not Paid';
		echo '<div class="col-2">
				<img src="'.$DetailImage.'" width="100%">
				</div>
				<div class="col-2">
				<h3>Category</h3>
				<p>'.$DetailCategory.'</p>
				<h1>'.$DetailName.'</h1>
				<h4>'.$DetailPrice.'php</h4>
				<form class="buy" action = "" method = "POST">
				<a href="../connection/buy.php" name = "buybtn" class="buy-btn">Add to Cart</a>
				</form>
				<h3>Product Information</h3><br>
				<p>'.$DetailDetail.'</p>
				</div>';
			}
		?>
my buy.php
<?php
session_start();
if(isset($_SESSION["Usrname"])){
require_once 'connection.php';
$name = $_SESSION["Usrname"];
$PName = $_SESSION["ProdName"];
$Price = $_SESSION["ProdPrice"];
$PImage = $_SESSION["ProdImage"];
$PDate = $_SESSION["ProdDate"];
$PStatus = $_SESSION["ProdStatus"];
$val = $_SESSION["PID"];
$sql = "SELECT * FROM .$name WHERE TrxID = ?";
    $stmt = mysqli_stmt_init($conn2);
    if(!mysqli_stmt_prepare($stmt, $sql)){
       echo "cannot buy this product please try again";
    }
    mysqli_stmt_bind_param($stmt, "s", $val);
    mysqli_stmt_execute($stmt);
    $resultdata = mysqli_stmt_get_result($stmt);
    if($row = mysqli_fetch_assoc($resultdata)){

        header("location: ../customer/cart.html");
        exit();
    }
    else{
    $sql = "INSERT INTO .$name (TrxID, ProductName, Price, ProductImage, PurchasedDate, PurchasedStatus) VALUES (?, ?, ?, ?, ?, ?)";
    $stmt = mysqli_stmt_init($conn2);
    if(!mysqli_stmt_prepare($stmt, $sql)){
    echo 'connection error';
}   
    mysqli_stmt_bind_param($stmt, "isssss", $val, $PName, $Price, $PImage, $PDate, $PStatus);
    mysqli_stmt_execute($stmt);
    mysqli_stmt_close($stmt);
    header("location: ../customer/cart.html");
    exit();
    }
}
else{
    header("location: ../account.html");
    exit();
}

     

    PHP PROBLEM ADDING VALUES INTO DATABASE

    in PHP Coding Help

    Posted

    there is no error in syntax i used that code in localhost through xamp and it is fine... the table im using is auto create table when there is a user register he has a table for his own.. i connect into that database, creating table to that database is fine also when there is someone regiter. but when im going to put a value to the columns on that table there is no event that happened

    PHP PROBLEM ADDING VALUES INTO DATABASE

    in PHP Coding Help

    Posted

    Good day guyz... I dont know why this code does not work...

    the connection is fine, the database is also fine it works with the localhost, when i upload it on free hosting site like 000webhost and infinityfree this is not working.. the database on free hosting site are also working also the connection is code, just only this code i cant figure it out.. 

    else{

$sql = "INSERT INTO .$name (TrxID, ProductName, Price, ProductImage, PurchasedDate, PurchasedStatus) VALUES (?, ?, ?, ?, ?, ?)";

$stmt = mysqli_stmt_init($conn2);

if(!mysqli_stmt_prepare($stmt, $sql)){

echo 'connection error';

}

mysqli_stmt_bind_param($stmt, "isssss", $val, $PName, $Price, $PImage, $PDate, $PStatus);

mysqli_stmt_execute($stmt);

mysqli_stmt_close($stmt);

header("location: ../customer/cart.html");

exit();

}

}

     

    How to make a Dynamic Product Detail page?

    in PHP Coding Help

    Posted

    you mean that there is no way to make this happen? instead for having a product detail page each product? there is no problem when using a link specified to that product because i already have that on database but there a too many products i have to make a product detail page so that they have a specified link.

    How to make a Dynamic Product Detail page?

    in PHP Coding Help

    Posted · Edited by mrbobey

    I think i might doing that already... here is the code:

    My Product Page

    <?php

    session_start();

    require_once 'connection.php';

    $sql = "SELECT * FROM featuredlist";

    $stmt = mysqli_stmt_init($conn1);

    if(mysqli_stmt_prepare($stmt, $sql)){

      mysqli_stmt_execute($stmt);

      $result = mysqli_stmt_get_result($stmt);

      while($row = mysqli_fetch_assoc($result)) {

        $Name = $row["ProductName"];

        $Price = $row["Price"];

        $Image = $row["ProductImage"];

        $Link = $row["ProductLink"];

        $_SESSION["ProdID"] = $row["ProductID"];  ---> applying session so that the ID of the product will be passed to the detail page

    echo '<div class="col-4">

          <a href="Ariel-with-downy.html"><img src="'.$Image.'"></a>';

    echo '<h4>'.$Name.'</h4>

          <p>'.$Price.'</p>

          </div>

          ';

      }

    } 

    else {

      echo "0 results";

    }

    mysqli_close($conn1);

    ?>

    <?php

     

    My Product Detail Page

     

            require_once '../connection/connection.php';

            $sql = "SELECT * FROM featuredlist WHERE ProductID = ?";

            $stmt = mysqli_stmt_init($conn1);

            if (!mysqli_stmt_prepare($stmt, $sql)) {

             echo 'connection error';

            }

            $value = $_SESSION["ProdID"]; -----> i am passing now the Product ID into the variable which is needed for the query.

            mysqli_stmt_bind_param($stmt, "i", $value);

            mysqli_stmt_execute($stmt);

            $resultdata = mysqli_stmt_get_result($stmt);

            if($row = mysqli_fetch_assoc($resultdata)){

                $DetailName = $row["ProductName"];

                $DetailPrice = $row["Price"];

                $DetailImage = $row["ProductImage"];

                $DetailCategory = $row["Category"];

                $DetailDetail = $row["ProductDetail"];           

         echo '<div class="col-2">

                    <img src="'.$DetailImage.'" width="100%">

                    </div>

                    <div class="col-2">

                    <h3>Category</h3>

                    <p>'.$DetailCategory.'</p>

                    <h1>'.$DetailName.'</h1>

                    <h4>'.$DetailPrice.'php</h4>

                    <form class="buy" action = "" method = "POST">

                    <a href="../Connection/buy.php" name = "buybtn" class="buy-btn">Add to Cart</a>

                    </form>

                    <h3>Product Information</h3><br>

                    <p>'.$DetailDetail.'</p>

                    </div>';

                }

            ?>

     

    My problem is when i click the product in the product page, it shows the last product on the detail page.

    How to make a Dynamic Product Detail page?

    in PHP Coding Help

    Posted

    I have a product page which populates all my products in one page. I have also a detail page which gives details on a product which i wanted to know. My problem is when I am going to click on the product that I want the detail page shows incorrect product details. I just want one detail product page so that it will be easy to edit the page in the future.

    I am asking an Idea on how to make one detail page in all of my products.. thanks...

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.