insert data to database with php [duplicate]

Question

I want to insert a data in database by this php code:

<?php
/*if(isset($_POST['username'])&&isset($_POST['password'])) {
    $username = $_POST['username'];
    $password = $_POST['password'];*/
    $DBS="localhost";// Database server
    $DBU="pb";
    $DBP="******";
    $con= new mysqli($DBS,$DBU,$DBP);
    if($con->connect_error)
        die("Connection failed: " . $con->connect_error);
    else{
        echo "Connected Sucssefully!";
        $sql = "INSERT INTO users (username, password, name)
        VALUES ('JJ', 'Doe', 'John')";
        if($con->query($sql)===TRUE)
            echo "User Created";
        else
            echo "Not Created!";}
//}
?>

but I get "Connected Sucssefully!Not Created!"! Idon't know why!

use this in your else statement: $con->error. Specifically replace echo "Not Created!" with echo $con->error what error comes back? — Arnolio
– Arnolio, Commented Dec 14, 2016 at 18:12
@RajdeepPaul no, nothing wrong with their query, they didn't choose a database, that's why,. — Funk Forty Niner
– Funk Forty Niner, Commented Dec 14, 2016 at 18:15
Mohammad, you didn't choose a database; that's why your code is failing. — Funk Forty Niner
– Funk Forty Niner, Commented Dec 14, 2016 at 18:16
Never store plain text passwords! Please use PHP's built-in functions to handle password security. If you're using a PHP version less than 5.5 you can use the password_hash() compatibility pack. Make sure you don't escape passwords or use any other cleansing mechanism on them before hashing. Doing so changes the password and causes unnecessary additional coding. — Jay Blanchard
– Jay Blanchard, Commented Dec 14, 2016 at 18:18
@RajdeepPaul yes they can and you need to retract your duplicate. — Funk Forty Niner
– Funk Forty Niner, Commented Dec 14, 2016 at 18:19

Mohammad Taghi Ghandili · Accepted Answer · 2016-12-14 18:24:20Z

-1

Thank you ! Specially @Arnolio . I used $con->error and it gave me "No database selected " and this error solved my problem ! I did not specify any database name! Regaards

answered Dec 14, 2016 at 18:24

Mohammad Taghi Ghandili

351 silver badge8 bronze badges

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

1 Comment

Funk Forty Niner Over a year ago

I said this already, didn't I?... "Mohammad, you didn't choose a database; that's why your code is failing"

Collectives™ on Stack Overflow

insert data to database with php [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related