Help starting up using a simple database

oaskedal

Hi!

Is it possible to create a table/array in a php-file and then collect data from it into another file by clicking a hyperlink..?

I've never setup a database before. Some say I have to use MySql, Oracle and so on..

In other terms...Is it possible to make a database (simple table) in a php-file and then make a query without using mySql, Oracle and so on..?

How could this easily be done (fetching data from an table and then preview the info in another site when clicking a hyperlink)?

Oyvind 🙂

Blulagoon

MySQL is nothing to be afraid of 😃

You can set up Arrays in PHP but they are not very search friendly, although if you know you want the fifth item in the array you can obviously specify $myarray[4] as the value to be assigned.

PHPmyAdmin is a very simple PHP tool that administers MySQL, might be worth downloading both of them and see how you get on.

Blu

oaskedal

Thanks for answering;-)

I've tried downloading the software locally and it works fine, but are there any complications (userinfo, setups, settings needed etc) in connecting to mySql at my ISP's server? Do they give me access to a website or something where I can make my own databases..?

Can I make a table/database, without using MySql, storing it in a php-file and then do a query to it..?

Oyvind

Houdini

If your host has MySQL support when you sign up for their service they will furnish you with either a single database or you might be able to create your own. On one of my servers I have one database and just use prefixes to create the tables required by different systems so it is no problem, and on my other server I can make as many databases as I wish (limited by disk space of course). They should provide you with a username for your account that possibly is good also for FTP and MySQL or they might furnish different ones, but that is too much work so it is not likely. Check with your provider to see what all they offer.

Blulagoon

To follow up on what Houdini says, many webhosts now also provide access to an SQL management tool such as phpmyadmin, which you can use to create your tables and browse their contents. My web host provides me 2 databases, but since the number of tables you can have in a database is large (65,000 ?) I've only ever used one with a very similar prefix structure to Houdini.

There are also good PHP/MySQL tutorials you can look at once you've mastered the basics.

Blu

Edit: Without knowing precisely what you are trying to do, it is difficult to say if you could do it with just PHP and no MySQL. A few years ago, I did manage to use a hard coded array to create an online ordering system

oaskedal

Hi!

Ok, I believe I will have to try out MySql then.
Thanks for all the quick answers!

Oyvind

Blulagoon

Feel free to ask more questions as you find your way around MySQL

Blu