bakit kaya di nasasave yun picture sa database
ito code ko
<?php
include "./config/config.php";
$payee_name = $email_address = $username = $password = '';
$payee_nameErr = $email_addressErr =$usernameErr =$passwordErr = '';
if($_SERVER['REQUEST_METHOD'] == 'POST') {
if(empty($_POST['payee_name'])){
$payee_nameErr = "Payee Name is required!";
}else{
$payee_name = $_POST['payee_name'];
}
if(empty($_POST['email_address'])){
$email_addressErr = "Email Address is required!";
}else {
$email_address = $_POST['email_address'];
}
if(empty($_POST['username'])) {
$usernameErr = " Username os required!";
}else {
$username = $_POST['username'];
}
if(empty($_POST['password'])){
$passwordErr = "Password is required!";
}else {
$password = $_POST['password'];
}
if ($payee_name && $email_address && $username && $password ) {
$check_email = mysqli_query($con, "SELECT * FROM
$check_email_row = mysqli_num_rows($check_email);
if($check_email_row > 0 ){
$payee_nameErr = "Name is already registered!";
}else {
$slq= mysqli_query($con, "INSERT INTO
echo "<div class='alert alert-success' role='alert'>
A simple success alert—check it out!
</div>";
}
}
}
?>
<?php
$target_dir = "./photo_folder/";
$uploadErr = "";
if (isset($_POST["update"])){
$target_file = $target_dir . "/" . basename($_FILES["profile-pic"]["name"]);
$uploadOk = 1;
if(file_exists($target_dir)) {
$target_file = $target_dir . rand(1,9) . rand(1,9) . rand(1,9) . rand(1,9) . "_" .basename($_FILES["profile-pic"]["name"]);
$uploadOk = 1;
}
$imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);
if($_FILES["profile-pic"]["size"] > 5000000000000000000 ) {
$uploadErr = "Sorry, your file is too large";
$uploadOk = 0;
}
if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg" && $imageFileType != "gif") {
$uploadErr = "Sorry, only JPG, PNG, JPEG and GIF files are allowed";
$uploadOk = 0;
}
if($uploadOk == 1) {
if (move_uploaded_file($_FILES["profile-pic"]["tmp_name"], $target_file)){
$file_path = mysqli_real_escape_string($con, $target_file);
$slq = "INSERT INTO registration (img) VALUES ('$file_path')'";
if ($con ->query($slq) === TRUE) {
echo "The file has been uploaded and the file path has been stored in the database" ;
}else {
echo "was error storing the file path in database" .$conn->error;
}
}else {
echo "sorry , there was an error uploading file.";
}}
}
?>
ito code ko
<?php
include "./config/config.php";
$payee_name = $email_address = $username = $password = '';
$payee_nameErr = $email_addressErr =$usernameErr =$passwordErr = '';
if($_SERVER['REQUEST_METHOD'] == 'POST') {
if(empty($_POST['payee_name'])){
$payee_nameErr = "Payee Name is required!";
}else{
$payee_name = $_POST['payee_name'];
}
if(empty($_POST['email_address'])){
$email_addressErr = "Email Address is required!";
}else {
$email_address = $_POST['email_address'];
}
if(empty($_POST['username'])) {
$usernameErr = " Username os required!";
}else {
$username = $_POST['username'];
}
if(empty($_POST['password'])){
$passwordErr = "Password is required!";
}else {
$password = $_POST['password'];
}
if ($payee_name && $email_address && $username && $password ) {
$check_email = mysqli_query($con, "SELECT * FROM
registration
WHERE payee_name = '$payee_name'");$check_email_row = mysqli_num_rows($check_email);
if($check_email_row > 0 ){
$payee_nameErr = "Name is already registered!";
}else {
$slq= mysqli_query($con, "INSERT INTO
registration
(payee_name, email_address, username, password, user_type) VALUES ('$payee_name', '$email_address', '$username', '$password', '2')");echo "<div class='alert alert-success' role='alert'>
A simple success alert—check it out!
</div>";
}
}
}
?>
<?php
$target_dir = "./photo_folder/";
$uploadErr = "";
if (isset($_POST["update"])){
$target_file = $target_dir . "/" . basename($_FILES["profile-pic"]["name"]);
$uploadOk = 1;
if(file_exists($target_dir)) {
$target_file = $target_dir . rand(1,9) . rand(1,9) . rand(1,9) . rand(1,9) . "_" .basename($_FILES["profile-pic"]["name"]);
$uploadOk = 1;
}
$imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);
if($_FILES["profile-pic"]["size"] > 5000000000000000000 ) {
$uploadErr = "Sorry, your file is too large";
$uploadOk = 0;
}
if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg" && $imageFileType != "gif") {
$uploadErr = "Sorry, only JPG, PNG, JPEG and GIF files are allowed";
$uploadOk = 0;
}
if($uploadOk == 1) {
if (move_uploaded_file($_FILES["profile-pic"]["tmp_name"], $target_file)){
$file_path = mysqli_real_escape_string($con, $target_file);
$slq = "INSERT INTO registration (img) VALUES ('$file_path')'";
if ($con ->query($slq) === TRUE) {
echo "The file has been uploaded and the file path has been stored in the database" ;
}else {
echo "was error storing the file path in database" .$conn->error;
}
}else {
echo "sorry , there was an error uploading file.";
}}
}
?>