|
|
Posted by S.Williams on 01/01/06 22:48
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:
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]
|