Why can t I write to the database? An additional 100 points will be added for correct answers

It is possible that the database has been corrupted, and if the write is in the form of update, it will be updated according to a certain field in the database, and the field cannot be found, and the write will be shown as successful.

In this case, it is estimated that the database data is more likely to be corrupted. If it's a program issue, it won't show that the write was successful.

It is recommended that you reorganize your database.

Check out your feed**! See if there is an error in the statement written to the database!

Has the directory of your database connection file changed? Or the directory of your app files, right?

Check the database logs first, and you can usually find the reason.

Check to see if there's any space available.

It is related to the database encoding, and the following settings are used:

mysqld]

default-character-set=utf8

Then mysql>show character set; Check the database code to see if it is consistent with the following.

character_set_server = utf8

character_set_system = utf8

character_set_database = utf8

character_set_client = utf8

character_set_connection = utf8

character_set_results = utf8

collation_connection = utf8_general_ci

collation_database = utf8_general_ci

collation_server = utf8_general_ci

If it is a character encoding for a single field:

mysql>alter database testdb character set utf8;

All places should be coded uniformly.

The database, as well as the database link, should be set to utf8

The content-type of your page is also set to utf-8, and the file encoding should also be saved as utf8.

Your statement must also be encoded in UTF8, it's as simple as that.

Find out if there is an online course in the database.

The kernel of your phone is not very good, the record is put in the transfer station first, you need to cache it, and you can do it after a while. If you want to see it directly, open the chat interface with others and click on the chat history, so that you can also see it at the transit station.

It's in the phone's memory, and it should be seen after exiting QQ.

I don't know what you mean, if you read something out of the database, how can there be something that doesn't include it!!

If you read from the database, write it in a for loop!

string sql="insert into dzsw(name，number,price) values('"name+"'The orange trail is clear'"number+"'price+"'

Could it be that there is a problem with the field settings in your database?

See if there's a problem with these settings. The insert field type must be the same as the field type in your database.

Not yours; I didn't print the state chain either.

Is it only the last two generations?

It's easy to update only two generations, add 20 amounts to the referrer and 10 to the referrer, using the following statement (let's say the table name is tab, and you use it instead of your table name):

id='05';

jine=100;

Add my mysql query("update tab set jine=jine+$jine where id='$id'")

Add the parent mysql query("update tab set jine=jine+$jine* where id in (select tuijian from tab where id='$id')"

Plus grandpa mysql query("update tab set jine=jine+$jine* where id in (select tuijian from tab where id in (select tuijian from tab where id='$id'))

Commission rate. The first level commission is 100, and the second level commission is 100*

ratiomap = array (

Maximum Score Level.

Up to 3 levels of commission.

maxlevel = 3;

functions.

Recursive commissions. function give_levelmoney($id, $level=1) {

global $ratiomap, $maxlevel;

if ($level > maxlevel) {

If the target level has exceeded the maximum level, exit recursion.

return;

Read the information of the $id.

info = get_levelinfo($id);

Achieve a target level of commission rate.

ratio = ratiomap[$level];

Calculate the amount of the commission.

addmoney = info['jine'] ratio;

Give users commissions.

add_money($id, $addmoney);

Increase the level. level++;

Recursive invocation to handle the referrer's commission.

give_levelmoney($info['tuijian'],level);

Obtain the data corresponding to the $id.

function get_levelinfo($id) {

In this case, you need to query the data of the corresponding ID from the DB.

You need to make it happen.

return array (

id' =id,tuijian'=tuijianid, referrer ID

jine'=jine amount.

Add money for $id users.

function add_money($id, $addmoney) {

Here you need to write db to add $addmoney to the user whose id is $id

You need to make it happen.

tests method.

id = 05';

give_levelmoney($id);

Please complete the db function first, and then follow my method to call:

id = 05';

give_levelmoney($id);

In this way, the program will first add 100 * 1 money to 05, then find his recommender 02 and add 100 * money to 02...

After doing 04 all the way, the maximum level is exceeded, and the function is exited.

The longer the function, the more efficient the execution; The shorter the function, the slower the execution.

cyy1997 Yuanyuan children, hello:

1. There are several reasons why the stone slowly rots: the dissolution of water dissolves some substances in the stone; The substances in the air react chemically with the substances in the stones. Ice slag and other supporting effects on stones. In a nutshell, weathering.

2. Moisture, carbon dioxide, low temperatures, cold and hot temperature changes, plants, organisms and their corpses (do not be specific ways, those are just methods and means of attack).

3. Demonstrate that stones do rot; At the same time, it also captures the reader's interest with these vivid examples.

4, this is a double negative sentence, in order to emphasize the meaning, it is expressed as, the weathering effect is very strong, and the stone will rot under its action.

1."Weathering" attacks. 2.

Saboteurs have moist air, cold weather, changes in hot and cold, etc. Attack: Water combines oxygen and carbon dioxide to dissolve some of the substances in the stone; In winter, the water leaking into the gap freezes into countless Xiaoice ballast, and the water freezes into ice, and the volume increases, so that the gap becomes larger and larger, making the stone statue more loose; With the change of climate, the stone will expand and contract, and as the days go by, the stone will be pulled and broken.

weathering" is so powerful that the stones will "rot".

1. The reason why the stone slowly rots is due to weathering.

2. Moisture, carbon dioxide, low temperature, cold and hot temperature changes, plants, organisms and their corpses 3. Examples of stones will rot.

4. Stones, which are not easily damaged, will also deteriorate under the "weathering", and other things will also deteriorate under the corresponding "weathering".

Answer: 1. "Weathering".

2. Wind, moisture, biological action, temperature, chemical action.

3. Give examples.

4. The power of weathering is immeasurable.

What database is used? What are the symptoms?

。。。Do you still have a database on your machine?

You add an administrator to the database and then upload the database to the server for an overwrite.