PHP

Source: http: wwwfelix021comblogreadphp? 2102 yesterday @ Zind found my previous blog (modified), which mentioned mysql_ping and MYSQL_OPT_RECONNECT. The reason for writing that blog is because some code written last year met Source:

Provide mysql database tutorials, commands, installation and other technical summaries: When a user entered a fullwidth mobile phone number during registration, the text message system failed to send the text message based on the mobile phone field.

In layman's terms, a transaction refers to a group of operations, either successfully executed or not executed-atomicity before all operations are completed, other sessions won't be able to see the process of intermediate changes-the total amount of

The background is that a service's logdb history oss_log (MyISAM table type) is routinely deleted, and sometimes deadlock is reported. It takes a long time to delete slowlog analysis. for example, it takes 150412410 seconds to delete droptable2014_10

A trigger is a special type of transaction that can monitor a certain data operation (insertupdatedelete) and trigger related operations (insertupdatedelete ). Take a look at the following events: the logic of Insertintoo (gid, num) values (2, 3) to

For mysql stored procedures and event creation, the following stored procedures mainly implement the function of querying the data in the table half a year ago. if any, the data is saved to the file and deleted. CREATEDEFINER 'root' @ 'localhost'

-- View all character encoding SHOWCHARACTERSET; -- view the instructions for creating a database and the database encoding showcreatedatabasedbtest; -- view the database encoding: showvariableslike % char %; -- set char -- View all character codes

Sometimes it is really uncomfortable to suddenly forget the MySQL password. here is a method to reset the password when the MySQL password is forgotten. in the operating system win8, MySqlversion: 56101, close mysqlexe in the task manager, mysqldexe

1. install and install mysqlconnector2. configure mysqlconnectorODBC Data Manager-system DSN-add-mysqlODBC53ANSIdriver-enter cename such as jt, mysql ip address, user name, and password. 3. create a new connection server execsp_add 1. install and

Syntax: Delete a TABLE DROPTABLESyntaxDROP [TEMPORARY] TABLE [IFEXISTS] tbl_name [, tbl_name] [RESTRICT | CASCADE] one or more tables can be deleted at a time. You must have the DROP permission on the table to be deleted. Table definition

ZendStudio3.0 was released recently. let's take a look at it and use it. zendStudio (ZDE), after all, can be called the best php ide. although it still has various shortcomings, you may say that I only use EditPlus. ZDE does not seem to have changed

& Lt ;? Php & nbsp; functiongetImageInfo ($ img) {$ img is the absolute path of the image file & nbsp; $ img_infogetimagesize ($ img); & nbsp; switch ($ img_info [2]) {& nbsp; case1: & nbsp; $ imgtype & quot; GIF & quot; & nbsp; break; & nbs

There are many string operations in PHP. The following are important: (1) the first two functions of echo, print, printf, and sprintf are output strings. if there is a variable name in the string, it is replaced with its value. the last two

1. while loop in this lesson, we will continue to use PHP and MySQL to write some simple and useful pages. We started to display the data in the database from the database we created yesterday, but it will be slightly improved. First, we use the

Recently, by chance, and my friends found that the naming rules for php are [a-zA-Z_x7f-xff] [a-zA-Z0-9_x7f-xff] * that is, a to z, and A to Z, and _, and 0x7f to 0xff characters are supported by naming rules, that is, in php programs, you can

The introduction of COM functions built into PHP4 is quite attractive for developing programs in win32 environment, but there are still few related technical documents. This article uses three examples to process MSoffice2000Word, Excel, and

I just browsed a Class-related article updated on the homepage in the project. it is very good. I suggest you look at it: www.phpe.netarticles389.shtml's exploration of the Class ~~ It took me half a year to understand the role and implementation of

In general, the Template engine is a good thing as a PHP Perl programmer. many Template engines (fastTemplate, Smarty, Perl HTML: Template) users, as well as my own (author of bTemplate [1]), I have spoken this sentence many times. However, after a

? * ** File database function * conventions: * The database name is the same name directory * the data table name suffix is tab * the index file suffix is ind * The Management file name is the database name Directory manage. ini * remarks fields

The object-oriented function in PHP supports the C ++ formula: Operator number !!! Lone Wolf: this: it appears frequently in PEAR. I am confused when I first saw it. this special document does not have any instructions, but it has great value for