Update Mysql.user set Password=old_password (' New password ') where user= ' username '
Note that this old_password (MySQL function) encrypts the password to 16 bits, but not the
Password () This function, otherwise it will be encrypted into 40 bits.
Use the PHP5 on your own computer.
PHP4 on the server.
On your own machine time, 2008-2-14 14:56:29
Write a good program and turn it into a bunch of numbers. 1202972189
Database with access: Field default value Now ()
Workaround:
This is no
While Ajax supports UTF8
OK, first add a header to the PHP page ("content-type:text/html; Charset=utf-8″);
The code that tells the page this implementation is UTF-8
Then the content to be output with $test = Iconv (' GBK ', ' utf-8′, $test); turn
I use textarea to submit a large amount of data
I started the field type selected is Mediumtext, the data has been lost
Later I changed to Longtext, the data is still lost,
And the amount of data that is found and Mediumtext committed to the
In the PHP documentation, just mention echo can output a multiline string with the following command (and the variables are automatically replaced):
PHP code
Copy CodeThe code is as follows:
Echo
This uses the ' Here Document ' syntax to output
Grammar:
Group_concat ([DISTINCT] expr [, expr ...] [ORDER by {unsigned_integer | col_name | expr}[asc | DESC] [, col_name ...] [SEPARATOR Str_val])
Here is a demonstration of this function, first set up a student to select the curriculum
Copy CodeThe code is as follows:
/*
mysql_pager.class.php
Three parameters. mysql_query () result, URL variable page, number of records per page you want
Example at the bottom of this file
Freshwater River side Finishing test
*/
Class Mysql_pager
I summed up some fart experience
1. After the Ajax post data to the background page, and then to reconnect the database, do not think that the previous session is connected to the
2. In order to deal with the problem of return garbled, I added the
Like this page.
Http://www.jb51.net/soft.php/1,100,8630.html
The script that is actually processed is the soft.php parameter of 1,100,8630
The equivalent of soft.php?a=1&b=1=100&c=8630 only such URLs are too difficult to remember. Search engines
First, the use of relevant technology keywords: PHP, Apache,
Mod_rewrite (rewritecond,rewriterule) address rewriting,
OB series function buffers
File_put_contents Generating HTML
Second, the process: the user issued a request url?id=x, determine
Regular expressions
There are two sets of regular expression libraries in PHP, which are functionally similar, but with slightly different execution efficiency:
The set is provided by the Pcre (Perl Compatible Regular Expression) library. A
Same as 10 data
SELECT * FROM Yanxue8_visit limit 10000,10
And
SELECT * FROM Yanxue8_visit limit 0,10
is not a level of quantity.
There are also many five optimization criteria for limit, which are translated from MySQL manual, although correct but
Problem
How can you easily and conveniently build such "complex" objects that do not need to paste the copy in the operation?
Workaround
Build a factory (a function or a class method) to create a new object. In order to understand the utility of
Copy CodeThe code is as follows:
$myServer = "localhost"; Host
$myUser = "sa"; User name
$myPass = "password"; Password
$myDB = "Northwind";? MSSQL Library Name
$s = @mssql_connect ($myServer, $myUser, $myPass)
Or Die ("couldn-t connect to SQL
Myiasm is a new version of the Iasm table, with the following extensions:
Portability at the binary level.
NULL column index.
There is less fragmentation than the ISAM table for variable-length rows.
Support for large files.
Better index compression.
Magpierss in the use of Snoopy, which makes me a bit interested to study this boom. On the SF, the source code was found. Incredibly is a class, but do not laugh at Oh, the function is very powerful.
The official profile, I translated the next
First, the basic principle
Consider intercepting PHP to read the source file interface. At first, I considered processing from the interface between Apache and PHP, see Apache's src/modules/php4/mod_php4.c (this is the file that PHP compiles into
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