INSERT – Daten einfügenMit SELECT k

INSERT – Daten einfügen

Mit SELECT können wir Werte aus der Datenbank selektieren und zum eintragen nutzen wir INSERT. Als erstes möchten wir einen weiteren Kunden in unsere Datenbank eintragen:

?
1
2
3
4
5
6
7

ผลลัพธ์ (อังกฤษ) 1:

INSERT - insert dataWe can select values from the database with SELECT, and the enter we use INSERT. First, we want to enter another customer in our database:?1234567 Connect to the database mysql_connect ("localhost", "Username", "Password") or the ("unable to connect"); mysql_select_db("Datenbank-name") or the ('database does not exist"); $result = mysql_query("INSERT INTO kunden (name, adresse) VALUES ('Hans Meier', 'Wuppernweg 19')");?>Actually everything as usual, the part in "mysql_query()" now instead of just a SELECT is an INSERT. Let's look more closely at the SQL command:?1INSERT INTO customers (name, address) VALUES ('Hans Meier', 'Wuppernweg 19')INSERT INTO customers - in which table should what are entered(name, address) - the order of the columns, such as the values to be entered. You can arrange that themselves as you like, but basically I'm on the order that the table has.VALUES ('Hans Meier', ' Wuppernweg 19′)-here come the values that should be entered. While the order depends on the order in which you previously set. Strings are generally put in quotes, numbers don't (unless you want to save the number as a string)Run the script times out (eighth to the correct connection data) and you should find a 3 record in your table 'customers'.INSERT variable

ผลลัพธ์ (อังกฤษ) 2:

Insert Data - INSERT with SELECT, we can select values ​​from the database and to register, we use INSERT. First, we want to add another customer in our database: ? 1 2 3 4 5 6 7 // establish connection to the database mysql_connect ("localhost", "username", "password") or ("not connect") which; mysql_select_db ("Database Name") or die ("database does not exist"); $ result = mysql_query ("INSERT INTO Customers (Name, Address) VALUES ('Hans Meier', 'Wuppernweg 19')"); ?> Actually, everything as usual, only the part in "mysql_query" now instead of SELECT's is an INSERT. Let's look at the SQL command closer look at: ? 1 INSERT INTO Customers (Name, Address) VALUES ('Hans Meier', 'Wuppernweg 19') INSERT INTO customer - in which table is entered which are (name, address) - the order of columns, as the values ​​are entered. One can arranging as you like, but I consider myself basically to the order, which has the table. VALUES ('Hans Meier', 'Wuppernweg 19') - now here come the values ​​to be entered. The order depends on the order that you set in advance. Strings are generally taken in inverted commas, numbers do not (unless you want to save the number as a String) Execute the script times out (pay attention to the correct connection data) and you should have a third record in your table "clients" find. INSERT with variables

ผลลัพธ์ (อังกฤษ) 3:

Insert - - - - - data we can insert

With Select values from the database and select the entries we use insert. The first thing we want to do another customer in our database entries:

?
1
2
3
4
5
6
7
< ?php
//Connect to the database
mysql_connect( "localhost", "username" , "password") or die ( "Unable to connect" ) ;