PHP insert into mysql database with dates

Question

I would like to be able to add children into a database, which are connected to their parents (who has a member id MID). I believe that the error lies within the date format (atleast that's what I believe), I have also tried to use strtotime($dob), however this didn't change anything.

   $name = htmlspecialchars($_GET['Name']);
   $dob = $_GET['DOB'];
   $newDOB = date("Y-m-d", $dob);
   $mid = $_GET['mid'];

   if(isset($_GET['Name'], $_GET['DOB'], $_GET['mid']))
       $alert = true;
   if(!empty($name) && !empty($newDOB) && !empty($mid))
       add_family_member($mid, $newDOB, $name);

The function that adds the member:

function add_family_member($mid, $dob, $name)
{
    global $con;
    $sql = "INSERT INTO Children(MID, DOB, Name) VALUES(?, ?, ?)";
    $stmt = $con->prepare($sql);
    if($stmt)
    {
        $b = $stmt->bind_param("iss", $mid, $dob, $name);
        if($b)
        {
            $e = $stmt->execute();
            if($e)
                return true;
        }
    }

    return false;
}

You can't mix PDO and MySQLi. Btw DateTime is specially made for... date and times ;-) — Daniel W.
– Daniel W., Commented Jun 10, 2014 at 12:11
are you getting any insert at all or error ? if error, post it — John Priestakos
– John Priestakos, Commented Jun 10, 2014 at 12:34

Rufinus · Accepted Answer · 2014-06-10 11:42:42Z

1

function add_family_member($mid, $dob, $name)
{
    global $con;
    $sql = "INSERT INTO Children(MID, DOB, Name) VALUES(:mid, :dob, :name)";
    $stmt = $con->prepare($sql);
    if($stmt)
    {
        return $stmt->execute(array(
             'mid' => $mid,
             'dob' => $dob,
             'name' => $name
        ));           
    }

    return false;
}

see http://www.php.net/manual/en/pdostatement.execute.php for more examples

answered Jun 10, 2014 at 11:42

Rufinus

30.9k7 gold badges71 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Cralle Over a year ago

Doesn't work, wouldn't this only work with using PDO?

Rufinus Over a year ago

you dont said what you use, but yes this is pdo.

Rufinus · Accepted Answer · 2014-06-10 12:15:05Z

0

Try...

function add_family_member($mid, $dob, $name)
    {
        global $con;
        $sql = "INSERT INTO Children(MID, DOB, Name) VALUES(:mid, :dob, :name)";
        $stmt = $con->prepare($sql);
        $stmt->bindParam(':mid', $mid);
        $stmt->bindParam(':dob', $dob);
        $stmt->bindParam(':name', $name);
        if ($stmt->execute()) {
            return true;
        }
        return false;
    }

edited Jun 10, 2014 at 12:15

Rufinus

30.9k7 gold badges71 silver badges85 bronze badges

answered Jun 10, 2014 at 11:54

Indrajeet Singh

2,99927 silver badges28 bronze badges

Collectives™ on Stack Overflow

PHP insert into mysql database with dates

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related