Wednesday, November 29, 2006

2004 Suburban Tire Air Pressure



transactions to work with php and mysql in xampp environment, you must enable support for innodb database, we achieve this by modifying my.cnf of mysql. This file is located in the following location:

Linux:
/ opt / lampp / etc / my.cnf Windows

C: \\ apachefriends \\ xampp \\ mysql \\ bin \\ my.cnf
or
C: \\ Program Files \\ xampp \\ mysql \\ bin \\ my.cnf
default installation locations.

The comment must file the following line
skip-innodb and uncomment the following
# innodb_data_home_dir = C: / apachefriends / xampp / mysql /
# innodb_data_file_path = ibdata1: 10M: autoextend
# innodb_log_group_home_dir = C: / apachefriends / xampp / mysql /
# innodb_log_arch_dir = C: / apachefriends / xampp / mysql /
recorded and then restart the service.

Floral Gym Leotard 80-90s



* Heavy Metal Radio

What Does A Cervix Feel Like Before A Period

Music Sports

classic * After

* The fall theater

* Barcelona is complicated

Why Do Men Grow Their Pinky Nails

GNU / Linux

* Even more spectacular

* new in desktop XGL

* Ubuntu Edgy Eft Released

Wedding Invitation Email To Friends



* PHP and MySQL Transactions


* Enabling INNODB in XAMMP


* Time Problem PHP incorrect

Phoenix Ski Jacket Ny

Transactions Programming PHP and MySQL

This is nothing new, but I'd post it here because I just served and these are two tools widely used worldwide.

First of all we need servers (php and mysql) pre-installed. Then we need to enable INNODB support in mysql, see this post .

is important to know that transactions are supported only for innodb type tables, so we need to create or modify tables with this type. This is easily accomplished with the attribute ENGINE = INNODB.

Here is the code to do so.
Create: CREATE TABLE
table ... ENGINE = INNODB;
Edit:
ALTER TABLE table ENGINE = INNODB;
No worries with the data in the amendment because it does not show any changes.

then already in the php code will have something like the following:

$ SERVER = "TuHost"
$ BASE_DATOS = "TuBaseDeDatos"
$ USER = "TuUsuario"
$ PASSWORD = "TuPassword"

$ db = mysql_connect ($ SERVER, $ USER, $ PASSWORD);
mysql_select_db ($ BASE_DATOS, $ db);

$ error = 0, / / \u200b\u200bvariable to detect error

mysql_query ("BEGIN") / / Transaction start

$ result = mysql_query ("INSERT INTO table1 VALUES (1.1000)");

if (! $ Result)
$ error = 1;

$ result = mysql_query ("INSERT INTO table2 VALUES (1.2000)");

if (! $ Result)
$ error = 1;

if ($ error) {
mysql_query ("ROLLBACK");
echo "failed transaction"

} else {mysql_query ("COMMIT");
echo "Transaction successful";}

The code

previous 2 insertions are to be undertaken (COMMIT) if any error occurs in both, otherwise it will return their previous values \u200b\u200b(ROLLBACK).

Well I hope they serve and if you have any questions you know, put comment.

Saturday, November 25, 2006

How To Change Your Email On The Sims 3.com

Even more spectacular

For those who thought that was enough XGL with Compiz, here I leave you again with Beryl 3D flying

And if a video is not enough to convince you here 's another

And after this muestrita who want to move to Windows Vista hahaha.

Saturday, November 11, 2006

How Much Calories Can I Burn With A Sauna Suit

XGL desktop

For those who are not yet seen the xgl system here I leave a demo that shows the progress that Linux has had in its graphical interface.

Sunday, November 5, 2006

The Discus Thrower And Greek Values

new in the theater was falling

After
the good results of Real Madrid in the previous days with a game very doubtful and fortune, becomes visible good football crisis being experienced by the team. Celta Vigo (until then tenth in the table) won in his home leaving him in fourth place with the Valencia