Script.gr - PHP Scripts, HowTos and Tutorials

• Example 1 • Example 2 • Example 3 • Example 4

First, lets assume that you have a database with the following table and rows installed:


# 0: <?

# 1: ----------------------------------------------------------

# 2: CREATE TABLE ADDRESSES (

# 3:   ID int(11) NOT NULL auto_increment,

# 4:   Name varchar(12) NOT NULL default '',

# 5:   Phone varchar(20) NOT NULL default '',

# 6:   MODIFIED timestamp(14) NOT NULL,

# 7:   CREATED timestamp(14) NOT NULL default '00000000000000',

# 8:   PRIMARY KEY  (ID)

# 9: ) ;


#11: INSERT INTO ADDRESSES VALUES (1,'John', '28877112', '20050814180607', '00000000000000');

#12: INSERT INTO ADDRESSES VALUES (2, 'Jill', '4785521', '20050814180607', '00000000000000');

#13: INSERT INTO ADDRESSES VALUES (3, 'My dog', '04487 445512', '20050814180607', '00000000000000');

#14: ----------------------------------------------------------

Example 1

Example 1
This creates an insert statement and selects it afterwards. Program File # 1: <?php # 2: require_once("../fastsql.inc"); # 3: define("G_HOST", "localhost"); # 4: define("G_DBUSER", "MyUsername"); # 5: define("G_DBPWD", "MyPassword"); # 6: define("G_NORMDB", "MyDB"); # 7: # 8: $conn = new FastSQL; # 9: $insert = "insert into ADDRESSES (Name, Phone, CREATED) #10: values('Willy','666 777 443', NOW())"; #11: #12: $insert_id = $conn->insert($insert, G_NORMDB); #13: #14: $select = "select * from ADDRESSES where ID=" . intval($insert_id); #15: #16: $res = $conn->single($select, G_NORMDB); #17: #18: print "<pre>;"; #19: print "The new ID is $insert_id\n"; #20: print_r($res); #21: print "</pre>"; #22: #23: #24: ?> #25: The result will look like this `# 0: <? # 1: The new ID is 4 # 2: Array # 3: ( # 4: [ID] => 4 # 5: [Name] => Willy # 6: [Phone] => 666 777 443 # 7: [CREATED] => 20050814185937 # 8: [MODIFIED] => 20050814185937 # 9: )` As you can see we are dealing with regular sql statements. FastSQL doen't take this away from you. as long as you don't do very sophisticated stuff you will use standard SQL hopefully so the code will still be portable. Please note that in order for `#0: <? #1: $insert_id = $conn->;insert($insert, G_NORMDB);` to output an identifier you must have a unique key in your table, best an auto-increment field. Important: If the parser does not find a parameter that matches a given tag this tag will be stripped.

This creates an insert statement and selects it afterwards. Program File


# 1: <?php 

# 2: require_once("../fastsql.inc");

# 3: define("G_HOST", "localhost");

# 4: define("G_DBUSER", "MyUsername");

# 5: define("G_DBPWD", "MyPassword");

# 6: define("G_NORMDB", "MyDB");

# 7: 

# 8: $conn = new FastSQL;

# 9: $insert = "insert into ADDRESSES (Name, Phone, CREATED) 

#10:   values('Willy','666 777 443', NOW())";

#11: 

#12: $insert_id = $conn-&gt;insert($insert, G_NORMDB);

#13: 

#14: $select = "select * from ADDRESSES where ID=" . intval($insert_id);

#15: 

#16: $res = $conn-&gt;single($select, G_NORMDB);

#17: 

#18: print "<pre>;";

#19: print "The new ID is $insert_id\n";

#20: print_r($res);

#21: print "</pre>";

#22: 

#23: 

#24: ?>

#25:

The result will look like this


# 0: <?

# 1: The new ID is 4

# 2: Array

# 3: (

# 4:     [ID] => 4

# 5:     [Name] => Willy

# 6:     [Phone] => 666 777 443

# 7:     [CREATED] => 20050814185937

# 8:     [MODIFIED] => 20050814185937

# 9: )

As you can see we are dealing with regular sql statements. FastSQL doen't take this away from you.
as long as you don't do very sophisticated stuff you will use standard SQL hopefully so the code will still be portable.

Please note that in order for #0: <? #1: $insert_id = $conn->;insert($insert, G_NORMDB); to output an identifier you must have a unique key in your table, best an auto-increment field. Important:
If the parser does not find a parameter that matches a given tag this tag will be stripped.

• Example 1 • Example 2 • Example 3 • Example 4

PixHound
Simple Template Parser
FastSQL
Simple Backup
Landshop Real estate system

PHP on the Command line

.GR - Domains for you

No residence restrictions - anybody can register

Registration starting at € 16,33 / year

Web Hosting incl. .gr-Domain from € 8,90 / month

My Sites

Animalcaresamos.com
Our animale care project on the island of Samos, Greece
Samos-Hotels.com
Hotel directory for Samos
Samosinfo.gr
Samos information Server
Samedia.gr
Our company, Samedia O.E.
Gotohellas.de
Information on migrating to/living in Greece. German only