PHP MySQL Tutorial




Get the Code Here : http://goo.gl/Aocylf PHP Tutorial : https://www.youtube.com/watch?v=7TF00hJI78Y MySQL Tutorial …

Original source


49 responses to “PHP MySQL Tutorial”

  1. Been on youtube for years, and never felt the need to comment anything..
    Just to say how much i'm thankful to you and your work.
    I love the way you make every coding language basics seem so simple.
    Great job and thank you again !

  2. Hi Derek, any idea how to link database info to 3rd party websites that are not controlled by you? Such that the various fields (e.g. name, age, sex, etc) are automatically filled in at the click of a button (or two). Something like what Fillr does.

  3. How would I add some code to check if a record already exists in the table before entering it? I'm adding usernames and don't want duplicates, I've added it as a 'unique' which prevents new duplicate entries from being created. But I get an error message and just want something cleaner.

  4. I am newbie in php and this tutorial is very good :).. however I tried to used your code in the link you have provided in comment but I have experienced an error which is the reason why I can't run the code correctly, can tell me why is this not working.

    I am using xampp, I created directory for this files and the error that I've encountered are this:
    Couldn't issue database query
    Table 'test3.students' doesn't exist

    thanks!

  5. After clicking on Send, i got these warnings

    Notice: Undefined variable: dbc in D:XAMMPhtdocsexamplestudentadded.php on line 98

    Warning: mysqli_prepare() expects parameter 1 to be mysqli, null given in D:XAMMPhtdocsexamplestudentadded.php on line 98

    Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, null given in D:XAMMPhtdocsexamplestudentadded.php on line 100

    Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, null given in D:XAMMPhtdocsexamplestudentadded.php on line 102

    Warning: mysqli_stmt_affected_rows() expects parameter 1 to be mysqli_stmt, null given in D:XAMMPhtdocsexamplestudentadded.php on line 104
    Error Occureed

    Warning: mysqli_error() expects exactly 1 parameter, 0 given in D:XAMMPhtdocsexamplestudentadded.php on line 116

  6. Hey!
    When try to add new student, i fill up the caps i need to, then press send button, and it clears all data i had entered. Then i go to getstudentinfo page, and there is no added student i just tried to add.

    Also in file added student, mysqli_stmt_bind_param($stmt, "ssssssisssd", $f_name, $l_name … ) it only allowe me to give 3 arguments. Can any1 help?

  7. Maybe I missed something but what exactly is the PHP command to establishes the connection between PHP and MySQL? In Minute 4:30 you define variable 'dbc ' and you use the 'mysqli_connect' function. Is that a native PHP function that establishes connections to any DB? What if my DB is not MySQL but something else, will this still work? Thank you!

  8. great job and thanks a millions. You used require_once('../mysqli_connect.php') because that file was saved outside the main web folder. how will you write the path directory if it is saved in the same folder as the other web documents.

  9. Derek, love you mate. One question, will mysqli_connect_error() not provide sensitive information?
    $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
    OR die('Could not connect to MySQL: ' .
    mysqli_connect_error());

Leave a Reply