473,587 Members | 2,547 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Drug Database

I have a website that I would like to add a pharmacology
'database' (for lack of a better word) of about 50-75 drugs. Basically
I want users to be able to click on any drug and quickly have a page
refreshed with that drug's data, with all pages having the exact same
format, i.e. drug indications, contraindicatio ns, side effects, etc.
all organized into different sections (probably using CSS table).

My domain (godaddy) doesn't support PHP, so that isn't an option. I
would prefer that this be a client-side application as I would like
the information on the page to change as quickly as possible, i.e. not
reload the page, or not have to go to the server and back. I
definitely don't want to have 50-75 separate html pages!

Can this be done with JavaScript, AJAX - with some XML or MS SQL
serving as the data repository? I can normally figure out how to
tackle these problems, but the more time I spend in the computer book
isles at the bookstore, the more confused I get. None of the books
seem to list examples of what I'm trying to do. What's the easiest way
to accomplish this? Do I have to tackle learning ASP.NET to do this?
I know a little VB, but the learning curve looks like it would be
steep.

Aug 17 '07 #1
2 1459
"NavyPsych" <kn****@yahoo.c omwrote in message
news:11******** **************@ g4g2000hsf.goog legroups.com...
I have a website that I would like to add a pharmacology
'database' (for lack of a better word) of about 50-75 drugs. Basically
I want users to be able to click on any drug and quickly have a page
refreshed with that drug's data, with all pages having the exact same
format, i.e. drug indications, contraindicatio ns, side effects, etc.
all organized into different sections (probably using CSS table).

My domain (godaddy) doesn't support PHP, so that isn't an option.
Don't you mean your godaddy is your Web host (not your domain)?

I have a domain hosted by GoDaddy that uses PHP under Linux.

You just can't run PHP under Windows:
Deprecation of Windows Hosting PHP support
ArticleLast Updated: July 30, 2007 4:50 PM
I would prefer that this be a client-side application as I would like
the information on the page to change as quickly as possible, i.e. not
reload the page, or not have to go to the server and back. I
definitely don't want to have 50-75 separate html pages!
You could have a single page with all of the information then just
show/hide each drug based on the user's request.
Can this be done with JavaScript, AJAX - with some XML or MS SQL
serving as the data repository? I can normally figure out how to
tackle these problems, but the more time I spend in the computer book
isles at the bookstore, the more confused I get. None of the books
seem to list examples of what I'm trying to do. What's the easiest way
to accomplish this? Do I have to tackle learning ASP.NET to do this?
I know a little VB, but the learning curve looks like it would be
steep.
"Easiest" often depends on what technologies you know.
You could use MS-Access with ASP pages, PHP with My-SQL, et.al.

Who is your audience?
Aug 31 '07 #2
McKirahan wrote:
"NavyPsych" <kn****@yahoo.c omwrote in message
news:11******** **************@ g4g2000hsf.goog legroups.com...
>I have a website that I would like to add a pharmacology
'database' (for lack of a better word) of about 50-75 drugs. Basically
I want users to be able to click on any drug and quickly have a page
refreshed with that drug's data, with all pages having the exact same
format, i.e. drug indications, contraindicatio ns, side effects, etc.
all organized into different sections (probably using CSS table).

My domain (godaddy) doesn't support PHP, so that isn't an option.

Don't you mean your godaddy is your Web host (not your domain)?

I have a domain hosted by GoDaddy that uses PHP under Linux.

You just can't run PHP under Windows:
Deprecation of Windows Hosting PHP support
ArticleLast Updated: July 30, 2007 4:50 PM
>I would prefer that this be a client-side application as I would like
the information on the page to change as quickly as possible, i.e. not
reload the page, or not have to go to the server and back. I
definitely don't want to have 50-75 separate html pages!

You could have a single page with all of the information then just
show/hide each drug based on the user's request.
>Can this be done with JavaScript, AJAX - with some XML or MS SQL
serving as the data repository? I can normally figure out how to
tackle these problems, but the more time I spend in the computer book
isles at the bookstore, the more confused I get. None of the books
seem to list examples of what I'm trying to do. What's the easiest way
to accomplish this? Do I have to tackle learning ASP.NET to do this?
I know a little VB, but the learning curve looks like it would be
steep.

"Easiest" often depends on what technologies you know.
You could use MS-Access with ASP pages, PHP with My-SQL, et.al.

Who is your audience?

Mmm.

The way I have done similar is to :-

get a fixed IP address from my broadband supplier. The bandwidth is
entirely adequate for a low volume application.
Get a cheap Debian linux box and set it up with apache, php and mysql,
and webmin.
put a redirect for web access on my router
set up my domain so that www.mydomain.com points to my public ip address.
Designed my database.
Make the using webmin and populate them a bit using that, and a bit
using mysql scripts.
hack some php stuff to display the info and have menus.

I've used a shade of javascript here and there, but not a lot. The
guts of it is in the php/mysql stuff.

Have a look at my first rather crude attempt for someone.

www.peterrake.com

If this fits the bill I'd be happy to e-mail you the various bits and
pieces, but you would have to use them as 'examples' - I can't spend
time designing someone else's stuff.
There is a private administration page where picturse are uploaded and
text is entered. But you don't get access to that!

But a definite way to begin is to get an old PC, (no need for screen or
keyboard once its up) and install the latest Debian on it, apache2,
Mysql and php5 and webmin plus support libraries for mysql under php5.
You can then learn what you need on a local machine until the site
'runs' then if you have a static IP address, make it globally accessible
and get friends to test it.

Then get the O'Reilly mysql book, and a book on HTML and php5 and 'git
coding'



Aug 31 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
3323
by: Cherrish Vaidiyan | last post by:
sir, The following are the steps that i followed in setting up standby database on Red hat Linux 9. i am using Oracle 9i. i have followed the steps in this site : http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/create_ps.htm#66206 Still i give the steps i followed. Preparing the Primary Database for Standby...
6
7322
by: Marvin Libson | last post by:
Hi All: I am running DB2 UDB V7.2 with FP11. Platform is Windows 2000. I have created a java UDF and trigger. When I update my database I get the following error: SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command.
8
7888
by: Kamlesh | last post by:
Hi, How do I know the physical database path of a database. When I goto the DB2INSTANCE users's directory (/home/db2inst1), I see following folders: /db2inst1/NODE0000/SQL00001 /db2inst1/NODE0000/SQL00002 /db2inst1/NODE0000/SQL00003 /db2inst1/NODE0000/SQL00004
1
5956
by: pintur | last post by:
The message is: SQL1036C Errore di I/O durante l' accesso al database. SQLSTATE=58030 what is the proble? what for restore tables? thanks
3
2930
by: josh.kuo | last post by:
Sorry about the subject, I can't think of a better one. I recently wrote some PHP classes that I think might be of interest to this group. Since I have been reaping the benefits of reading news groups for years, I figure it's time for me to contribute a little bit back, maybe some people out there will find this useful. * Introduction ...
8
4122
by: morleyc | last post by:
Hi, until recently i was quite happy to add data sources from mssql database in visual studio and drag the datasets directly onto the form this creating a directly editable form which worked well. However i have recently started a project which will require synchronization to a remote database. Also the underlying database provider may...
0
1838
by: anganb | last post by:
Employment Drug Tests Drug testing is usually performed for purposes of employment, and is also used in social work and the court system to ensure that an individual is responding to drug rehabilitation. An employer may also choose to have his present employees routinely screened for drug use. This has become a controversial procedure,...
0
750
by: ellingt8877 | last post by:
crack drug http://crack.cracksofts.com
0
3306
by: Jack | last post by:
Training Classes for Oracle10g, 9i, 8i Certification training in Oracle10g and 9i: DBA, Developer, Discoverer. training conducted at your location worldwide. Courseware licensing also available. http://a.uuload.com/Oracle-Database.htm Unlock the Value of Your IT System Confio Software's Ignite for Oracle uses wait-event analysis to...
0
7920
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8215
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8347
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
8220
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6626
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5394
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3844
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3879
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1454
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.