ghostrider
May 19 2007, 01:40 AM
| | The username is a field with a letters, the primary key has to be a number. I generally use a field that i call id for all my primary keys. |
Reply
Unstoppable
May 19 2007, 03:44 PM
Hmm, no thats not the problem. Can someone search the problem in my documents? I'll send them.
Reply
jlhaslip
May 19 2007, 04:34 PM
Can you post the code or supply a link to a zipped file, please. Someone will look at the whole thing and advise what they find, but until we see the code, we will only be guessing at the potential fixes...
Reply
Unstoppable
May 19 2007, 04:46 PM
thx jlhaslip and others: http://rapidshare.com/files/32206829/site.zip.html i think it would be great if anyone of you could make a database in mysql, cuz i made it in access so itll prolly suck
Reply
jlhaslip
May 19 2007, 06:19 PM
First thing to change is to add the php start and stop tags to the conn.php. When a file is "included", it is parsed as html unless you identify it as a php file by inserting the "<?php" and "?>" tags before and after. It might be that the con.php is not firing up the connection? because it isn't being id'd as a php file...
Reply
Unstoppable
May 19 2007, 06:37 PM
Ugh, I need to learn more PHP, but for now can you fix it, try to see if it works and then send back? So i can look at the differences between the 2. And the login system was from a tutorial on this site.
Reply
jlhaslip
May 19 2007, 07:20 PM
which tutorial? can you post the link, please.
Reply
Unstoppable
May 19 2007, 10:01 PM
jlhaslip
May 19 2007, 10:29 PM
Well, aside from the difficulties you are experiencing with php as per the above reply, it appears that you have tackled a difficult task. The Tutorial you are using has MySql code, but you are using an MS Access Database, so there is one problem there. Also, it appears to me that the site files you have zipped are a collection of several different Tutorials using various files and methods which you are not quite familiar with. What i mean by this is that the Tutorial you link to above includes nothing about Lost Passwords, but your site files do... I suggest you scale down the Features you are trying to implement for now. Go back to the original Tutorial and start over. This time, simply set the goal of allowing users to Register and Log-in. Build your database and tables according to what you have available, either mysql or Access, don't mix them... Forget about verifying sessions, setting cookies for now. You can add those features later, similarly the Lost password feature. Go back to a basic Log-in system to start with. If you only have access to Access, find a Tutorial that uses the ms Access method, otherwise download and Install a WAMP or XAMPP to set up php and mysql servers on your Localhost for testing purposes.. those are my recommendations...
Reply
Unstoppable
May 20 2007, 09:38 AM
Well I didn't mix several tutorials, i only tried them and afterwards moved them to them 'database' inside the site zip file. There is no link to these files, so there isnt a problem with that. And yes like you said, the problem is that i dunno how to use MySQL, cuz i dont understand how it works and didnt find a download on the official site. I'll try to find it, so it might work
Reply
Recent Queries:--
simfatic forms rapidshare - 53.79 hr back. (1)
Similar Topics
Keywords : database- Import From Excel File Into Mysql Database
- (11)
Has anyone tried using the excel import function that comes with phpmyadmin
http://www.phpmyadmin.net/home_page/ - it does not require any additional plug-ins or scripts and
is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish
to import the data to , there is a link on the bottom left corner which says "insert data from a
text file into the table" - although it says text file it still can be used to import an excel file.
When you click on this link you will be taken to a page where you will be asked for the file name
(the...
How To Use A Database For Chess Results?
- How to set-up, configure, and utilize a database to store chess result (0)
Need Help With My Database [resolved]
- retrive data as a link (6)
This is the situation: I have a database where you can add bands ( theire albums, genre other
info) For the album part they can add for each album the songs. So what do i want: When i show
the results there only shoul display the bandname which should be a link to the more detailed info
like albums biography etc. How do I do that. Is there a name for this and are there any
tutorials. thx in advance...
Index In A Mysql Database
- Make the numbers follow (3)
I hope I am on topic here (It does have to do with web design, after all). I have noticed that in a
MySQL database, the 'id' field just keeps its numbers for every record, with the backdraw
that, whenever you remove (a) record(s) from the table, you get your list numbered as eg.
1,5,6,7,12,25 etc. This makes it a bit difficult of keeping track of the number of records in your
table. Is there a way of achieving (either in PHPMyAdmin or through the use of PHP) that the id
field in your table gets sort of 'refreshed and updated' so you have a clearer view...
Treating .csv Files As Database Data
- Showing .CSV data on a web page (2)
I use a nice program (which I helped to beta test) called ' Simfatic Forms ' to generate
forms on web pages. The only problem is that it does not (yet) support MySQL databases, it saves the
form data as a .CSV file. Now I was wondering if you can do the same with a .CSV file as you do
with a MySQL databse, ie. displaying the data in that file on a web page which adjusts automatically
as data are added to the file. To clarify: eg. if I make a form to sign a petition online, the data
are saved to a .CSV file every time someone fills in the form, is it now possibl...
Accessing Mysql From Javascript
- Javascript to communicate with database (4)
I found a nice program which allows you to put quizzes on your web site. You can design your own
questions, set the layout of your page, and there is also a possibility of having the results
emailed to you. It further offers a facility to store the results and all that, all you have to do
is put a link in the program, telling it which page takes care of that. However, when I look at the
HTML code the program generates, I see that most of it is written in Javascript. Obviously, it also
uses variable names, but as I don't know any Java, I was wondering if those variab...
Where Am I Going Wrong This Time?
- Can't enter data into database (4)
Hi, on my local machine (with Apache 2.0, PHP 5.2.4 and MySQL 5.0) I come across weird things. I
have successfully made a table, but when I try to enter data into it it just will not accept the
empty string for the first field (id). This was the creation line: QUOTE $query="CREATE
TABLE members (id int(20) auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone
varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT
NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))"; This has...
Merging Database Php Mysql
- (5)
Hii i need help margning script. i have coppermine gallery, AzDGDating Site, Noah's
Classifieds they all have user sign-up login. but they have different like i need to have 3 seperate
account for each script is there any way like mergning one user name and password would work for 3
section. if you don't get my question please tell me i will try to explain more in detail
thank you for your time and help ...
Help Or Advise Needed For Access Database Webpage Conversions
- I need some help with getting a linked webform so that the data can be (0)
Hello All. I'm looking for some advise or assistance with getting a web page/access page
running so that i can have the page online and collect the data live into my database for Project
Management... Currently I'm developing a database using M$ Access, and need to have staff
data enter sales information directly into a web form that can be linked to a database? I've
looked at using a M$ Front page web form with data collected into a .CSV text file and
extracting the data but i need to be able to let the staff review and update the data for eac...
How Do You Combine Multiple Mysql Databases Into One Database?
- (3)
How do you combine multiple mysql databases into one database? I was thinking thta soem servers
restrict you to one to five mysql databases. If I have a dynamic part of a table on my site, I
would use one database for that. For every table of dynamic information, I use one database. Can I
streamline what I am doing and combine all of my databases into one? I could make multipple tables
in the same database. Would that work? thanks...
Free Dhtml Menu That Reads A Database
- Anyone know one? (7)
Hey, anybody know a DHTML menu that reads info from a database? for people who don't know, just
like windows' "start menu" with the popup menus I want to mod it so that in phpnuke I can edit
it admin panel end. I would like it to be vertical. Do not use note tags because they are only for
admins and moderators. ...
Looking for database
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for database
*MORE FROM TRAP17.COM*
|
advertisement
|
|
