PHP MySQL Tutorial




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

Original source


44 responses to “PHP MySQL Tutorial”

  1. Derek, thank you for your excellent tutorials.
    I need an online database – in other words, a
    database that 'lives' on my website server (instead of my local computer) so that other
    people can log in to view, submit, or remove data. Is there a
    way to accomplish this?

    Thanks!

  2. 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 !

  3. 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.

  4. 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.

  5. 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!

  6. 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

  7. 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?

  8. 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!

Leave a Reply