Database
PhpMyAdmin | SQL
PhpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc).
Apps System
How the Apps Work
CariCabee Shop is made for the obligations of smart website learning subject from my college. I use Code Igniter 3 for the framework and phpMyAdmin SQL for the database. For the template i used bootstrap tmart template So this is a simple description about how the CariCabee Shop work. Caricabee is a semantic website That can show any product from another website. For the detail of the system you can click the show & hide button one by one.
User Account
CariCabee Shop
To access all features that exist on this website you need to log in to your account first. Like for example to do a transaction of my product you have to log in before do it. Because the system need to know your identity to secure the transaction.
User Accout
Login
CariCabee Shop
First you need to log in to access all feature in this website. If you don't have the account yet, you have to register it first. By click the register text beside the login text. And you will directed to the register page like you can see on the next image.
Register
CariCabee Shop
In register page you need to fill the name, email, and password input box to register your account. After you succeed to register your own data to create account, you will be directed again to login page with alert like you can see on the next image.
Register
CariCabee Shop
In register page you need to fill the name, email, and password input box to register your account. After you succeed to register your own data to create account, you will be directed again to login page with alert like you can see on the next image.
Verify Account
CariCabee Shop
The alert say your account is already created but your account is not activated yet, and you have to check your email to activate it. The purpose is to make sure that the email that you registered is exist.
Activation Mail
CariCabee Shop
There will be a mail on your email like you can see on the image. The title is account verivication, and it give you a link to activate your account. Once you clicked the link, your account will be activated and you can log in to the website.
Activation Mail
CariCabee Shop
There will be a mail on your email like you can see on the image. The title is account verivication, and it give you a link to activate your account. Once you clicked the link, your account will be activated and you can log in to the website.
Forgot Password
CariCabee Shop
If you forgot your password you can go to the forgot password page and submit the email that you alerady registered. The system will send you a link to reset your password to new password. And give the alert like on the next image.
Reset Mail
CariCabee Shop
The system says you have to check your email to reset your password. And if there is not mail from the application system, you have to check it on spam inbox. Because sometimes the system can reach the main inbox.
Reset Mail
CariCabee Shop
The system says you have to check your email to reset your password. And if there is not mail from the application system, you have to check it on spam mail. Because sometimes the system can reach the main inbox.
Reset Link
CariCabee Shop
And you can see this is the mail in spam inbox that there is a link to reset your password. Click the link to reset your password and you will be directed to private page that cannot be accessed if there is no access to reset password.
Reset Password
CariCabee Shop
On the reset password page you asked to fill the new password twice to make sure the password is match and you remember it.
Reset Password
CariCabee Shop
On the reset password page you asked to fill the new password twice to make sure the password is match and you remember it.
New Password
CariCabee Shop
After reset the password, your new password will be your password and you can log in to your account with your new password.
Change Password
CariCabee Shop
After log in to your account you can change your password too. By fill the current password and fill the new password twice to make sure your new password.
Change Password
CariCabee Shop
After log in to your account you can change your password too. By fill the current password and fill the new password twice to make sure your new password.
Scrap Product
CariCabee Shop
There are some product that are not the original product of this website. Like some of the product is from other website that selling the same product like This website. To have products from other website we have to scrap the product to our website first. And there are 2 way that i know to scrapping a product from other website, and you can see how to do it by clicking the show button.
Scrap Product
Scrapped Product
CariCabee Shop
This is one of the other way to scrap product form another website. That it doesn't need database to show the scrap product. It means the scrapped product is directly show when you open the page. But the lack of this way is you need more time to load the page. Because the system have to scrap all of the product first to show it on the page. But the excess of this way is you don't need to update the scrapped product data routinely, because it will updated automatically if origin website is updated the product data.
Scrap to Database
CariCabee Shop
Scrap Product data to databse is another way to scrapping product to our website. The different is the product data that we want to scrap is must be inputted to the database first and then select from database to show the product data to the page. The excess is faster loading page because the product data is in our database. But the lack is we have to update the scrapped data routinely because it doesn't updated automatically.
Scrap to Database
CariCabee Shop
Scrap Product data to databse is another way to scrapping product to our website. The different is the product data that we want to scrap is must be inputted to the database first and then select from database to show the product data to the page. The excess is faster loading page because the product data is in our database. But the lack is we have to update the scrapped data routinely because it doesn't updated automatically.
Source Example
CariCabee Shop
Like for example we scrap some product from agromaret.com and we just have search what product is we want to scrap to database. And copy paste the link to the input box like the previous image and click the scrap button. And the data will be inputted to the database.
Scrap Result
CariCabee Shop
And then the result is will be like this, it will appear on our page the data will coresponding to the source data. From image, name price per kg/ton or some of That and there is also a link to the original website.
Scrap Result
CariCabee Shop
And then the result is will be like this, it will appear on our page the data will coresponding to the source data. From image, name price per kg/ton or some of That and there is also a link to the original website.
Redirect Source
CariCabee Shop
And if you click the data from the scrapped product data it will redirect you to the original website.
Product Transaction
CariCabee Shop
This is the detail of how the transaction work for my product. From user ordered a product until the product arrived to the buyyer. And there is also a forbidden acces to user who have cancelled order 5 times or more. Because it seems they are just playing with the application. You can see the detail by click the show button
My Product
CariCabee Shop
The transaction is only for my product. The scrapped product only showing you the image, name and price and if you interested to buy it will redirect you to the original website. My product is the original product of caricabee website that you can order it by click the order button or detail button.
Order Product
CariCabee Shop
If you want to order my product you can do it by click the direct order button and there will be a modal appear to the screen to specify your order, like how much for the amount and your address. And also you can ordered it by click the detail button to see the product detail frist before ordered it.
Order Product
CariCabee Shop
If you want to order my product you can do it by click the direct order button and there will be a modal appear to the screen to specify your order, like how much for the amount and your address. And also you can ordered it by click the detail button to see the product detail frist before ordered it.
Confirm Order
CariCabee Shop
After you ordered the product the product will be show on troly menu that the status will be wait to be confirmed by admin. On the confirm status you can cancelled the order.
Order in Process
CariCabee Shop
After admin confirmed you ordered, the status will change to your order is on process. That admin is already processed or in process to your order. And you can pay the bill and confirm to the admin like on the next image.
Order in Process
CariCabee Shop
After admin confirmed you ordered, the status will change to your order is on process. That admin is already processed or in process to your order. And you can pay the bill and confirm to the admin like on the next image.
Payment Slip
CariCabee Shop
The system will direct you to admin whatsapp to show and make sure that you have paid the bill. So admin will send the product that you ordered to the address that you put when you order the product.
On The Way
CariCabee Shop
After show admin the payment slip the admin will send your ordered product to your address. And on this status you can not cancelled the order because the product is already on the way to you address. So it can be cancelled. And if you have receive the ordered product you can click the done button or the system will done it automatically on next day.
On The Way
CariCabee Shop
After show admin the payment slip the admin will send your ordered product to your address. And on this status you can not cancelled the order because the product is already on the way to you address. So it can be cancelled. And if you have receive the ordered product you can click the done button or the system will done it automatically on next day.
Order History
CariCabee Shop
After the order is done. There will be an order history to this website.
Forbidden Access
CariCabee Shop
There is also a forbidden access if you cancelled the product equals or more then 5 times. If you have cancelled it more than 5 times your account can't access the website for several days. Because the system detect you just playing around with the order.
Forbidden Access
CariCabee Shop
There is also a forbidden access if you cancelled the product equals or more then 5 times. If you have cancelled it more than 5 times your account can't access the website for several days. Because the system detect you just playing around with the order.
Features
CariCabee Shop
There are some features in this website that you can see and try. You can see the detail by click the show button.
Home Product
CariCabee Shop
In home menu there are some of my product and scrapped product that anyone can see the detail and order if they haved been on logged in to their account. And it will be show on troly menu like ordered from shop menu.
Latest Order
CariCabee Shop
And little bit scroll down you will see the latest order of my product that there will be 3 latest ordered product will be shown on the latest order. The name of the buyer also shown on the latest order.
Latest Order
CariCabee Shop
And little bit scroll down you will see the latest order of my product that there will be 3 latest ordered product will be shown on the latest order. The name of the buyer also shown on the latest order.
Comments
CariCabee Shop
There is also a comment feature on the footer of the home page. That the logged in account can give their comments to this website, about what are they thinking about this website wether is good or not.
Guest Book
CariCabee Shop
Almost like comments feature, there is a guest book too. The purpose is to find out how many the visitors of this website per day, month or year. Because how many the visitor will decide the website is good or not.
Guest Book
CariCabee Shop
Almost like comments feature, there is a guest book too. The purpose is to find out how many the visitors of this website per day, month or year. Because how many the visitor will decide the website is good or not.
Profile Edit
CariCabee Shop
And logged in account also can edit their profile data by change their name and image profile.
Contact
If you have any website project or mobile project and interested to team up with me, you can contact me.
