• 05Dec

    MySQL and PHPMyAdmin Introduction 03

    MySQL, PHP Tutorials, PHPMyAdmin

    PHPMyAdmin allows you to easily administer MySQL databases and it can provide the SQL statements used so you can redo what you did in php code.
    First, it is important that you have a user to administer the database with, then you can connect to it through PHP. After that, you need to connect to the database, and then select the database that you are going to operate in. After that, you can safely execute your queries. However, to be truely safe, if you are handling variables that you generate, or the user has access to, you will want to use mysql_real_escape_string to protect yourself from SQL Injection.
    In this introduction, I show how we can insert rows into a table not only in PHPMyAdmin, but also through PHP by basing the SQL statement from the one provided by PHPMyAdmin. Also, in order to connect to a database in the first place, you need to have a user and the code to do so.
    You can find this tutorial video on youtube here.

    Posted by Kloplop321 @ 11:20 pm

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.