473,407 Members | 2,359 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,407 software developers and data experts.

PHPMyAdmin slashes added to code

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
added. As early as line 3 the code should read default '0' but instead
reads default \'0\'

Anybody tel me why this is happening?
Somebody suggested that I should look at the magic slashes option in
the php.ini but I don't know what settings should be on and what
should be off!
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\\\\\\\\\\\\\\\';

Jul 17 '05 #1
1 2472
Graham Thomson wrote:
Anybody tel me why this is happening?


Set:
magic_quotes_gpc = Off

--
Sugapablo
------------------------------------
http://www.sugapablo.com <--music
http://www.sugapablo.net <--personal

Jul 17 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: FreeStyle | last post by:
Hi everybody, I'm using phpMyAdmin 2.2.6 with EasyPHP v.1.6.0.0 I wrote a php script which uses a username (added in the mysql base with phpMyAdmin). This user has no privileges. But in the...
0
by: ghasem | last post by:
Dear all, Hello to all the great minds of php. My humble question is regarding the phpmyadmin. As you know the welcome screen of phpmyadmin allows one to choose the language. My question is this:...
1
by: lawrence | last post by:
I tried to open an entry using phpMyAdmin and I got the following url. Not surprisingly, my web server through an error (414- Request-URI Too Large) and complained that the URI is too long for the...
10
by: Carlos Ribeiro | last post by:
Hello all. I'm sending this to the list because I would like to know if someone else has ever stumbled across this one, and also because one possible solution is to patch, or simply "decorate",...
4
by: bdwise | last post by:
I have a textbox in a form, and I need to allow users to enter dates in US Format (MM/DD/YYYY). But they do not want to type any slashes, just 8 numbers, and have the slashes added for them. ...
2
by: Christian Hansen | last post by:
Can phpMyAdmin be used to manage databases that are not local?
2
by: hph | last post by:
Please be gentle; I am a relative newbie for php/MySQL, and most of what I am doing is based on being self-taught using someone else's well-written code, and my own googling the answers to my...
0
by: NewbieSupreme | last post by:
I'm using PHPMyAdmin on an Apache2Triad install (latest version; 5.x.x, which installs PHP5 and PHPMyAdmin 2.8 as well). In Access, I exported a table to a text file, tab-delimited, text qualifyer...
2
by: seanh | last post by:
Hi all, I need some advice regarding phpmyadmin, I installed phpmyadmin directory in the htdocs but when I go to my http://mysite.com/phpmyadmin I get a 500 internal error. I checked the files...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.