A little php coding help needed
- Thread starter lorand
- Start date
SpoonFeeder
BANNED
- Mar 19, 2017
- 1,608
- 2,096
Sure. PM me the info.
SpoonFeeder
BANNED
- Mar 19, 2017
- 1,608
- 2,096
Sent you the code in PM
Last edited:
D
Deleted member 657006
Guest
is folder 777 set
lorand
Regular Member
- Apr 26, 2010
- 489
- 98
yes
lorand
Regular Member
- Apr 26, 2010
- 489
- 98
this is the original code, i am interested to check if "$fname=$_POST['first_name'];" exist :
PHP:
<?php
require_once ('db.php');
if (isset($_POST['Submit'])) {
// echo "";
// }else{
// $file=$_FILES['image']['tmp_name'];
// $image = $_FILES["image"] ["name"];
// $image_name= addslashes($_FILES['image']['name']);
// $size = $_FILES["image"] ["size"];
// $error = $_FILES["image"] ["error"];
//
// if ($error > 0){
// die("Error uploading file! Code $error.");
// }else{
// if($size > 10000000) //conditions for the file
// {
// die("Format is not allowed or file size is too big!");
// }
//
// else
// {
move_uploaded_file($_FILES["image"]["tmp_name"],"uploads/" . $_FILES["image"]["name"]);
$location=$_FILES["image"]["name"];
$fname=$_POST['first_name'];
$lname=$_POST['last_name'];
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "INSERT INTO tbl_image (first_name, last_name, image_location)
VALUES ('$fname', '$lname', '$location')";
$conn->exec($sql);
echo "<script>alert('Successfully Added!!!'); window.location='index.php'</script>";
// }
}
// }
?>
Veil123
Elite Member
- Jun 13, 2012
- 1,839
- 3,357
if the server has mysqli enabled use the following example (if it does not have mysqli enabled, change mysqli with mysql):
PHP:
$result = mysqli_query($conn, "SELECT * FROM tableName WHERE user='$fname'")
if (mysqli_num_rows ($result) > 0)
{
//do what you want here
}
SamLewis
Supreme Member
- Oct 25, 2012
- 1,343
- 1,058
Code:
if (isset($fname)) {
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "INSERT INTO tbl_image (first_name, last_name, image_location)
VALUES ('$fname', '$lname', '$location')";
$conn->exec($sql);
echo "<script>alert('Successfully Added!!!'); window.location='index.php'</script>";
} else {
echo "Firstname not set"
}