Learn Java – Tutorials, Tips, Help, and Resources for Learning Java 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
Reference: Advanced Operators for Web Search - GoogleWebSearchEducation Updated: October 21, 2011 Here, in one place, are all of the currently documented advanced search operators for web search. Note that Scholar, Groups, etc. may have some unique operators listed elsewhere. Also note that some operators come in pairs (e.g., allinanchor along with inanchor: ). We’ve written about them together rather than having two entries for the same kind of operator. Also, we followed the square brackets convention where a query is surrounded by square brackets. allinanchor: / inanchor: Google restricts results to pages containing all query terms in the anchor text on links to the page. allintext: / intext: Restricts results to those containing all the query terms you specify in the text of the page. allintitle: / intitle: Restricts results to those containing all the query terms you specify in the title. allinurl: / inurl: Restricts results to those containing all the query terms you specify in the URL. term1 AROUND( n ) term2 define: filetype:suffix Fill in the blanks (*)
Perl Programming & Tutorials from About.com Apprendre à développer avec le langage PHP The Ruby Programming Language Practical PHP Programming About Visual Basic 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.