CopyCode The Code is as follows: Class dB {
VaR $ host_addr = "localhost ";
VaR $ host_user = "root ";
VaR $ host_psw = "123 ";
VaR $ db_name = "test ";
VaR $ link_id;VaR $ query_id;VaR $ numrow;
Function dB (){$ This-> link_id = @
Since I had some knowledge of PHP and MySQL, I have been very keen on my company's huge Excel database and want to secretly "share" the confidential commercial data, while thinking about how to get it, thinking about how to convert it into a MySQL
Hello everyone! I haven't seen anyone for a long time. The last time I wrote a PHP chat room through file operations, of course, it was full of loopholes, and every time I refreshed the screen, it was terrible! I have been thinking for a long time.
Due to the shortage of MySQL resources in China, it is neither too slow nor open to Chinese users. Therefore, in the days without MySQL, it is more difficult for us to do something that is convenient for others and improve our websites. To get rid
1. System Architecture:
The modular concept is divided into three layers:
A. Data storage layer: MySQL is used to store all BBS data, including user information,
Article Data, user mail, user message, system data (?), Key issues:
Database
You should have a better understanding of HTML forms. The following section
Code Is a simple HTML form:
Last name:
Name:
After you enter the data and press the submit button, this form will send the data to
This file is/tmp/phpbeojq5.
################ You can copy this code to test ################ #
Include ("include/dbclass. Inc"); // Replace the test with MySQL. Inc.$ Q = new db_ SQL;
$ Db = $ q-> database; // define the databaseMysql_connect (
1. $ ROW = mysql_fetch_row ($ result );
Returns a regular array $ row. $ row [0] is the first element, $ row [1] is the second element, and so on...
The number of elements returned by mysql_num_fields ($ result.
2. $ ROW = mysql_fetch_array ($
When using mysql, you sometimes need to query records with unique fields. Although mysql provides the keyword distinct to filter out redundant duplicate records, only one record is retained, but it is often used to return the number of records that
I. data definition language)
A document language is a language defined for the format and form of a document. It is the first thing that every database needs to create, the table relationships, column primary keys in the table, and the reference
Example I wrote
Copy codeThe Code is as follows: Require ("adodb/adodb. inc. php ");
$ Conn = newadoconnection ('mysql ');
$ Conn-> connect ("localhost", "root", "2027205", "bh38") or die ("connection failed ");
$ Conn-> execute ("set names gb2312 ")
In WINXP, APACHE2.052-win32 + php4.39-win32 + mysql4.022 is configured through
Apache, php4, and mysql can be accessed online,
I just wrote my own experiences for you to share.
(1) apache configuration
1. Install APACHE_2.0.52-win32, the default
I. SQL Quick Start
The following is an important quick reference for SQL. For SQL syntax and features added to standard SQL, please query the MySQL manual.
1. Create a table
A table is one of the most basic elements of a database. Tables and tables
Skip this step if you are completely new to the installation.
Find the ragnarok database directory under your Mysql database directory, for example, install Mysql inUnder the D: \ mysql directory, find the ragnarok database directory under the D: \
Unlimited classification is mainly implemented by storing the id and path of the upper-level classification. Because the structure of the data is simple, to display the classification relationship in a tree, I can only think of Recursive
System Configuration: win2000 English version + JDK1.4.1 + TOMCAT4.0.5 + APACHE2.043
Development cycle: the development cycle lasts for nearly 15 days.
Functions:
1. Gallery:
Submit, display, and delete images and related text by page.
2.
######################################## #######
This article is original. If it is referenced, please indicate the author's information.
Author: Cool-hearted madman
Email: edincur@yeah.net
Http://safebase.yeah.net
###################################
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service