Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 91 to 100 of 875 10 Older Entries

Displaying posts with tag: PHP (reset)

Prevent SQL Injection in PHP
+0 Vote Up -0Vote Down

Two easy ways to prevent SQL Injection in PHP

To many people still execute sql queries using methods which does not prevent SQL Injection, and many tutorials out there give bad example of doing so.

SQL Injection? What? -> SQL Injection explained

There are two easy aproachs to prevent SQL Injection:

  • Using PDO:
    stmt = $pdo->prepare('SELECT * FROM employees WHERE name = :name'); 
    $stmt->execute(array(':name' => $name)); 
    foreach ($stmt as $row) {     
        // do something with $row 
  • Using mysqli:
    $stmt = $dbConnection->prepare('SELECT

  •   [Read more...]
    Learn to Create Applications Using MySQL with MySQL for Developers Course
    Employee_Team +2 Vote Up -0Vote Down

    If you are a database developer who wants to create applications using MySQL, then the MySQL for Developers course is for you. This course covers how to plan, design and implement applications using the MySQL database with realistic examples in Java and PHP.

    To see more details of the content of the MySQL for Developers course, go to and click on the Learning Paths tab and select the MySQL Developer path.

    You can take this course as a:

    • Live-Virtual Event: Follow this live instructor-led event from your own desk - no travel required. Choose from a selection of events on the calendar in languages such as English, German and Korean.
    • In-Class Event: Travel to an education center to take this class. Below is a sample of events on the schedule.
      [Read more...]
    Supercharging PHP MySQL applications using the best API
    Employee +3 Vote Up -0Vote Down

    PHP MySQL developers are confronted with three PHP MySQL APIs. That is confusing. Since mid 2012 the PHP manual suggests not to use the oldest and original PHP MySQL extension any more to cure the situation. Please, swap out ext/mysql in favour of either ext/mysqli or PDO_MySQL. Why to upgrade is below. Read on, if you are a PHP beginner, your PHP application is still using mysql_* functions of ext/mysql or you are a PHP trainer.

    As a PHP consumer, tease your software vendors by asking whether they use the state of the art APIs! Here is a cut&paste test question to ask your vendor: do you support secure SSL connections to MySQL?

    History  [Read more...]

    Power Dynamic Database-Driven Websites with MySQL & PHP
    Employee_Team +1 Vote Up -0Vote Down

    Join major names among MySQL customers by learning to power dynamic database-driven websites with MySQL & PHP.

    With the MySQL and PHP: Developing Dynamic Web Applications course, in 4 days, you learn how to develop applications in PHP and how to use MySQL efficiently for those applications! Through a hands-on approach, this instructor-led course helps you improve your PHP skills and combine them with time-proven database management techniques to create best-of-breed web applications that are efficient, solid and secure.

    You can currently take this course as a:

    • Live Virtual Class (LVC): There are a number events on the schedule to suit different timezones in January 2013 and March 2013. With an LVC, you get to follow this live instructor-led class from your own desk - so no travel expense or inconvenience.
      [Read more...]
    OpenCode: MySQL procedures + python + shell code repositories now public
    +1 Vote Up -0Vote Down

    I write a fair number of scripts on this site and have posted a lot of code over the years. Generally if I am not pasting the code to be viewed on the webpage then I link to a file that a user can download; which leads to a lot of mish-mash code that doesn’t have a home. I’ve always kept the code files in a private SVN repo over the years but have recently moved them all to BitBucket Git repositories. So here they are: lots of code samples and useful bits of programming to save time.

    Generic Shell Scripts:
    Generic Python Scripts:
    Generic MySQL Stored Procs:

      [Read more...]
    Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support (LEMP) On Ubuntu 12.10
    +0 Vote Up -0Vote Down

    Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support (LEMP) On Ubuntu 12.10

    Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 12.10 server with PHP5 support (through PHP-FPM) and MySQL support (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP).

    Installing Apache2 With PHP5 And MySQL Support On Ubuntu 12.10 (LAMP)
    +0 Vote Up -0Vote Down

    Installing Apache2 With PHP5 And MySQL Support On Ubuntu 12.10 (LAMP)

    LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 12.10 server with PHP5 support (mod_php) and MySQL support.

    Using lookup tables
    +1 Vote Up -0Vote Down

    My students wanted an example of how to use a lookup table in the database. I thought it would be a great idea to create a simple example like this one.

    A lookup table is a generalization that holds lists of values that support end-user selections. The following example uses a combination of the common_lookup_table and common_lookup_column columns to identify sets of value for drop down lists. The end-user selects a value from the list to identify a unique row, and returns a common_lookup_id surrogate key value.

    The sample code uses the table defined in the previous illustration. It uses a simple HTML drop down list, a PHP

      [Read more...]
    3 times speed increase with static pages
    +0 Vote Up -0Vote Down
    Internet was born from static pages. People were creating websites with emacs and vi. With increased popularity of scripting languages and open source databases like MySQL and Postgresql, more and more developers started to use these advanced tools. CMS systems were build. They made our lives much easier. Instead of altering file contents with editor, the user can simply go to the website admin
    MySQL, Memcache, PHP revised
    Employee +0 Vote Up -0Vote Down

    Some time ago I was writing about the InnoDB Memcache Daemon plugin already for the MySQL server. Back then we had a labs release with a little preview only. Meanwhile quite some time passed and new developments were made - just in time for the MySQL 5.6 RC announced this weekend by Tomas.

    The innodb_memcache daemon plugin is a plugin for the MySQL Server end contains an embedded memcached. This embedded memcached is configured to use MySQL's InnoDB engine as storage backend. By using this data stored inside an InnoDB table can be accessed using memcache's key-value protocol. Back in the times of the previous blog post this was limited to data from a

      [Read more...]
    10 Newer Entries Showing entries 91 to 100 of 875 10 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.