|
|
Posted by mick white on 01/02/06 01:03
S.Williams wrote:
> I did save the changes and restarted apache. still to no avail... didn't
> work. so I proceeded w/the book. the first application example i created was
> a 'guestbook'. So i opened my MySQL command line client and entered my
> password. I then typed create database guestbook; at the prompt. it said
> query ok, 1 row affected.
> i next typed create table; and it said error 1054 (42000): You have an error
> in your SQL syntax; check the manual that corresponds to your MySQL server
> version for the right syntax to use near ' ' at line 1
>
> so i disregarded the error and kept going.. in which i typed use guestbook:
use guestbook;
Note the semi-colon, not a colon
Mick
> and it said error 1049 (42000): Unknown database 'guestbook:'
>
> yeah.. so i ignored that too.. lol. and kept going. i typed:
> create table guestbook
> -> (
> -> name varchar(40) null,
> -> location varchar(40) null,
> -> email varchar(40) null,
> -> url varchar(40) null,
> -> comments text null,
> -> )
> -> ;
>
> and it came up w/another error.. to no suprise.. it said Error 1046 (3D000):
> No database selected. so here is an idea of where i'm at and what i'm trying
> to do. but i think it is because of the PHP.. i dunno. help!
>
> Stephanie
> "Daemon" <d43m0n@shaw.ca> wrote in message news:rQWtf.99$tl.12@pd7tw3no...
>
>>S.Williams wrote:
>>
>>>Also I don't quite understand what PHP is?
>>>
>>>Stephanie
>>>
>>>
>>>"S.Williams" <s.williams2005@gmail.com> wrote in message
>>>news:%PStf.27829$Ou3.22181@dukeread09...
>>>
>>>
>>>>Hey guys,
>>>>
>>>>I was asked to learn SQL for my employer. The book I'm starting in said
>>>>that I would need; a web server(Apache), so that it can access the PHP
>>>>language. In addition, I would need MySQL installed and PHP has to be
>>>>able to recognize MySQL.
>>>>
>>>>So..
>>>>I downloaded :
>>>> apache_2.0.55-win32-x86-no_ssl (windows apache installer package)
>>>> mysql-essential-5.0.18-win32 (mySQL installer package)
>>>> php-5.1.1-installer (PHP installer package)
>>>>
>>>>
>>>>I installed apache i followed the directions exactly as on the site and
>>>>then tested it by typing http://localhost/ in to my browser and a page
>>>>came up that said it was installed.
>>>>
>>>>Then, I installed MySQL. Then it said to test that MySQL was working
>>>>properly I would then open MySQL Command Line Client, simply enter the
>>>>password, and if the client allows access with no errors, that MySQL
>>>>would be working properly. .. There were no errors.
>>>>
>>>>Lastly I installed the PHP. The instructions said that after installing
>>>>PHP that we would need to configure a few options to make PHP work. It
>>>>then said to edit the httpd.conf file. So i added these lines after the
>>>>last line of the config file:
>>>>
>>>>ScriptAlias /php/ "c:/server/php/"
>>>>AddType application/x-httpd-php .php
>>>>Action application/x-httpd-php "/php/php.exe"
>>>>
>>>>Next it said to create a file in htdocs folder called phpinfo.php.Then to
>>>>open the file and place the following code within it:
>>>>
>>>><?PHP phpinfo(); ?>
>>>>
>>>>Next to save and close the file then open IE and type
>>>>http://localhost/phpinfo.php in the bar. If i saw a certain page come up
>>>>that it worked. It didn't work but I followed all the instructions
>>>>exactly as stated. Any idea why?
>>>>
>>>>Please Help,
>>>>Stephanie
>>>>
>>>
>>>
>>>
>>Did you save your changes to the configuration file... and restart Apache?
>>
>>PHP is a server side language. If you can imagine so, take Javscript,
>>and you have math functions, setting varibles, and define your own
>>functions based on collected information about the client and the
>>computer the script is executing. Well, PHP is all of that, and more,
>>but it only uses the HTTP protocol to obtain system information. But
>>it's not limited to that! You can use PHP to gather large quantities of
>>information from many differnt sources including your MySQL database.
>>
>>The simplest function used is pretty much the most basic.
>>
>>PHP is secure, depending on the security used to ensure its entagrity
>>from the programmer.
>>
>>The next thing you might want to try is
>>
>><?php
>>
>>echo 'hello world';
>>
>>?>
>
>
>
Navigation:
[Reply to this message]
|