Re: why do this not create a database?

From: Dicki Smits (dicki_at_absoluut.org)
Date: 10/03/04 

Date: 2 Oct 2004 23:29:50 -0700

Paul thanks for your great help!!!

i was wondering do i have to connect each time, now i learn it is not nesecary.
But is it needed to close the connection?
And how do i do that.

Even your example learn me that you can do things on differend ways.

Thanks....
from holland

"Paul Barfoot" <Paul@theglobalfamily.fsworld.co.uk> wrote in message news:<cjmjhf$jk$1@news5.svr.pol.co.uk>...
> Hi Dicki
>
> Your code does create the table - it is your INSERT queries that are wrong.
> They should read INSERT INTO not INSERT TO.
>
> Here is my version of what you are trying to achieve with a few pointers:
>
> <html>
> <title>hello world</title>
>
> <body>
>
> <?php
>
> $host = "localhost";
> $user = "root";
> $pswd = "";
>
> /* only need to connect and select database once */
> mysql_connect($host,$user,$pswd) or die(mysql_error());
> mysql_select_db ("project");
>
> /* code to delete the current version of the nieuws table */
> mysql_query ("DROP TABLE IF EXISTS nieuws");
>
> /* Note date field should have used DATE type */
> mysql_query ("CREATE TABLE IF NOT EXISTS nieuws ( id integer, title
> varchar(255), date DATE, text blob)");
>
> /* Note format of DATE type - YYYY/MM/DD or even YYYY-MM-DD */
> mysql_query ("INSERT INTO nieuws VALUES ( 1,'tweede
> cursus','2004/05/05','een nieuwe cursus...')");
>
> mysql_query ("INSERT INTO nieuws VALUES (2,'tweede cursus','2004/05/05','een
> nieuwe cursus...')");
>
> $result = mysql_query("SELECT * FROM nieuws WHERE id=1");
>
> /* code to display the contents of the last query as a table with field
> names as the table headers */
> $results=mysql_num_rows($result);
> if (!$results==0) {
> echo "<p>$results rows returned.</p>\n";
> echo "<table border=1>\n";
> // get column metadata for column headings
> echo "<tr>\n";
> $i = 0;
> while ($i < mysql_num_fields ($result)) {
> $meta = mysql_fetch_field ($result);
> if (!$meta) {
> echo "No information available<BR>\n";
> }
> echo "<td><b>$meta->name</b></td>\n";
> $i++;
> }
> echo "</tr>\n";
> while ($row = mysql_fetch_row ($result)) {
> echo "<tr>\n";
> foreach ($row as $value) {
> echo "<td>$value</td>\n";
> }
> echo "</tr>\n";
> }
> echo "</table>\n";
> mysql_free_result ($result);
> }
> ?>
> </body>
> </html>
>
> --
> Paul Barfoot
>
> "Dicki Smits" <dicki@absoluut.org> wrote in message
> news:ac5e367f.0410012334.22168a19@posting.google.com...
> >I am learning php-mysql but I typed the following into my notepad but
> > it seems not to work. The page will be shown correct in the brouwser
> > but it don't create a databse ????
> >
> > I use easyphp packet. php 4.3.3 ,mysql 4.0.15 . and apache 1.3.27
> >
> > any help would be great.
> > greatings Dicki Smits
> >
> > ****
> > <html>
> > <title>hello world</title>
> >
> > <body>
> >
> > <?php
> >
> > $host = "localhost";
> > $user = "root";
> > $pswd = "";
> >
> > mysql_connect($host,$user,$pswd) or die(mysql_error());
> > mysql_select_db ("fotoboek");
> > mysql_query ("create table nie1uws ( id integer,
> > title varchar(255),
> > date integer,
> > text blob)");
> >
> > mysql_connect($host,$user,$pswd) or die(mysql_error());
> > mysql_select_db ("fotoboek");
> > mysql_query ("INSERT TO nieuws values ( 1,
> > 'tweede cursus',
> > 5/5/2004,
> > 'een nieuwe cursus...')");
> >
> > mysql_query ("INSERT TO nieuws values (2,'tweede
> > cursus',5/5/2004,'een nieuwe cursus...')");
> > mysql_connect($host,$user,$pswd) or die(mysql_error());
> > mysql_select_db ("fotoboek");
> > $result = mysql_query("select * from nieuws where id=1");
> > echo $result
> >
> > ?>
> > Waarom zie ik niet dat er geen database is aangemaakt?
> > </body>
> > </html>

Quantcast