Link to home
Start Free TrialLog in
Avatar of rana28
rana28

asked on

Web based application

Dear Experts,

I am working as a system coordinator position in a management institute, I have a big library in our institute, I want to introduce a web based book search engine for our student in our local lan(Intranet). I am using red hat linux 9.0 for our proxy server. I want to know that is this possible at linux that student serach their reference book from any web browser that means frontend is any web browser and backend should be Mysql? if yes then give me some idea about that. My toatal plan like following

Mysql(Database)===>Apache====>DNS(Intranet)=====>Webbrowser(IE, Netscape etc)
Avatar of danny_ebbers
danny_ebbers

Hi rana28,

Yes this is possible, you could easly create a web interface like that with a language of your choice
PHP,or any CGI implementation using Perl,C,Java,Bash

but i advise you to use PHP which has a lot of MySQL built in functions and is verry well documentated
and therefore easy to learn



Best regards,
Danny Ebbers
Drakenet IT Solutions
Avatar of rana28

ASKER

Hi Danny

Thanks for your valuable suggesstion but I want to know so precisely, is there any web link available for this project?
ASKER CERTIFIED SOLUTION
Avatar of danny_ebbers
danny_ebbers

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
rana28,

Freeone: http://sourceforge.net/project/showfiles.php?group_id=26684&package_id=18361

anyway search http://www.hotscripts.com you probably find what you want


Best regards,
Danny
Avatar of rana28

ASKER

Dear Experts,

I  am unable to connect my mysql database from php script, I am using Red Hat Linux 9.0 where the php and mysql are inbuild . I have write the following script for mysql connection, but when I run the scripit the error message  is undefined function mysql_connect()

<HTML>
<BODY>
<?php

$db = mysql_connect("mysql0x.powweb.com","xxxx","xxxxxxxxx","assets");

mysql_select_db("accounts",$db);

$hyper = mysql_query("SELECT * FROM accounts", $db);

while ($myrow = mysql_fetch_array($hyper))
{
echo $myrow["accid"];
echo "in the while loop";
echo $myrow["account"];
echo $myrow["phone"];
echo $myrow["contact"];
echo $myrow["cphone"];
}
?>

</BODY>
</HTML>