background preloader

Learn PHP - PHP Tutorials - PHP with MySQL Tutorials

Learn PHP - PHP Tutorials - PHP with MySQL Tutorials

PHP Tutorial - Databases in PHP, SQL Basics In the last part of this tutorial series we talked about the basic structure of databases in modern database management systems (DBMS) and mentioned the structured language used in accessing those databases. The language is the Structured Query Language, SQL, which is commonly pronounced as if it was a word - "Seekul". Now, before we get into coding specific commands in PHP, it is very worthwhile to get an overview of the basic elements of the language and the purpose of those elements. In SQL everything is done in a "query". Personally I think this must be because somebody got the idea that since it's a query language, everything must be a query, and made it so even if it's an instruction like "add this record". Create It seems logical to begin with the create command, since it is used to create databases and the tables within them. Drop The opposite of create, drop is used to delete databases and tables. Insert Delete At the record level, delete is the opposite of insert. Update Select

Apprendre à développer avec le langage PHP Practical PHP Programming PHP Code Snippets Force File Download Want to force a user to download a file instead of viewing it in his/her browser? Use this snippet to do just that. List directory contents pass in a path to a folder (string), and it will print out all the items found in that folder, if it exists.

Manuel PHP Edit Report a Bug Manuel PHP ¶ par: Mehdi Achour Friedhelm Betz Antony Dovgal Nuno Lopes Hannes Magnusson Georg Richter Damien Seguy Jakub Vrana Et bien d'autres Édité par: Peter Cowburn par: Frédéric Blanc Traducteur Vincent Blanchon Traducteur Pierrick Charron Traducteur Julien Pauli Traducteur Mickaël Perraud Relecteur Guillaume Plessis Traducteur Yannick Torrès Traducteur Vincent Briet Jean-Sébastien Goupil David Manusset © 1997-2019 PHP Documentation Group add a note User Contributed Notes There are no user contributed notes for this page.

Related: