/    Sign up×
Community /Pin to ProfileBookmark

Accessing a database using HTML and Perl/PHP???

Hi,

I have a basic MS Access database with a single table in it called ‘table1’, the table having the fields ‘name’ and ‘telephone’. What i want to do is for this information to be displayed on an html page when a user clicks a button on the prior page.

I want this data to be fetched ‘real time’ from the database and so was thinking of using Perl to do this as i have experience in using Perl. However would people suggest using PHP instead by any chance as i realise it seems more popular nowadays, and also how would i go about this as i have no experience with PHP?

I understand how i can manipulate the data once i get this far, its just i’m a bit unsure on how i need to declare things etc in the script and also how i call this from the html site.

ALSO how hard would it be for me to teach myself basic PHP based on the fact that i have a basic understanding of Perl?????

Hope someone can help

Cheers

Dave

to post a comment
PHP

6 Comments(s)

Copy linkTweet thisAlerts:
@NogDogJan 05.2005 — If you are reasonably comfortable working with Perl, you should find it relatively easy to pick up PHP, I would think. Basic command/function-call syntax is similar. PHP has a lot of built-in functions for web and database functionality, so it's not particularly difficult once you identify the necessary functions to use. A searchable HTML manual is available online at http://www.php.net/manual/en/ .
Copy linkTweet thisAlerts:
@htmlperlmanauthorJan 06.2005 — Has anyone any ideas on how i would go about accessing a microsoft access database using PHP then???
Copy linkTweet thisAlerts:
@ShrineDesignsJan 06.2005 — convert your MS Access file to a more (practical) popular sql format like MySQL, PostgreSQL, etc.
Copy linkTweet thisAlerts:
@NogDogJan 06.2005 — I think you would do this via the [url=http://us3.php.net/manual/en/ref.uodbc.php]ODBC functions[/url], but I'm not positive. Hopefully someone who actually knows will chime in here soon. ?
Copy linkTweet thisAlerts:
@htmlperlmanauthorJan 06.2005 — Are things like MySQL more useful then. Have never used these but might have a look into them if it will make my job easier
Copy linkTweet thisAlerts:
@NogDogJan 07.2005 — [i]Originally posted by htmlperlman [/i]

[B]Are things like MySQL more useful then. Have never used these but might have a look into them if it will make my job easier [/B][/QUOTE]

MySQL is pretty decent by itself. When working with PHP, it's even better because PHP has so many built-in mysql_*() functions. And of course: it's free. ?
×

Success!

Help @htmlperlman spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.2,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,

tipper: @Samric24,
tipped: article
amount: 1000 SATS,
)...