Tutorials to .com

Tutorials to .com » Php » Php Database operations

Php Database operations Articles


1: Php regular expressions on the two points Remarks
severaltipsaboutRegularExpressions 1.processfor "greedy" Bydefault, thequantifiersare "greedy", thatis, they matchasmuchaspossible (uptothemaximumnumberofper - mittedtimes), withoutcausingtherestofthepatternto fail.Theclassi...

2: PHP text database realization Sort
Programming in PHP, if you use a text-type database, it may order the issue of classification of headache. The following brief Xiaoyang how to use PHP script to achieve this combination of JavaScript functions: the following chart, when the user cli...

3: PHP in the Checkbox in the database to preserve data (1)
Introduction checkbox is a very useful single-page form, so that users in the case of multiple choices, it can even allow users to select all the items not chosen or a. However, although this is a very good form elements, but in our work, how to ch...

4: PHP in the Checkbox in the database to preserve data (2)
This code is very simple, you quickly read through it. There are two main function of the completion of the work: "get_checkbox_labels" and "make_checkbox_html". Which "get_checkbox_labels" look-up table and return an o...

5: Oracle database records page shows one of the categories
<? Php /********************************************* TOracleViewPage v 2.0 Date :2000-9-23 Page shows the type of Oracle database records Updated :2000-10-19 The increasing TopRecord function, allowing the first page of the record shows th...

6: Index for the database (b)
Then, to a little bit more complex, if there is a ORDER BY does everything? Whether you believe it or not, most of the database in order by the use of time, will benefit from the index. SELECT * FROM mytable WHERE category_id = 1 AND user_id = 2 ...

7: Database design skills (a)
In a dynamic web site design, database design, the importance of self-evident. If designed properly, it is very difficult to query, the performance of the procedure will also be affected. Without On you are using mySQL or Oracle databases, through ...

8: Database design skills (b)
Author: allsky 1. For use in the field more than the establishment of an independent record of the form 2. By a foreign key to link the value of these forms We will be url on the value of a separate table, so that we can in the future to include ...

9: Database design skills (c)
Author: allsky Definition of regularization in the form of a fourth former, I would like to mention the relationship between three basic data: one-on-one, one-to-many and many-to-many. We look back upon Regularization of the first users of a table...

10: SQL Language Quick Start (a)
SQL is Structured Query Language English acronym, which means for the Structured Query Language. SQL language is the main function of establishing ties with the various databases, for communication. In accordance with ANSI (American National Standar...

11: SQL Language Quick Start (b)
Create table SQL language is used to create table statement to create a new database table. Create table statements using the following format: create table tablename (column1 data type, column2 data type, column3 data type); If users want to ...

12: SQL Language Quick Start (c)
SQL language we use every day work process, or most frequently used database has been created from the query information. Next, we explain in detail how to use SQL database query language to achieve a variety of operations. SELECT ... FROM For the...

13: PHP call in the Access database through ADO
I read the article "How in PHP in the database through ADO and COM calls Asscess procedures" articles written by him, immediately made a test failed. Is sad. How do? I had no choice but to seek help from the official website of PHP,pays o...

14: Database design paradigm
Relational database design is to comply with certain rules. Database design paradigm in particular, will now briefly introduce the 1NF (First Normal Form), 2NF (Second Normal Form), 3NF (Third Normal Form) and BCNF, otherwise the fourth and fifth pa...

15: MySQL query optimization approach of the page
Author: steeven It seems that people rarely discuss the page, are we all obsessed with limit m, n? In the case of the index, limit m, n the speed enough, but a search in the complex conditions, where somthing order by somefield + somefield mysql...

16: PHP class library ADOdb introduced in (a)
Preface Why use a database class library? Beginners (and even some non-beginners) mistakes often is in the development of applications, the lack of consideration for the future. If one day, you need to use other procedures for the database, do you...

17: A section of php code: backup and restore sql database (sql text support, zip...)
PHP code :----------------------------------------------- --------------------------------- <? php require ( 'includes / application_top.php'); if ($ HTTP_GET_VARS [ 'action']) ( switch ($ HTTP_GET_VARS [ 'action']) ( ...

18: Php + mysql to deal with large-capacity data storage
PHP in a forum to see such a post, paste it into the index will be the answer here so that everyone take a look at, I hope all of you help quote: -------------------------------------------------- ------------------------------ When the databases...

19: Press Release Procedure (multi-user), with code ~
Issued a press release program, to help find a good top. Name: Star Fire Press Release System System features: 1. Multi-user management 2. Ease of use, visit the Windows desktop programs to sort the table, anti-selection, multi-level forms. The ...

20: Found a pile of garbage characters ~
PHP code :----------------------------------------------- --------------------------------- <? php function HeighPHPcode ($ Heightstring) ( do ( $ z = 0; if (preg_match ( '/ <phpcode> (.*?)</ phpcode> / s', $ Heightstring...


Page 1 of 7
[1]   [2]   [3]   [4]   [5]   [6]   [7]