PHPMyAdmin adding backslashes

[Graham Thomson]

Hi,

I've recently started looking at PHP and MY SQL within Dreamweaver MX.

I'm usin PHPMyAdmin and put some example code from my tutorial book into it
and pressed "Go".

However, the code came out as it does below with a load of backslashes
aadded. As early as line 3 the code should read default '0' but instead
reads default \'0\'

Anybody tel me why this is happening?

Thanks
Graham

CREATE TABLE bookings (
ID tinyint(11) NOT NULL auto_increment,
roomID tinyint(11) NOT NULL default \'0\',
client ID tinyint(11) NOT NULL default \\\'0\\\',
startDate date NOT NULL default \\\'0000-00-00\\\\\\\',
endDate date NOT NULL default \\\'0000-00-00\\\',
adults int(11) NOT NULL default \\\'1\\\',
children int(11) NOT NULL default \\\'0\\\',
roomType varchar(30) NOT NULL default \\\'\\\',
roomOptions int(8) NOT NULL default \\\\\\\\\\\\\\\'0\\\\\\\\\\\\\\\',
networkConnection int(8) NOT NULL default \\\\\\\\\\\\\\\'0\\\\\\\\\\\\\\\',
PC int(8) NOT NULL default \\\\\\\\\\\\\\\'0\\\\\\\\\\\\\\\',
requirements varchar(250) NOT NULL default \\\\\\\\\\\\\\\'\\\\\\\\\\\\\\\',
PRIMARY KEY (ID)
) TYPE=MyISAM COMMENT=\\\\\\\\\\\\\\\'Room Booking Table\\\\\\\\\\\\\\\';

[Marcel]

"Graham Thomson" <gr************@hotmail.com> schreef in bericht
news:pC****************@news-binary.blueyonder.co.uk...

Hi,

I've recently started looking at PHP and MY SQL within Dreamweaver MX.

I'm usin PHPMyAdmin and put some example code from my tutorial book into it and pressed "Go".

However, the code came out as it does below with a load of backslashes
aadded. As early as line 3 the code should read default '0' but instead
reads default \'0\'

Anybody tel me why this is happening?

Thanks
Graham

CREATE TABLE bookings (
ID tinyint(11) NOT NULL auto_increment,
roomID tinyint(11) NOT NULL default \'0\',
client ID tinyint(11) NOT NULL default \\\'0\\\',
startDate date NOT NULL default \\\'0000-00-00\\\\\\\',
endDate date NOT NULL default \\\'0000-00-00\\\',
adults int(11) NOT NULL default \\\'1\\\',
children int(11) NOT NULL default \\\'0\\\',
roomType varchar(30) NOT NULL default \\\'\\\',
roomOptions int(8) NOT NULL default \\\\\\\\\\\\\\\'0\\\\\\\\\\\\\\\',
networkConnection int(8) NOT NULL default \\\\\\\\\\\\\\\'0\\\\\\\\\\\\\\\', PC int(8) NOT NULL default \\\\\\\\\\\\\\\'0\\\\\\\\\\\\\\\',
requirements varchar(250) NOT NULL default \\\\\\\\\\\\\\\'\\\\\\\\\\\\\\\', PRIMARY KEY (ID)
) TYPE=MyISAM COMMENT=\\\\\\\\\\\\\\\'Room Booking Table\\\\\\\\\\\\\\\';

Have a look at the magic_quotes option in php.ini .... this is causing the
backslashes...

Marcel

[Graham Thomson]

Sorry, I don't understand where do I find this magic_quotes in php.ini?

Thanks
Graham
"Marcel" <ne*********@hotentottententententoonstellingen.nl > wrote in
message news:3f**********************@news.versatel.net...

"Graham Thomson" <gr************@hotmail.com> schreef in bericht
news:pC****************@news-binary.blueyonder.co.uk...

Hi,

I've recently started looking at PHP and MY SQL within Dreamweaver MX.

I'm usin PHPMyAdmin and put some example code from my tutorial book into

it

and pressed "Go".

However, the code came out as it does below with a load of backslashes
aadded. As early as line 3 the code should read default '0' but instead
reads default \'0\'

Anybody tel me why this is happening?

Thanks
Graham

CREATE TABLE bookings (
ID tinyint(11) NOT NULL auto_increment,
roomID tinyint(11) NOT NULL default \'0\',
client ID tinyint(11) NOT NULL default \\\'0\\\',
startDate date NOT NULL default \\\'0000-00-00\\\\\\\',
endDate date NOT NULL default \\\'0000-00-00\\\',
adults int(11) NOT NULL default \\\'1\\\',
children int(11) NOT NULL default \\\'0\\\',
roomType varchar(30) NOT NULL default \\\'\\\',
roomOptions int(8) NOT NULL default \\\\\\\\\\\\\\\'0\\\\\\\\\\\\\\\',
networkConnection int(8) NOT NULL default

\\\\\\\\\\\\\\\'0\\\\\\\\\\\\\\\',

PC int(8) NOT NULL default \\\\\\\\\\\\\\\'0\\\\\\\\\\\\\\\',
requirements varchar(250) NOT NULL default

\\\\\\\\\\\\\\\'\\\\\\\\\\\\\\\',

PRIMARY KEY (ID)
) TYPE=MyISAM COMMENT=\\\\\\\\\\\\\\\'Room Booking Table\\\\\\\\\\\\\\\';

Have a look at the magic_quotes option in php.ini .... this is causing the
backslashes...

Marcel

[Graham Thomson]

Hi,

I'm not sure what parameters to change in Magic Quotes - can you advise
please?

; Magic quotes
;

; Magic quotes for incoming GET/POST/Cookie data.
magic_quotes_gpc = on

; Magic quotes for runtime-generated data, e.g. data from SQL, from exec(),
etc.
magic_quotes_runtime = Off

; Use Sybase-style magic quotes (escape ' with '' instead of \').
magic_quotes_sybase = off
"Marcel" <ne*********@hotentottententententoonstellingen.nl > wrote in
message news:3f**********************@news.versatel.net...

"Graham Thomson" <gr************@hotmail.com> schreef in bericht
news:pC****************@news-binary.blueyonder.co.uk...

Hi,

I've recently started looking at PHP and MY SQL within Dreamweaver MX.

I'm usin PHPMyAdmin and put some example code from my tutorial book into

it

and pressed "Go".

However, the code came out as it does below with a load of backslashes
aadded. As early as line 3 the code should read default '0' but instead
reads default \'0\'

Anybody tel me why this is happening?

Thanks
Graham

CREATE TABLE bookings (
ID tinyint(11) NOT NULL auto_increment,
roomID tinyint(11) NOT NULL default \'0\',
client ID tinyint(11) NOT NULL default \\\'0\\\',
startDate date NOT NULL default \\\'0000-00-00\\\\\\\',
endDate date NOT NULL default \\\'0000-00-00\\\',
adults int(11) NOT NULL default \\\'1\\\',
children int(11) NOT NULL default \\\'0\\\',
roomType varchar(30) NOT NULL default \\\'\\\',
roomOptions int(8) NOT NULL default \\\\\\\\\\\\\\\'0\\\\\\\\\\\\\\\',
networkConnection int(8) NOT NULL default

\\\\\\\\\\\\\\\'0\\\\\\\\\\\\\\\',

PC int(8) NOT NULL default \\\\\\\\\\\\\\\'0\\\\\\\\\\\\\\\',
requirements varchar(250) NOT NULL default

\\\\\\\\\\\\\\\'\\\\\\\\\\\\\\\',

PRIMARY KEY (ID)
) TYPE=MyISAM COMMENT=\\\\\\\\\\\\\\\'Room Booking Table\\\\\\\\\\\\\\\';

Have a look at the magic_quotes option in php.ini .... this is causing the
backslashes...

Marcel