Store engine in php

Share and discover the latest news about the PHP ecosystem and its community. Please respect r/php’s rules.

Hey. I would like to present you a new project of an open source online store. We recently made an alpha release, and we have something to show.

Why did we start this project? This is the main question.

There are not many open source projects in the world that are focused on creating online stores. We have been developing online stores on other platforms for many years, and have come to understand that in the modern form, platforms are full of complex manipulations in order to produce simple everyday things. To perform a simple action, you need to jump through the menu. This greatly reduces the productivity of the store manager and increases the likelihood of errors.

We decided that these disadvantages would turn into advantages on our platform. We initially devote a lot of time to ergonomics, while maintaining the basic functionality. We make many solutions for the first time in online stores in open source code. And that’s great. After all, now you can simply manage complex things. Product addition becomes easier. Discounts are easily manageable. Characteristics for goods are much easier to create. Many familiar actions are greatly simplified, and at the same time their functionality is even more than usual we are used to seeing.

And we intend to continue to move forward. We believe that our decision will benefit people. We make a lot of effort for this. On January 1, 2021, we released our first Alpha release. You can watch a demo on our website.

Источник

PHP E-Commerce Multi-store engine

I need advice with e-commerce engine which will allow create multisite internet-shops. (When client have several shop in his e-commerce net)

Shops have same design templates
Each shops which of them have own administrator, who can fill his shop separately with content.
Gloabal admin can give\stop rights to admins of shops
Users have single registration in the sistem, so being registered in one shop, you can use this login in any of them.

I have experience with ShopCart and VamShop (russian osCommerce fork), but both of them have single shop functions, and if I will setup several copies of them, I can solve tasks 1 and 2, but will meet problems with 3 and 4.

What solution\aproach can you advice for me?

PS: It’s important, that it must be PHP-based engine.

Answer

Solution:

You may try PHPMall and Kodemall. Both of them supports multi-vendor features, and bot of them are not cheap. I purchased PHPMall last year, and I personally didn’t like the codes was constructed (not MVC, and many deprecated functions). It is working though, I just found it hard to modify because of the «dirty» programming style so I decided to create my own. I haven’t tried Kodemall, which is based on OpenCart ecommerce script.

Answer

Solution:

Magento will be a good choice to solve your problem.

For its community version, requirement 1 and 4 is already there. And an extension installed will easily give you the solution for 2 and 3.

And its enterprise version and professional version will contain these functions but charges for license per year.

Answer

Solution:

PrestaShop 1.5 will soon be released.

As you can see on the roadmap, the last missed feature is the Multi-store management.

Multi-store management: With options for multiple currencies, multiple languages and multiple domains, multi-store management will be complete, efficient and integrated into PrestaShop. Multi-store will allow any merchant, regardless of its size to manage multiple stores from a single Back Office.

So i suggest you to stay tuned.

P.S.: An alternative is, however, Magento.

EDIT: Prestashop 1.5 final version has been released: DOWNLOAD

Additional Information:

Didn’t find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor — hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

HTML

HTML (English «hyper text markup language» — hypertext markup language) is a special markup language that is used to create sites on the Internet. Browsers understand html perfectly and can interpret it in an understandable way. In general, any page on the site is html-code, which the browser translates into a user-friendly form. By the way, the code of any page is available to everyone.
https://www.w3.org/html/

Welcome to programmierfrage.com

programmierfrage.com is a question and answer site for professional web developers, programming enthusiasts and website builders. Site created and operated by the community. Together with you, we create a free library of detailed answers to any question on programming, web development, website creation and website administration.

Get answers to specific questions

Ask about the real problem you are facing. Describe in detail what you are doing and what you want to achieve.

Help Others Solve Their Issues

Our goal is to create a strong community in which everyone will support each other. If you find a question and know the answer to it, help others with your knowledge.

Источник

How does MySQL works in PHP?

In short, all your content is stored in a MySQL database in your hosting account. The PHP programming language receives that request, makes a call to the MySQL database, obtains the requested information from the database, and then presents the requested information to your visitors through their web browsers.

What is the main difference between InnoDB and MyISAM storage engines in MySQL?

InnoDB has row-level locking, MyISAM can only do full table-level locking. InnoDB has better crash recovery. MyISAM has FULLTEXT search indexes, InnoDB did not until MySQL 5.6 (Feb 2013). InnoDB implements transactions, foreign keys and relationship constraints, MyISAM does not.

What are the storage engine used by MySQL?

MySQL 8.0 Supported Storage Engines

InnoDB : The default storage engine in MySQL 8.0.
MyISAM : These tables have a small footprint.
Memory : Stores all data in RAM, for fast access in environments that require quick lookups of non-critical data.
CSV : Its tables are really text files with comma-separated values.

What is the difference between MySQL and PHP?

The main difference between PHP and MySQL is that PHP is a scripting language, whereas MySQL is a relational database management system. As stated, PHP is a server-side scripting language. A server-side scripting language allows the user to embed little programs or scripts into the HTML of a Web page.

How do I change my database engine to InnoDB?

Access phpMyAdmin and select your database. Then click on SQL, place the following query and click on Go: ALTER TABLE my_table ENGINE = InnoDB; If the query is executed properly, the database engine of the table will be changed to InnoDB.

What is MySQL engine in PHP?

A storage engine is a software module that a database management system uses to create, read, update data from a database. There are two types of storage engines in MySQL: transactional and non-transactional. For MySQL 5.5 and later, the default storage engine is InnoDB.

Saved searches

Use saved searches to filter your results more quickly

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.

eMarket Online Store. It is a free online shop engine. Make the best online shop with us. Join our Open Source community. Together we will make the best free e-commerce solution.

License

musicman3/eMarket

This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

Please sign in to use Codespaces.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching Xcode

If nothing happens, download Xcode and try again.

Launching Visual Studio Code

Your codespace will open once ready.

There was a problem preparing your codespace, please try again.

Latest commit

Git stats

Files

Failed to load latest commit information.

README.md

eMarket Online Store — It is a free online shop engine

N|Solid

OS Unix, Linux or Windows
Apache Web Server >= 2.4 or Nginx >= 1.17
PHP >= 8.2
MySQL >= 5.7.8 || MariaDB >= 10.2.3 || PostgreSQL >= 15.0 || SQLite >= 3.0
Javascript >= ES7
HTML 5

PHP extensions and settings:

curl
gd
json
SPL
max_input_vars >=5000
pdo_mysql (for MySQL or MariaDB)
pdo_pgsql (for PostgreSQL)
pdo_sqlite (for SQLite)

Vanilla JS
Bootstrap 5
ChatGPT integration
SQL + noSQL concept for query optimization (JSON fields)
Development in error_reporting(-1) mode (show all errors)

PHP Standards Recommendations Used:

PSR-1 (Basic Coding Standard)
PSR-3 (Logger Interface)
PSR-4 (Autoloading Standard)
PSR-5 (PHPDoc Standard)
PSR-6 (Caching Interface)
PSR-12 (Extended Coding Style Guide)
PSR-19 (PHPDoc tags)
PSR-20 (Clock)

Download the Preinstaller file here:

Источник

Store engine in php