No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
this is my code $sql = "SELECT * FROM `sale_history` WHERE `date` BETWEEN :fromdate AND :todate"; $stmt = $PDO->prepare($sql); $stmt->bindParam(':fromdate', $_POST['fromdate'], PDO::PARAM_STR); $stmt->bindParam(':todate', $_POST['todate'], PDO::PARAM_STR); $stmt->execute(); $total = $stmt->rowCount(); while ($row = $stmt->fetchObject()) { echo "$row->date"; echo "$row->product"; echo "$row->username"; echo "$row->quantity"; } but its not working, where is the … |
|
<?php if (isset ($_POST['submit'])) { try { $picture = "../images/default-picsss.png"; $sql = " INSERT INTO user (username, password, fullname, address, mobile, email, picture) VALUES (:username, :password, :fullname, :address, :mobile, :email, :picture ); INSERT INTO user_balance (username) VALUE (:username); "; $stmt = $PDO->prepare($sql); $stmt->bindParam(':username', $_POST['username'], PDO::PARAM_STR); $stmt->bindParam(':password', $_POST['password'], PDO::PARAM_STR); $stmt->bindParam(':fullname', $_POST['fullname'], … |