TECH6.0

sogah87 · #1 24-07-2008, 11:26 PM

The user registration system tutorial was very helpful and concise, however I need additional help.

I understand how to setup a user registration system but I need help with AFTER they register. I'll explain my scenario:

I have a website that sells items that require users to upload pictures and copy(paragraphs/text) related to those items. After they register how do I make it so users can select an item and then upload their content. Then after they upload it stores all THEIR content on the database?

I need to make it so I can pull down each user's content i.e. pictures and text from the database.

Please help out a.s.a.p. thank you.

webwizzy · #2 24-07-2008, 11:33 PM

Did you follow those tutorial links I gave.

I think Uploading Files To MySQL Database is what you are looking for.

sogah87 · #3 25-07-2008, 06:35 AM

I used ADDT(Adobe Dreamweaver Developer Toolbox) to create the user registration system. I ran into problems when doing your tutorial. After I created the registration page it gave me a sha256.inc.php function error.

webwizzy · #4 25-07-2008, 08:20 PM

You ran into problem coz you must have done some mistake.

1. Did you included that file right after connection.php ?

PHP Code:

  require_once('connection.php');
require_once('sha256.inc.php');

2. Also, check the path of that file, should reside along with connection.php !

sogah87 · #5 28-07-2008, 03:01 PM

even if I did get that to work. How can I make it so when a user adds data it updates their current record and I can know who submitted what, I need to track them. I think I am suppose to use sessions but I am not familiar with it

webwizzy · #6 28-07-2008, 07:17 PM

1. alright, the problem why you were getting that sha256 error is that I missed that file in the tutorial. So, its up now, check the tutorial once again and get the sha256.inc.php. This would solve one of your problems.

2. Now, what data are you trying to update at the time of registration ?? I think you are talking about editing of registered information, something like editing of profiles by users themselves, right ?? If that is what you are looking for then you need to create a login system (yes you need to use sessions for that). We'll take that later on, it would be easier though.

3. Also, you are willing to track records of registered/unactivated users. Ofcourse you need to, in order to manage users and their information.
So, you'd be creating a admin control panel for that. I cannot give you a live demo for that lol but would take out time some day to get a tutorial up for that as well. If you're using Dreamweaver, this part is not tough at all.

Tell me if you successfully complete the Registration System PART I till receiving of activation emails !!

sogah87 · #7 28-07-2008, 09:11 PM

I will try the system registration part later on today and let you know how it goes, thank you.

I am still unclear about the user data part. Here is the scenario:
1.User registers with name, e-mail, password field.
2.I check the database and see that user:"Bob" registered with an email address of:"bob@example.com"....here is where I am confused
3.Bob logs on and uploads image files and text files.
4.The image and text files get uploaded into the same database into a different table but how can I tell that the actual user:"Bob" uploaded files x,y,z.
5.Imagine if I had thousands of users, I need to know which users uploaded which files. Can you please help me

webwizzy · #8 29-07-2008, 09:50 AM

alright so you're uploading images and text files into a different table. Why not insert Bob's unique email address too in a column in that table.

This way you'd be able to retreive all the info in that table. Query something like:-

Code:

SELECT images, files FROM uploads WHERE email='$email';

sogah87 · #9 01-08-2008, 10:39 AM

where is the reg_thanks.php file i'm getting an error on that part.
Im getting a strf() finction error message...

webwizzy · #10 01-08-2008, 04:17 PM

see as mentioned in the tutorial, it is written with a view that people are aware of basic HTML and php basics. So, I did not felt the need to provide tut. for everything there.

anyways dear, reg_thanks.php is NOTHING but just a file with a simple HTML message saying "Thanks for registering." (Note that the person is redirected to this file if he registers successfully). So, create one yourself and upload it.

do the same for regfail_email.php (is redirected to when username/email already exists in the database)

Now, I have no idea what strf error is, even a Google search could not reveal this.
Check if you have created all the 3 hidden fields as mentioned in Step 1a.

MisawaPlayer · #11 19-08-2008, 10:09 PM

alright so you're uploading images and text files into a different table. Why not insert Bob's unique email address too in a column in that table.

This way you'd be able to retreive all the info in that table. Query something like:-
Code:
SELECT images, files FROM uploads WHERE email='$email';

As Said by webwizzy

This suggestion would work just fine, but being a database programmer, I am wondering about your decision to use email as your link between tables. Wouldn't it be more efficient to use Bob's unique userid. In terms of storage, this would use much less space than the email would.

Am I right, or am I missing something?

webwizzy · #12 19-08-2008, 10:22 PM

ah you are absolutely right misawaplayer and thank you so much for correcting me.

by the way, I am no way a programmar like you. Just like to play with it sometimes.

MisawaPlayer · #13 20-08-2008, 04:09 PM

You may not be a programmer, but you are way ahead of me when it comes to vB. I understand databases and Visual Basic, but this vB is knocking me out. I can't seem to get my hands wrapped around it. Give me old fashioned code where you can look at it all, read it, and understand what is going on.

I'm learning PHP, and I am starting to understand the code I am looking at, but when the code contains vB specific stuff, I'm at a total loss.

Hope you don't mind my asking lots of questions. I started the project I am working, simply working the database part of it (storing user inputs, creating the queries and displaying the results), but it has grown, and I am a bit overwhelmed.

Something unrelated - how do I get medals to show in my case? Lots of posts, or do I need to do something more? Just asking. If it is based on posts and possibly favorability, then I like the concept.

webwizzy · #14 20-08-2008, 04:27 PM

I am just a 3-4 month experienced vB guy and I really did not find it that difficult.

If you are really looking forward to learn vB programming then I bet, these 4 articles are real gold for you. This helped me a lot and a lot to start off. This would also make you clear a lot many things.

Must bookmark:-

vBulletin Template Conditionals List
Using the vBulletin Input Cleaner
[How-To] vBulletin API Basics: Creating Custom Pages & Misc.
Datamanagers: Objects as Data and Methods

Nahh.. I really do not mind your asking questions coz this is what this place is for. Feel free to post.

Those medals count increase according to posts. After every 10-15 posts you get a medal.

MisawaPlayer · #15 20-08-2008, 05:15 PM

Thank you for the links. I will definitely be checking them out.

TaL · #16 31-12-2008, 11:54 PM

Hi webwizzy

Thanks a lot for this tutorial, I have found it very intresting and helpfull for expanding my knowledge of playing with PHP and MySQL. I have a problem that I would like to ask you about. I have the system working to the point that it sends the confirmation e-mails but when I click on the activation link, I get an error saying that confirm.php is not found. I realize that I did not make a confirm.php as part of this and I am just wondering if I did something wrong or if the confirm.php is part of what will come in part II of this tutorial?

Thanks again for this great tutorial!

webwizzy · #17 31-12-2008, 11:59 PM

Hi TaL and welcome to tech6.

I have the system working to the point that it sends the confirmation e-mails

I am glad to know you got it working till that part

And yes, you are correct, confirm.php is Part II.

webwizzy · #18 01-01-2009, 12:55 AM

Hi TaL and welcome to tech6.

I am glad to know you got it working till that part

And yes, you are correct, confirm.php is Part II.

As Said by webwizzy

which is now done

TaL · #19 12-02-2009, 07:53 AM

Hey webwizy

I have not been around lately as I have been busy but I wanted to stop by and let you know I have the registration system totally up and working. I am starting to look at methods now for setting up pay membership status with paypal. Have you done anything like this before? I have no experience with working with e commerce stuff and I am wondering if you have any pointers that will tie in well with this registration system.

Thanks again for the great work!

webwizzy · #20 12-02-2009, 09:22 AM

hello tal,

Talking about Paypal/e-commerce stuff, I haven't done anything too complex (that requires reading Paypal's API) yet, but I guess returning a success/failure page after payment shouldn't be tough.

The max I have done is the Advertise page here via Merchant Tools, which is quite easy.

On a quick note, you can create a column say "premium" and insert 1 who pays at the time of registration. Also, create a usergroup column and insert an ID for premium members group if success page is returned.

Ofcourse, do go through the Paypal Developers section.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

TECH6.0

What to do after a user registers?