6 replies to this topic

[seliver]

Hello everyone!
I'm opening my first thread because i'm creating a website where:
- there is needed a log-in system, with access to a "private" zone, only visible by users;
- a registation system;
- a few more other things..
My problem is: how can i create the "private" zone; how can i create the account activation, like when i registered in this forum.
I've made the registry (not yet protected against spam); log in(not yet with a limit of wrong log-in "try's".
How can i make that all.
Note: i've no mysql.
Thank you by the way.
Alex.

[Whitey]

If you are making a registration script they normally have to have a mysql. There are ways around it but, imo, i believe you should just get a mysql.. If you would like i could set you up hosting with mysql.. or get 1 from a free site

[seliver]

I tryed to search for hosting with mysql but the only thing that i find is hosting with mysql, but the only username that can log in is the main one, from the hosting account. If you could find some good and free, different from that, i appreciate that.
By the way, it's always good to go around a system. That ways help to find new ones.
I'm trying to create a database by my self(i'm a little crazy sometimes), and that database is stored in .txt files.
Does it have some future?

[John]

Using a txt file as a database will not be nearly as advanced to compete with any of the databases that already exist. So it probably does not have a future. Although it would be a good reason to learn about data structures.

[seliver]

John said:

Using a txt file as a database will not be nearly as advanced to compete with any of the databases that already exist. So it probably does not have a future. Although it would be a good reason to learn about data structures.

And how it is stored the actual database on MYSQL?
It's stored crypted? or have many more things.
I'm saying that because i can store the database in just a file, like file.txt is a text file and file is just a file. That file can have no name or can just be a space, can't it?
It could just be great to discover new things.

[John]

Databases were originally "flat" because they stored in text files using delimiters - linear in structure. For example a pipe ( | ) to separate records, and a comma ( , ) to separate record data. Databases would often look like:

1,John,John@codecall.net|2,whitey,whitey@yahoo.com|3,sliver,sliver@hotmail.com

The problem with this is it is linear in structure - to get to the last record, you must start at the beginning of the file and traverse it until you get to "3." That is denoted as O( n ) time. Databases now use tables (I'm not sure how this is implemented - but I've heard some databases implement the B-Tree structure), but it makes the access time significantly faster ~O( logn ) time.

[Whitey]

I can set you up with a mysql.. message me on aim.. i have 100 free mysql's on my hostng