• 05Dec

    MySQL and PHPMyAdmin Introduction 03

    MySQL, PHP Tutorials, PHPMyAdmin No Comments

    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.

  • 25Nov

    MySQL and PHPMyAdmin Introduction 02

    MySQL, PHP Tutorials, PHPMyAdmin No Comments

    PHPMyAdmin, a free tool to administer MySQL databases that provides the SQL statements used so you can redo what you did in the web application in php code.
    In this introduction, I show how we can insert rows into a table, the meaning of auto_increment, What PRIMARY keys are, and other things.
    You can find this tutorial video on youtube here.

    More after the break.
    Read more…

  • 21Nov

    MySQL and PHPMyAdmin Introduction 01

    MySQL, PHP Tutorials, PHPMyAdmin No Comments

    MySQL is a commonly used database tool that many developers use freely. It is Open Source, and there are no license fees. PHP developers usually will use MySQL to save data, which can be searched, organized and managed to return the data needed for the goals of the developer. PHPMyAdmin is a free tool to manage and edit a MySQL database. It is Free, Straight forward, and quick. It also gives you the SQL queries you can use to recreate what it does.

    This video goes over what MySQL is and how useful PHPMyAdmin is to work with PHP. This is just the first part of several introduction videos on how to use PHPMyAdmin.
    You can find this tutorial video on youtube here.

   Next Entries »