> -----Original Message----- > From: Alexis [mailto:phplists1@xxxxxxxxxxxxxxx] > Sent: Sunday, October 17, 2010 4:10 AM > To: php-general@xxxxxxxxxxxxx > Subject: Re: Questions from a Newbie > > Ethan,you have the end of line semi colons enclosed in double > quotes..move them to the true end of line. > Even if he does move the semicolons to outside the quote, it doesn't do what he intended as maintaining the database. His code merely echo the SQL syntax for viewing and not actually executing the SQL syntax, which is what I think he intended. In which case, he's better off using phpMyAdmin. Regards, Tommy > On 17/10/10 04:45, Christian Heinrich wrote: > > Am Sonntag, den 17.10.2010, 01:00 -0400 schrieb Ethan Rosenberg: > >> Dear List - > >> > >> Here are some questions, which I am sure are trivial, but I am a > >> newbie, and cannot find the answers online.... > >> > >> I cannot get the following to work. In my Firefox [Iceweasel] > >> browser, I enter the following URL: [w/ the http] > >> > >> localhost/CreateNew.php All I get is a blank browser screen. > >> > >> The code contained in the file CreateNew.php is: > >> > >> /* > >> * Create Database test22 > >> */ > >> <html><body> > >> <?php > >> $cxn = mysqli_connect("$host",$user,$password); > >> echo "Create database test22;" > >> echo "Create table Names2 > >> ( > >> RecordNum Int(11) Primary Key Not null default=10000 > auto_increment, > >> FirstName varchar(10), > >> LastName varchar(10), > >> Height decimal(4,1), > >> Weight0 decimal(4,1), > >> BMI decimal(3,1) > >> Date0 date > >> );" > >> > >> echo" Create table Visit2 > >> ( > >> Indx Int(7) Primary Key Not null auto_increment, > >> Weight decimal(4,1) not null, > >> StudyDate date not null, > >> RecordNum Int(11) > >> );" > >> > >> $sql= "SHOW DATABASES"; > >> ?> > >> </body></html> > >> > >> If I search for test22 or Visit2, nothing is found. > >> > >> I would also like to be able to add data to a table, using PHP, which > >> I can do in MySQL as: > >> load data infile '/home/ethan/Databases/tester21.dat.' replace into > >> table Names fields escaped by '\\' terminated by '\t' lines > >> terminated by '\n' ; > >> > >> Thanks in advance. > >> > >> Ethan > >> ======= > >> Using Debian(sid) > >> > >> > >> > > > > > > Hi, > > > > maybe you also want to take a look at PDO - http://php.net/pdo > > > > Regards > > Christian > > > > > > -- > PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: > http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
