A fully functional project based on an Online Ecommerce Website that uses PHP Language with MySQL database. Following PHP MySQL project contains all the essential features which can be in use for the final-year IT students for their college projects. It has a number of features that will allow users to manage products and shop online. This system as well as the website’s concept is all clear. It’s the same as real-life scenarios and well-implemented on it. To download free Ecommerce Website project in PHP MySQL with source code files, please scroll down to the bottom of this post for the Download button.
About Ecommerce Website PHP MySQL Project
In particular, this Ecommerce System project in PHP focuses mainly on eCommerce aspects from online shopping to order management. To be more precise, the system helps customers to filter, shop online just like every other known eCommerce website. Also, the system contains all the product, order management features with it. In addition, the system allows managing customers, website settings, subscribers, and more. Evidently, this project contains an admin panel with a customer panel on the client side. In an overview of this web application, customers can simply register on the website in order to start shopping. He/she can filter products, add products to the cart, checkout, view orders, and much more. A customer can go through a number of phases of products under this PHP eCommerce project.
Featured, Latest and Popular Products
When it comes to projects such as eCommerce, it is mandatory thing that a website should include these sections for user satisfaction. Not just satisfaction, it also helps to develop a two-way relationship between the end-users and the website. Speaking of it, the featured section helps the end-users to interact with their products, either way, to boost it up as well. This particular section tends to attract users to their featured products. Likewise, as the name itself suggest the latest products, it displays a certain number of recently added products on the client-side. Similarly, this eCommerce website project counts total views on a certain product in order to display under popular category. Meaning, all the most-viewed products are automatically listed under it. In fact, these sections are totally controllable by the system administrator including their number of display products.
Cart, Product Category, View Customer’s Order and More
Talking about the product category, the customers can simply switch product sections with a simple click. With it, the website displays all the available products under the requested category. For instance, clicking on the men’s section displays products related to men and so on. This whole website contains a system to top and end level navigation for easy user interaction within the website. Also, a cart system is available for the users in order to add products to it for the checkout procedure. Also, this particular section contains all the necessary features such as updating the cart, removing items, and more. In addition to it, a customer can list out his/her personal order history from their profile. He/she can view order details such as product name, payment information, quantity, pricing, shipping status, and more. Besides, each customer can update billing addresses, update profiles and change passwords.
Admin Panel
Now moving towards the admin panel, an administrator has full control over the system. An admin has the right to manage the proper flow of the system. He/she can manage website settings, image sliders, products, orders, customers, and more. Speaking of website settings, it means an admin can update header-footer settings, website brandings, and other website details. Also, the admin has to manage shop settings such as color, size, shipping cost, categories. In-depth, the category refers to top, mid, and end level categories for displaying products. Each product needs to have a top, mid, and end level category just like a host for management of it. In fact, these are the exact point which displays under the website’s navigation bar. Besides, an administrator can manage image sliders, page settings, services sections for the client-side of things.
Product Management
On one hand, an admin has full access to managing products for the website. There is a number of required fields under this section. It includes the name of the product, its categories, pricing, size, color, description, features, images, and more. Also, there are no such limits while uploading image files for each product. And at last, the system provides an option to feature the product. Where the administrator can simply check on to the featured product section in order to list it out as a featured one on to the client-side. As mentioned earlier, an administrator has full control to manage all the featured items for the website. Besides, the user can simply activate and deactivate each product. Also, the quantity section gets automatically updated as soon as someone purchases it.
Order Management
On the other hand, all the orders from the customers are listed under this section. The system lists out order details with proper mention of customer and product details with payment information, paid amount, and status. All the orders are automatically set to pending status under shipping and payment status by default. Here, an admin has to verify each order manually and change the status of each order. Starting from the payment status to shipping status, an admin has to mark it as complete as soon as it gets. Additionally, the admin can also send personal messages to the customers regarding any product-related issues or a simple thank you message. This section is directly connected to the customer’s order history as the results depend upon the admin side of things. Besides, the user can delete orders, search orders by product name, customer name, or pricing details.
Customer Management and Page Settings
Moreover, every customer needs to verify their account after signing up. And all the verified customer accounts are listed under the customer section of the admin panel. Here, the administrator can view the customer’s detail such as name, email, contact information, and account status. In fact, an admin can manually change each customer’s account status and mark it as deactivated. Or, simply delete the whole record of the customer. Regarding page settings, it contains a section that covers the pages of the website such as contact, FAQs, and about us. The user can update the page title, banner photo, meta keywords, description for each section. To be more precise, an admin can update details of each available page on the website anytime from the system itself with ease.
Last but not least, a clean and simple dashboard is presented with various color combinations for greater user experience while using this Online Ecommerce Website System Project in PHP MySQL. For its UI elements, a free open-source CSS framework; Bootstrap is on board with some Vanilla CSS too. Presenting a new eCommerce Website Project in PHP MySQL which includes an admin panel that contains all the essential features to follow up, and a knowledgeable resource for learning purposes.
Available Features:
- Client-Side Interaction
- Admin Panel
- Customer Registration
- Add to Cart System
- Checkout System
- Update Billing Address
- Search, Filter Products
- Product Categories
- Featured Products
- Latest Products
- Popular Products
- View Order History
- Update Customer Profile
- Manage Website Settings
- Manage Shop Settings
- Product Management
- Order Management
- Pending Orders, Shippings
- Set up Image Sliders
- Set Shipping Charges
- Page Settings
- Set Social Media Links
- Subscribers
- View Registered Customers
| Project Name: | Ecommerce Website PHP Project |
| Language/s Used: | PHP |
| PHP version (Recommended): | 5.6, 7.4 |
| Database: | MySQL |
| Type: | Website |
| Developer: | Hammad Hassan |
| Updates: | 0 |
Instructions: How to Run?
- After you finish downloading the project, unzip the project file and head over to your XAMPP directory.
- There you’ll find a folder naming “htdocs”.
- Inside the “htdocs” folder, paste the project folder (not the .zip one, but the extracted one).
- Open your favorite browser; we recommend using Google Chrome or Mozilla Firefox.
- Then, go to URL “http://localhost/phpmyadmin“.
- Create a Database with a name that is provided inside the “01 LOGIN DETAILS & PROJECT INFO.txt”.
- Click on the “Import” tab and choose the database file (.sql) which is provided under the folder naming “DATABASE FILE”.
- After setting up all these, go to URL “http://localhost/[ PROJECT_FOLDER_NAME ]/“
- All the login details are provided inside the project folder, check that out and enter in order to use it.
And there you have it, a full setup of the eCommerce site Project in PHP MySQL. For this particular PHP project, PHP Version 5.6 or 7.4 is required because the project does not operate with the oldest PHP version. So, users with the oldest PHP version (older than 5.6) might face various problems while operating it. As a result, you’ll need to manage your PHP version (only if you’re using the old version) at the moment. Also, Download Free eCommerce Site Project in PHP MySQL Source Code. So, this eCommerce Website PHP project is a fully functional project for all the intermediate levels that broads vast knowledge into such PHP web applications. In conclusion, this whole PHP project with free source code is an absolute project and a meaningful way for the users to learn and explore more about it.
Free Download Ecommerce Website Project in PHP MySQL with Source Code:
Click the Download Button Below to Start Downloading
Note: Only for Educational Purpose
where do I convert the currency to my local currency?
Please go through the code lines.
pls say step
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_settings’ doesn’t exist in C:………………….
Create a database named ‘ecommerceweb’ and import the given db file!
im also getting error. but i have created a database and also imported the file.
thank you for the project I find it very interesting however, registration does not work online. when a user registers and submits the form it is a blank page which is subsequently displayed and when the administrator checks the registration the new registrant is not there, in other words he is not registered in the database. how can I solve this problem please?
he says — and not edit in database file
— ——————————————————–
—
#1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
Please have a look here: https://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te
what is the Admin password
Check the text file
im also getting error. but i have created a database and also imported the file.
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb. tbl_settings………………………….
FIX LINE 1431:
) ENGINE=MYISAM DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;
add database….
first create database then import database in it use command line sql import setting and some other table.
where the code written??
I have checked all the code.
We want an online store like Amazon, Django, please
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_social’ doesn’t exist in C………………….
make sure you’ve uploaded the db file
#1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
Please have a look: https://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te
tell me the php file name
Error
SQL query:
— ——————————————————–
—
— Table structure for table `tbl_settings`
—
CREATE TABLE `tbl_settings` (…………………………………………………….
MySQL said: Documentation
#1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
in this code what’s is error
kindly reply sir plzz
Please have a look here: https://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te
Connection error :SQLSTATE[HY000] [1049] Unknown database ‘ecommerceweb’
Warning: Undefined variable $pdo in C:\xampp\htdocs\eCommerceSite-PHP\header.php on line 16……………
Please create a database named “ecommerceweb” and import the given SQL file.
still didnt work
Are you sure you’ve created and imported the given db for this project?
Ecommerce Website in PHP MySQL with Source Code on this project please send the share code of cash on delivery and scanner and pay methods of source code very urgently please Sir.
how can i register new user as admin because there is no registration page for admin
in table `tbl_language`
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_settings’ doesn’t exist in C……………
how to remove this error?
First, create a database named ‘ecommerceweb’ and then import the given db file.
Your database has an error my friend not complited, just to upload it again
what kind of error?
Hi. I have a problem when import databases:
#1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
*********************************************
— ————————————————————….
You’ll find your solutions here: https://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te
I do not understand can you please tell me more clearly…. and also got the fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_settings’ doesn’t exist in C…………………
Just open the db file using text editor, and you’ll see table “tbl_settings” on line number 1359. You have to import the database file before running the project!
bro just find tbl_settings and change all varchar(225) to varchar(100)
open db file in notepad on line 1359 u can see tbl_settings. there change all varchar(225) to varchar(100)
the file header.php is calling the table “tbl_settings” from the db but there is no such a table in the “ecommerceweb” db. therefore it’s showing:
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_settings’ doesn’t exist in C……………………………..
That’s impossible. Please do check the SQL file properly. There’s a tbl_settings table on line number 1359. Please make sure you’ve created and imported the same db file before running the project.
When I create a new account, I get this error. I want to cancel the account verification code
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘cust_token’ in ‘field list’ in C:\xampp\htdocs\eCommerceSite-PHP\registration.php:151 Stack trace: #0 C: \xampp\htdocs\eCommerceSite-PHP\registration.php(151): PDOStatement->execute(Array) #1 {main} thrown in C:\xampp\htdocs\eCommerceSite-PHP\registration.php on line 151
Are you sure that you’ve imported the same database that we’ve provided? Cause the column ‘cust_token’ is present inside the table ‘tbl_customer’.
I did not change anything except on the tbl settings table because it shows me this problem
#1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
Changed InnoDB to MyISAM and added ROW FORMAT COMPRESSED
Did it worker??
adding to cart not working, popup seys its added but cart empty
That’s impossible, something might’ve gone wrong on your local machine.
yes, did reupload mysql dbase and all good, big tnx.
bro i cannot create a database
Please help me how i create a database named ‘ecommerceweb’ and import the given db file
error:
Warning: session_start(): Session cannot be started after headers have already been sent in …………..
how to remove tawk.to
i did remove Tawk.to script and get this
Warning: session_start(): Cannot start session when headers already sent in /www/header.php on line 4
Warning: session_start(): Cannot start session when headers already sent in /www/admin/inc/CSRF_Protect.php on line 29
Warning: mail(): Failed to connect to mailserver at “localhost” port 25, verify your “SMTP” and “smtp_port” setting in php.ini or use ini_set…………………
I am getting this error. Kindly help me in fixing this problem.
There’s no mail feature as it does not work in this project. Customer Verification should be done by accessing the database and changing its active status [Also mentioned in the text file]
how can i change it and add my own
this what when i try to run the it
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_settings’ doesn’t exist in C………..
Please make sure that you’ve imported the db file!
i have done this yet no progress…please help
then it might be due to your latest version of PHP
Please when I tried Setting the website especially the logo.. I get updated but the image doesn’t change.. any help? Though the pictures get into the folder 📂 but didn’t change on the website.. can you help?
Try clearing up the browser cache!
reload by pressing ctrl+shift+r
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_settings’ doesn’t exist in C……………..
please help
Make sure you’ve established a db connection for this project with the db file that we’ve shared with you!
Ok I will try Thank for your reply.
: mail(): Failed to connect to mailserver at “localhost” port 25, verify your “SMTP” and “smtp_port” setting in php.ini or use ini_set() in C:\xampp\htdocs\eCommerceSite-PHP\forget-password.php on line 73
Your problem is mentioned right there! There’s no mail server configured in this project. Regarding that particular section, users have to do it themselves.
i dont no what i do
sir mujeh solutions btade mujeh zarorat hai jaldi please . Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘p_id’ cannot be null in C:\xampp\htdocs\eCommerceSite-PHP\admin\product-add.php:143 Stack trace: #0 C:\xampp\htdocs\eCommerceSite-PHP\admin\product-add.php(143): PDOStatement->execute(Array) #1 {main} thrown in C:\xampp\htdocs\eCommerceSite-PHP\admin\product-add.php on line 143
Sorry, we’re unable to understand your language. Please prefer using English!
Regarding those mentioned error messages, can we know about your PHP version?
Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘p_id’ cannot be null in C:\xampp\htdocs\eCommerceSite-PHP\admin\product-add.php:143 Stack trace: #0 C:\xampp\htdocs\eCommerceSite-PHP\admin\product-add.php(143): PDOStatement->execute(Array) #1 {main} thrown in C:\xampp\htdocs\eCommerceSite-PHP\admin\product-add.php on line 143
can we know about your PHP version?
Hi, I am not able to login using the email ID and password of the admin given.
It shows: “Email Address does not match”
Please check your db connection and make sure you’ve entered the exact credentials with a capital “P”
Please admin i need your help
Regarding?
#1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
this error is showing after importing database file give a solution
You’ll find your solutions here:
https://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te
I unable to getting solution….
That is still I cannot solve this issue
could you plzz elaborate here too
Found a video on YouTube, you guys can also refer to this video and follow similar steps. Hope it’ll work out!
https://www.youtube.com/watch?v=sZludzF90O8
can I use this for my own business purpose
Nope
please help
Fatal error: Uncaught Error: Undefined constant “DATABASE” in C:\xampp\htdocs\ecoomerse\db.php:8 Stack trace: #0 C:\xampp\htdocs\ecoomerse\action.php(4): include() #1 {main} thrown in C:\xampp\htdocs\ecoomerse\db.php on line 8
Check your db connection, make sure you’ve created a db.
db is created and i can run queries from it.
after creating db, import the given db file.
Good Day
I trust that you are well
What should we do if we would like to use this as my business website after editing the website to my needs
Kind Regards
Only for Educational purposes!
adding to cart not working, popup seys its added but cart empty
there is no coding insert to tbl_order.
You’ll only see data under tbl_order once you checkout! Regarding add to cart system, if it does not show any product under the cart then try adding a new product from the admin panel and try again!
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_settings’ doesn’t exist in…………………
First, create a database named ‘ecommerceweb’ and then import the given db file.
Fatal error: Uncaught mysqli_sql_exception: Table ‘ecom_store.services’ doesn’t exist in C:\xampp\htdocs\ecommerce-website-php\localstore.php:41 Stack trace: #0 C:\xampp\htdocs\ecommerce-website-php\localstore.php(41): mysqli_query(Object(mysqli), ‘select * from s…’) #1 {main} thrown in C:\xampp\htdocs\ecommerce-website-php\localstore.php on line 41
it shows this and men women and localstore doesn’t work.
check your db connection. look like you’ve not set db for the project
Fatal error: Uncaught mysqli_sql_exception: Table ‘ecom_store.services’ doesn’t exist in C:\xampp\htdocs\ecommerce-website-php\localstore.php:41 Stack trace: #0 C:\xampp\htdocs\ecommerce-website-php\localstore.php(41): mysqli_query(Object(mysqli), ‘select * from s…’) #1 {main} thrown in C:\xampp\htdocs\ecommerce-website-php\localstore.php on line 41
please help sir😣
check your db connection. look like you’ve not set db for the project
How to solve this problem?
Fatal error: Uncaught PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: ” for column `ecommerceweb`.`tbl_customer`.`cust_b_country` at row 1 in C………………………
Looks like the LATEST version requires a different DateTime format than the one developers had set on.
Try this: Format date like “Y-m-d H:i:s” in order to work with the MySQL DateTime field.
Could you please tell me where the DateTime field is?
check the database
I could not understand what you mean when you say “LANG_VALUE_…..”. When echoing… I would like to know where are you echoing the values from ..
Well, we don’t know each and every code piece on how the developers of this project made it up. Guess, you’ll have to figure it out by yourself!
Thanks.. i have just figured it out. They are echoed from the tbl_language using there id to make a respon to a particular value
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_settings’ doesn’t exist in C:\xampp……………….
Check your database connection. Make sure you’ve set up a database for the project with the given db file.
after success login, site not go dashboard. its blank page.
Can you help me?
Not sure about this [blank page] issue. Can we know about your PHP version? Cause it looks like it does not work with the latest version of PHP
post deleted…..
Sorry.. what?
Am having trouble in making phone validation tu cust_phone… Can anyone help…
Hello! Do you use Twitter? I’d like to follow you if that would be ok.
I’m absolutely enjoying your blog and look forward to new posts.
Whats the admin password ?? Password@123 it isnt the one tell me pls ty
Its Password@123. We’ve provided you guys with a db file and if you think we’ve provided the wrong login details then please you can check the login details yourself from the given database.
which table to check this admin password?coz when i check it is not there.tq
‘tbl_user‘
Hi. How do I connect payment to my paypal account
you need to have your own PayPal sandbox
Hello Sir after filling registration form and then submit. data is not inserted in database or not any message display that user registration successful.
Not sure about this. Can we know about your PHP version?
yes sure php version :-7.4.21.
please check and help me out.its urgent for my project .
After registration data not posted in database.
help me out please sir.
After registration, customer verification should be done by accessing the database and changing its active status.
Also, make sure that you’ve created a database with right name as mentioned in the text files and import the SQL file.
yes sir i know but after registration button click data not uploaded in database so how i will update active status tell me..
make sure that you’ve created a database with the right name as mentioned in the text files and import the given SQL file.
yes sir i will do same as mentioned but i did not getting the problem. how can i share images for the same.kindly address for the issues.
Sorry, but we cannot understand a thing. Could you please explain it again in detail?
The registration form fill and then click registration button then page get blank and form not submitted in database table. i will provide you the link which error i am facing.(https://we.tl/t-6brYQINBDZ )
please go through the video and help me out. its urgent.
What’s your PHP version?
how can l change the current which php file can help me do that and how does the line of code look like
php version :-7.4.21.
I see there’s no problem with the PHP version. It’s just that we’re unable to identify the problem you’re facing.
The money value appears 1000000
Instead of 1,000,000
How would the number format be edited
Please have a look: https://stackoverflow.com/questions/4013950/print-currency-number-format-in-php
prepare(“SELEC*FROM galeri………………………..
I’m pulling from database 3 tables are not coming
Database not worked
Any error messages?
Hi, how can I remove the share social media button in the main page. I have tried just leave the input field blank but it still appear.
You can simply remove the code lines for that!
consulta SQL: Copiar
CREATE TABLE `tb l_settings` (
`id` int(11……………………………………….
MySQL ha dicho: Documentación
#1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
Please have a look here: https://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te
Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ” for column ‘cust_b_country’ at row 1 in C:\wamp64\www\registration.php on line 151
Get this error every time I try to register a new account to test!
We’ve tested it again, but we didn’t see such error messages. Errors like this might occur due to variations of versions. This project was tested on PHP 5.6 and 7.4
— ——————————————————–
—
— Table structure for table `tbl_settings`
—
CRETE TABLE `tbl_ settings (
`id` int(11) NOT NULL……………….
??
Where is the database init file? I need to change the password in it
The database file is inside the folder “DATABASE FILE” and the config file is under the directory “admin/inc/”
Mine is not null
How to fix this?
Connection error :SQLSTATE[HY000] [1045] Access denied for user ‘root’@’localhost’ (using password: NO)
Fatal error: Uncaught Error: Call to a member function prepare() on string in D:…………..
That’s because you have different server settings. Configure the connection file.
Fatal error: Uncaught Error: Call to a member function prepare() on string in D:\xampp\htdocs\eCommerceSite-PHP\eCommerceSite-PHP\header.php:17 Stack trace: #0 D:………….
how to fix this? thank you in advance
What about db connection?
Good Morning
Please how to configure mailling, SMTP for sending mail ?
please anyone can help me please
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_settings’ doesn’t exist in C…………….
First import the given db file
Hi! Could you please tell me which part of the code below is in? Thank you!
var Tawk_API= Tawk_API………………
It’s tawk.to API. You can google “tawk” to see more about it.
But under localhost, I can’t embed that API, it needs a web page with a specific URL link
Can I change the name of the database in the code file? If possible give me the code file containing the database name. Thank you !
Look for a file naming “config.php”
How can I change the currency into local currency?
Please go through the code lines
Do you know how to login with facebook? (Plugin login)
May I ask what file is the code for sharing the website via social networks?
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_settings’ doesn’t exist in C………………..header.php on line 25
first import the given db file
Hi ! I’m learning about your PHP project, I want to integrate PayPal into this website using http method: https://www.sandbox.paypal.com/vn/home (it’s different from the Stripe method you’re using) but I don’t know of any way to return the order information to the database. Hope you help me. Looking forward to hearing from you soon! Thank you !
cam i learn to know it
where can i learn about full course it
We don’t have it. But, you can get courses at Udemy from a number of other instructors!!
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_ settings’ doesn’t exist in C:………..
first, import the given db file.
Hi,
Can I use your code in my office?
I can pay you for this.
These are only for educational purposes
For people who getting this error Fatal error : Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_settings’ does not exist in C:………………..
I solve using server wamp server and i follow this steps
After you finish downloading the project, unzip the project file and head over to your XAMPP directory.
There you’ll find a folder naming “htdocs”.
Inside the “htdocs” folder, paste the project folder (not the .zip one, but the extracted one).
Open your favorite browser; we recommend using Google Chrome or Mozilla Firefox.
Then, go to URL “http://localhost/phpmyadmin“.
Create a Database with a name that is provided inside the “01 LOGIN DETAILS & PROJECT INFO.txt”.
Click on the “Import” tab and choose the database file (.sql) which is provided under the folder naming “DATABASE FILE”.
After setting up all these, go to URL “http://localhost/[ PROJECT_FOLDER_NAME ]/“
All the login details are provided inside the project folder, check that out and enter them in order to use it.
“http://localhost/[ PROJECT_FOLDER_NAME ]/“
sorry im having troubles accessing this part
oh, come on… This [PROJECT_FOLDER_NAME] is where you have to enter the name of the project folder!!
#1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
PHP version: 7.4.27
phpMyAdmin 5.2.0
please have a look: https://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te
—
— Table structure for table `tbl_ settings`
—
…………………………………………
MySQL said: Documentation
#1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
Please have a look here: https://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_ settings’ doesn’t exist in D:……………….
First, create a database named ‘ecommerceweb’ and then import the given db file!
Connection error :SQLSTATE[HY000] [1045] Access denied for user ‘root’ @’ localhost’ (using password: NO)
Notice: Undefined variable: pdo in C:…………………….
my problem please solve it please
configure the connection file according to your server details
Sir, I could not understand what you mean you say “LANG_VALUE_…..
where?
If we give a wrong password it is checking with the DB and giving an error message if the customer status is not active, it is showing an error message. The only problem is when we enter the correct details it is not getting logged in. On localhost login functionality is working fine but on the live server, login functionality is not working.
NOT for live productions.
How can we make it live though? Can we do that?
We cannot allow that!
Password does not match
Make sure you’ve entered the Admin’s login credentials under Admin Login Panel and not the Customer’s Login Panel! For more: watch the demo video.
How Can I chamge the website name and logo
from Admin Panel!
How can i change the copyright name at the footer
from Admin Panel!
i cant login into admin
Any error messages?
Warning: mail(): Failed to connect to mailserver at “localhost” port 25, verify your “SMTP” and “smtp_port” setting in php.ini or use ini_set() in F: \xampp1 \htdocs \lrritzy\registration.php on line 171
Yeah, the mail server does not work. After registration, you have to activate the account manually [as stated on the text file]
Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_settings’ doesn’t exist in D:………………..
First, create a database named ‘ecommerceweb’ and then import the given db file.
I already Create But Shown an Error on MySQL I Show a error — ———————————————————— Table structure for table `tbl_settings………………………………….
MySQL said: Documentation
#1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In the current row format, the BLOB prefix of 0 bytes is stored inline.
Please update the code Sir.
You can find your solutions here: https://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te
i can seem to understand why you would not include mail sending in the scripts. As there are references to sending emails.
Thanks for this project!
Dear Sir,
I am facing one big problem, whenever I am trying to add product in cart, it is not getting added and in error_log file some problem of session is coming, please help me.
the error is follows:
[26-Feb-2023 04:09:52 America/Boise] PHP Warning: session_start(): Cannot start session when headers already sent in ……………………
How to complete payment gateway
Hello Admin
I Can login with admin account
message: Email Address does not match………….
Looks like you’re trying to log in as an administrator from the customer’s login panel. Please watch the demo video carefully.
I also faced same problem
Please solve my query so that I will work upon that
Looks like you’re trying to log in as an administrator from the customer’s login panel. Please watch the demo video carefully.
Good day, kindly help me with williams password it seems to be in encypted uin the database with md5.
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_settings………………………
How to solve the problem
First, create a database named ‘ecommerceweb’ and import the given db file
Do not work last step Donot show website
Useless
My project failed
👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎👎
Database errors too big row size
Please mention the error message
If we want to change in nav bar then how i can do that ?
Please go through the code lines
is any algorithm used in this project?
Fatal error: Uncaught Error: Call to undefined function get_header() in C:\xampp\htdocs\shop-elite\index.php:15 Stack trace: #0 {main} thrown in C:\xampp\htdocs\shop-elite\index.php on line 15
why?
Hello! Help please. When I fill the database with Russian letters, all these words turn into question mark symbols on the page. It looks like this: ????? ????.
I’ve already tried a lot of things, but I can’t solve this problem in any way.
Mail connect error
help me
Connection error :SQLSTATE[HY000] [1045] Access denied for user ‘root’@’localhost’ (using password: NO)
please help to solve this error
configure the db connection file according to your own server details
Connection error :SQLSTATE[HY000] [1049] Unknown database ‘ecommerceweb’
Warning: Undefined variable $pdo in C…………………….
Create a database named “ecommerceweb” and import the db file.
I have done that before i tested it still threw the error
how can I get the verification code in the login page itself instead of getting it in mail? since there is SMTP error!
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_URI::$config is deprecated
……………………
lots of that type of error
what is solution.
Requires PHP 5, 7 as mentioned in the project overview table.
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_settings………………..
Create a database named ‘ecommerceweb’ and impor the db file
Thanks for the sharing this project source code…. i searching this like project.
does it running?
how about the updated version 8.0.25?
does it still working?
Not sure, we haven’t tested it yet.
Connection error :SQLSTATE[HY000] [1045] Access denied for user ‘root’@’localhost’ (using password: NO)
Warning: Undefined variable $pdo in C:……………..
You have to configure the connection file according to your server details
Getting this error:
PHP Warning: Undefined variable $pdo in C:……………….
nice content… from TechPoth
Hi, can u please help me with this error:
Connection error :SQLSTATE[HY000] [1049] Unknown database ‘ecommerceweb’
Warning: Undefined variable $pdo in C……………..
Create a database named “ecommerceweb” and import the given db file.
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb. tbl_settings’ doesn’t exist in C……………………
I’m getting this error even after setting up the DB and importing the SQL files!!Please help
check the name of db, you might’ve entered the wrong db name..?
hello Sir First Thanks you so much for providing this type content for us…….
and guy’s you don’t have any problem if you first create the database as given database name and then open sql and paste this query on it “SET GLOBAL innodb_strict_mode = 0;” and then import your sql file, you didn’t have any problem to use this awesome project
Hello !!
Sir i have a major issue in this project.. when i run this project in localhost (Xampp,Wamp) its work fine all the things.. but when i host this website in hosting then its user side register, login and add to cart not working. i am very confused about it ..admin panel also log in and database connect successful and admin panel works..only user side make an issue….
NOT FOR LIVE PRODUCTION
Please how can i change the currency . Don’t know exactly the file containing that line of code. Can you help me please
Connection error :SQLSTATE[HY000] [1045] Access denied for user ‘root’@………………
You have to configure the project’s config file according to your own server details.
I get this when i try to register a new customer
Fatal error: Uncaught PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: ” for column `………………….
The URL “http://localhost/phpmyadmin”, is not working
Make sure you’ve started your Xampp server
Thank you Codeastro, thank you Hammad Hassan!
That’s a whole lot of work right there. It works perfectly. Just a few changes and it worked very perfect.
Please note: if you have issues importing sql file, use the insert sql script instead. Create the database “ecommerceweb”, copy the sql script and insert it manually.
Great work honestly. Please if you accept crypto donations to support Codeastro, please provide a link or usdt wallet.
Connection error :SQLSTATE[HY000] [1045] Access denied for user ‘root’@’localhost’ (using password: NO)
having this error.
i just seen above answer of yours regarding this. please elaborate the full solution
Locate the db connection file or config file for the project. and there, you need to update the db connection details according to your own server details.
I’m using PHPMailer to send confirmation links but when I click them I get a 404 page instead of the Confirmation succesful one
Connection error :SQLSTATE[HY000] [1045] Access denied for user ‘root’@’localhost’ (using password: NO)
PLEASEEEEE, I NEED THAT STEP BY STEP HOW TO DO IT, I have tryed everything but i cant solved it.
I reaally need it to know
You have to configure the config file of the project according to your own server details
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘fashionmava.tbl_settings’ doesn’t exist in C:………………..
Import the given db file
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ecommerceweb.tbl_settings’ doesn’t exist in C………………..
Create a database named ‘ecommerceweb’ and import the given sql file
CURRENTLY USING PHP 8.2.4 VERSION BUT PROJECT NOT WORKING PROPRLY WHAT SOLUTION OF THIS ERROR
We’ve only tested this project with PHP 5 and 7.
Object not found!
The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again.
If you think this is a server error, please contact the webmaster.
Error 404
localhost
Apache/2.4.41 (Win64) OpenSSL/1.1.1c PHP/7.4.3
Seems like a 404 error, indicating that the requested URL could not be found on the server. Please double-check the URL for any typos or errors in spelling.
after writing http://localhost/eCommerceSite-PHP/ the site has not loaded completely
Any error messages?
thanks for the code
But I am facing challenge when i click login the page is not loading, and the site is not completed the page.
What do you mean by the site is not completed the page? Can you please explain in detail?
I unable to find the HTML source code in this ……. could you please help me to find this
Why are you searching for HTML files on a PHP Project? There are PHP files, you’ll find all the codes under those php files.
Thank you! This is awesome. But why is the blog missing? I saw it in the database and in the source code, and css, but it was removed and hidden. Can you guys bring it back?
The blog section was kind of not completed, so it was removed.
Hi
Thanks for the code
But is not working for me
after hitting the localhost… is not showing me same page as in video and
When i press on login the page is blank
That’s probably due to your latest version of PHP. This project works well with PHP 5 and 7 as mentioned in the text files and project overview table.
how to change currency (dollar into rupees)
Please go through the codelines and replace the current one with your own
database importing problem bro
can you share those error problems?
database importing problem and there showing this
— ——– Table structure for table `tbl_settings`–CREATE………………..
Open the database file using code editor, search for tbl_settings, and replace all instances of varchar(225) with varchar(100).
can you make admin registeration page for this website
Please help there is no table_setting file in your database Please correct it i have already check
You can view the sql file using text editor, there is table named “tbl_settings”
I can’t able to register and even I can’t able to login with default users
then in adding product, photo is not showing
Make sure you’ve established db connection for this project. We’ve provided db file for the project as well.
You can register a new user and after that Customer Verification should be done by accessing the database and changing its active status.
I can’t login with Email : [email protected] and Password: Password@123 error :
Email Address does not match !!
It looks like you’re trying to log in as a customer using Admin credentials. The login details provided in the text file are only for the Admin login. For customer access, please register a new user. However, to access the admin panel, please use the credentials that we’ve provided in the text file.
can you make a video for changing the currency of this project and how to go to admins dashboard
For admin panel, please check the demo video.
The images are not showing up, i have tried each and every thing, plz guide me
any error or warning messages? also it could be great if you can share those screenshots
can i use your project to deliver work to my client?
Nope
can you help me to change the currency ….. I have changed it in admin panel but not able to change on the customer side
registration of new customers displays and error message
Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ” for column ‘cust_b_country’ at row 1 in C:\xampp\htdocs\eCommerceSite-PHP\registration.php:121 Stack trace: #0 C:\xampp\htdocs\eCommerceSite-PHP\registration.php(121): PDOStatement->execute(Array) #1 {main} thrown in C:\xampp\htdocs\eCommerceSite-PHP\registration.php on line 121