- #CREATING A COMMENT AND REPLY SYSTEM PHP AND MYSQL INSTALL#
- #CREATING A COMMENT AND REPLY SYSTEM PHP AND MYSQL FULL#
- #CREATING A COMMENT AND REPLY SYSTEM PHP AND MYSQL FREE#
If you're running into any trouble, you can check out the full code in my GitHub repo: Further Thoughts Then, if you make another submission using that referral code, you'll see that recorded in the database. Submit your email address, and you should get a pop-up with your unique referral link. To test it out, restart your Node server ( ctrl+c to stop it, and npm start to start again) and revisit localhost:3000. You've successfully implemented a referral program in your app!
Generate a unique referral code the user can share. Read the user's submitted data: email and referrer. We told our form to submit all entries as POST requests to the / route, so let's define what happens there now. Your file should look something like this: DB_USER=your_database_username env at the root of your project, and put your MySQL database credentials inside. Creating Environment VariablesĬreate a file called. 
This will allow us to use _NAME to access environment variables later. At the very top of the file, before anything else, add the following line: require('dotenv').config() We need to make one small tweak to the app.js file for our project.
Use the following commands to install them: npm i mysql
shortid for generating short, URL-friendly referral codes. dotenv for accessing environment variables from a. mysql for interacting with our MySQL database. Let's start working on the backend by installing a few dependencies from npm. If you're using code like mine, you should expect your home page to look like this: However, when that route is implemented, you can see that on success it will alert the user with their unique referral link. You can test this by submitting your email now you should get get a 404 Not Found error, since we haven't implemented a POST handler on that route yet. The jQuery within the script tag here will submit an AJAX POST request to the / route with the data from the email and referral code input boxes. In the index.ejs file, we need some code to render email & referral code input fields and a submit button, with a bit of Javascript (jQuery in this case) to submit the data to our server. You should see a page that says “Welcome to Express.” User Interface Once you have that running, confirm everything is working by visiting localhost:3000. $ cd referral-programinstall dependencies:Īs instructed, we can run this project with the following commands: cd referral-program express -view=ejs referral-program**create : referral-program/Ĭreate : referral-program/public/javascripts/Ĭreate : referral-program/public/stylesheets/Ĭreate : referral-program/public/stylesheets/style.cssĬreate : referral-program/routes/index.jsĬreate : referral-program/routes/users.jsĬreate : referral-program/views/error.ejsĬreate : referral-program/views/index.ejsĬreate : referral-program/bin/wwwchange directory: I'll first create a simple Express project called referral-program using the EJS view engine with (). Wherever or however you set up your database, make sure to keep track of its credentials so we can access it via the Node.js app later. `time_added` TIMESTAMP NOT NULL DEFAULT 'CURRENT_TIMESTAMP', I created my table with the following schema: CREATE TABLE `users` ( Referrer (the code they used to sign up with, if any)įor this simple referral system, we just need a database that can hold four things: a user's email address, their unique referral code, the code of the person who referred them, and the time they were added. …and the database needs to hold a list of everyone who has signed up, with the following info: Return the referral codes to the client so they can be displayed. Generate unique referral codes for each user who signs up. 
Render a web page with an email sign-up.The Node server will need to do the following:
You're free to use any web server + database combo, as the same principles will apply. The Planįor this project, I'm going to use a Node.js/Expressjs server and a MySQL database. While working on my most recent product, Shelf (check it out!), I implemented a custom referral program, and wanted to share how I did it. “ describes a psychological and social phenomenon wherein people copy the actions of others in an attempt to undertake behavior in a given situation.” Someone signs up, other people see them doing so, and in turn they're more likely to sign up as well. Just about any time you sign up for a new SaaS product or subscribe to a hot new email newsletter, you're given a referral link you can share with others for a special bonus.Ĭreating a referral program is an incredible way to get social proof for your product.
0 kommentar(er)
