PHP GuestBook with Database: GuestBook application using MySQL to store posts

Recommend this page to a friend!

Download .zip

Info

Example

View files (526)

Download .zip

Reputation

Support forum

Blog

Links

Last Updated		Ratings				Unique User Downloads		Download Rankings
2023-12-01 (1 month ago)		Not yet rated by the users				Total: 38		All time: 10,827 This week: 112

Version		License		PHP version		Categories
`guestbook` 1.0		Custom (specified...		7		Content management, PHP 7, Applications

Description

Author

Faris AL-Otabi

This package provides a GuestBook application using MySQL to store posts.

It implements an application based on the CodeIgniter framework to provide a web interface to let users post comments in a guest book.

The package is configured to use the MySQL database to store posts in database tables accessed via the PHP MySQLi extension.

Faris AL-Otabi

Performance

Level

Name:	Faris AL-Otabi `<contact>`
Classes:	12 packages by Faris AL-Otabi
Country:	Saudi Arabia

Level 3

Innovation award

Nominee: 3x

Example


<?php



// Valid PHP Version?

$minPHPVersion = '7.3';

if (version_compare(PHP_VERSION, $minPHPVersion, '<'))

{

    die("Your PHP version must be {$minPHPVersion} or higher to run CodeIgniter. Current version: " . PHP_VERSION);

}

unset($minPHPVersion);



// Path to the front controller (this file)

define('FCPATH', __DIR__ . DIRECTORY_SEPARATOR);



/*

 *---------------------------------------------------------------

 * BOOTSTRAP THE APPLICATION

 *---------------------------------------------------------------

 * This process sets up the path constants, loads and registers

 * our autoloader, along with Composer's, loads our constants

 * and fires up an environment-specific bootstrapping.

 */



// Ensure the current directory is pointing to the front controller's directory

chdir(__DIR__);



// Load our paths config file

// This is the line that might need to be changed, depending on your folder structure.

require realpath(FCPATH . '../app/Config/Paths.php') ?: FCPATH . '../app/Config/Paths.php';

// ^^^ Change this if you move your application folder



$paths = new Config\Paths();



// Location of the framework bootstrap file.

$bootstrap = rtrim($paths->systemDirectory, '\\/ ') . DIRECTORY_SEPARATOR . 'bootstrap.php';

$app       = require realpath($bootstrap) ?: $bootstrap;



/*

 *---------------------------------------------------------------

 * LAUNCH THE APPLICATION

 *---------------------------------------------------------------

 * Now that everything is setup, it's time to actually fire

 * up the engines and make this app do its thang.

 */

$app->run();

Details

GuestBook

Simple Guest Book Software created using PHP

How to use

```
Update composer
composer update
```
Update .env
Migrate database

php spark migrate

Screenshot

![](https://a.top4top.io/p_1880eoxe51.png)

Copyright

Faris AL-Otaibi - 2021

Files

File	Role	Description
`app` (3 files, 7 directories)
`public` (4 files, 1 directory)
`system` (10 files, 34 directories)
`writable` (1 file, 4 directories)
`.env.example`	Data	Auxiliary data
`composer.json`	Data	Auxiliary data
`composer.lock`	Data	Auxiliary data
`LICENSE`	Lic.	License text
`phpunit.xml.dist`	Data	Auxiliary data
`README.md`	Doc.	Documentation
`spark`	Example	Example script

File	Role	Description
`Config` (31 files, 1 directory)
`Controllers` (3 files)
`Database` (1 directory)
`Entities` (1 file)
`Language` (1 directory)
`Models` (1 file)
`Views` (1 file, 4 directories)
`.htaccess`	Data	Auxiliary data
`Common.php`	Aux.	Auxiliary script
`index.html`	Doc.	Documentation

File	Role	Description
`Boot` (3 files)
`App.php`	Class	Class source
`Autoload.php`	Class	Class source
`Cache.php`	Class	Class source
`Constants.php`	Aux.	Auxiliary script
`ContentSecurityPolicy.php`	Class	Class source
`Database.php`	Class	Class source
`DocTypes.php`	Class	Class source
`Email.php`	Class	Class source
`Encryption.php`	Class	Class source
`Events.php`	Example	Example script
`Exceptions.php`	Class	Class source
`Filters.php`	Class	Class source
`ForeignCharacters.php`	Class	Class source
`Format.php`	Class	Class source
`Generators.php`	Class	Class source
`Honeypot.php`	Class	Class source
`Images.php`	Class	Class source
`Kint.php`	Class	Class source
`Logger.php`	Class	Class source
`Migrations.php`	Class	Class source
`Mimes.php`	Class	Class source
`Modules.php`	Class	Class source
`Pager.php`	Class	Class source
`Paths.php`	Class	Class source
`Routes.php`	Example	Example script
`Security.php`	Class	Class source
`Services.php`	Class	Class source
`Toolbar.php`	Class	Class source
`UserAgents.php`	Class	Class source
`Validation.php`	Class	Class source
`View.php`	Class	Class source

File	Role	Description
`development.php`	Aux.	Auxiliary script
`production.php`	Aux.	Auxiliary script
`testing.php`	Aux.	Auxiliary script

File	Role	Description
`BaseController.php`	Class	Class source
`Home.php`	Class	Class source
`Post.php`	Class	Class source

File	Role	Description
`errors` (2 directories)
`Home` (1 file)
`Pages` (1 file)
`Posts` (2 files)
`base.php`	Example	Example script

File	Role	Description
`error_404.php`	Aux.	Auxiliary script
`error_exception.php`	Example	Example script
`production.php`	Aux.	Auxiliary script

File	Role	Description
`debug.css`	Data	Auxiliary data
`debug.js`	Data	Auxiliary data
`error_404.php`	Aux.	Auxiliary script
`error_exception.php`	Example	Example script
`production.php`	Aux.	Auxiliary script

File	Role	Description
`add.php`	Example	Example script
`index.php`	Example	Example script

File	Role	Description
`images` (2 files)
`.htaccess`	Data	Auxiliary data
`favicon.ico`	Data	Auxiliary data
`index.php`	Example	Example script
`robots.txt`	Doc.	Documentation

File	Role	Description
`API` (1 file)
`Autoloader` (2 files)
`Cache` (2 files, 2 directories)
`CLI` (6 files, 1 directory)
`Commands` (2 files, 7 directories)
`Config` (11 files)
`Database` (17 files, 5 directories)
`Debug` (4 files, 1 directory)
`Email` (1 file)
`Encryption` (2 files, 2 directories)
`Events` (1 file)
`Exceptions` (11 files)
`Files` (1 file, 1 directory)
`Filters` (5 files, 1 directory)
`Format` (4 files, 1 directory)
`Helpers` (13 files)
`Honeypot` (1 file, 1 directory)
`HTTP` (19 files, 2 directories)
`I18n` (2 files, 1 directory)
`Images` (2 files, 2 directories)
`Language` (1 file, 1 directory)
`Log` (1 file, 2 directories)
`Modules` (1 file)
`Pager` (3 files, 2 directories)
`RESTful` (3 files)
`Router` (4 files, 1 directory)
`Security` (2 files, 1 directory)
`Session` (2 files, 2 directories)
`Test` (12 files, 3 directories)
`ThirdParty` (3 directories)
`Throttle` (2 files)
`Typography` (1 file)
`Validation` (6 files, 2 directories)
`View` (7 files, 1 directory)
`.htaccess`	Data	Auxiliary data
`BaseModel.php`	Class	Class source
`bootstrap.php`	Example	Example script
`CodeIgniter.php`	Class	Class source
`Common.php`	Class	Class source
`ComposerScripts.php`	Class	Class source
`Controller.php`	Class	Class source
`Entity.php`	Class	Class source
`index.html`	Doc.	Documentation
`Model.php`	Class	Class source

File	Role	Description
`Autoloader.php`	Class	Class source
`FileLocator.php`	Class	Class source

File	Role	Description
`Exceptions` (2 files)
`Handlers` (7 files)
`CacheFactory.php`	Class	Class source
`CacheInterface.php`	Class	Class source

File	Role	Description
`CacheException.php`	Class	Class source
`ExceptionInterface.php`	Class	Class source

File	Role	Description
`BaseHandler.php`	Class	Class source
`DummyHandler.php`	Class	Class source
`FileHandler.php`	Class	Class source
`MemcachedHandler.php`	Class	Class source
`PredisHandler.php`	Class	Class source
`RedisHandler.php`	Class	Class source
`WincacheHandler.php`	Class	Class source

File	Role	Description
`Exceptions` (1 file)
`BaseCommand.php`	Class	Class source
`CLI.php`	Class	Class source
`CommandRunner.php`	Class	Class source
`Commands.php`	Class	Class source
`Console.php`	Class	Class source
`GeneratorTrait.php`	Class	Class source

File	Role	Description
`Cache` (2 files)
`Database` (6 files)
`Encryption` (1 file)
`Generators` (12 files, 1 directory)
`Housekeeping` (2 files)
`Server` (2 files)
`Utilities` (2 files)
`Help.php`	Class	Class source
`ListCommands.php`	Class	Class source

File	Role	Description
`ClearCache.php`	Class	Class source
`InfoCache.php`	Class	Class source

File	Role	Description
`CreateDatabase.php`	Class	Class source
`Migrate.php`	Class	Class source
`MigrateRefresh.php`	Class	Class source
`MigrateRollback.php`	Class	Class source
`MigrateStatus.php`	Class	Class source
`Seed.php`	Class	Class source

File	Role	Description
`Views` (9 files)
`CommandGenerator.php`	Class	Class source
`ConfigGenerator.php`	Class	Class source
`ControllerGenerator.php`	Class	Class source
`EntityGenerator.php`	Class	Class source
`FilterGenerator.php`	Class	Class source
`MigrateCreate.php`	Class	Class source
`MigrationGenerator.php`	Class	Class source
`ModelGenerator.php`	Class	Class source
`ScaffoldGenerator.php`	Class	Class source
`SeederGenerator.php`	Class	Class source
`SessionMigrationGenerator.php`	Class	Class source
`ValidationGenerator.php`	Class	Class source

File	Role	Description
`command.tpl.php`	Aux.	Auxiliary script
`config.tpl.php`	Aux.	Auxiliary script
`controller.tpl.php`	Aux.	Auxiliary script
`entity.tpl.php`	Aux.	Auxiliary script
`filter.tpl.php`	Aux.	Auxiliary script
`migration.tpl.php`	Aux.	Auxiliary script
`model.tpl.php`	Aux.	Auxiliary script
`seeder.tpl.php`	Aux.	Auxiliary script
`validation.tpl.php`	Aux.	Auxiliary script

File	Role	Description
`ClearDebugbar.php`	Class	Class source
`ClearLogs.php`	Class	Class source

File	Role	Description
`rewrite.php`	Aux.	Auxiliary script
`Serve.php`	Class	Class source

File	Role	Description
`Namespaces.php`	Class	Class source
`Routes.php`	Class	Class source

File	Role	Description
`AutoloadConfig.php`	Class	Class source
`BaseConfig.php`	Class	Class source
`BaseService.php`	Class	Class source
`Config.php`	Class	Class source
`DotEnv.php`	Class	Class source
`Factories.php`	Class	Class source
`Factory.php`	Class	Class source
`ForeignCharacters.php`	Class	Class source
`Routes.php`	Example	Example script
`Services.php`	Class	Class source
`View.php`	Class	Class source

File	Role	Description
`Exceptions` (3 files)
`MySQLi` (6 files)
`Postgre` (6 files)
`SQLite3` (7 files)
`SQLSRV` (6 files)
`BaseBuilder.php`	Class	Class source
`BaseConnection.php`	Class	Class source
`BasePreparedQuery.php`	Class	Class source
`BaseResult.php`	Class	Class source
`BaseUtils.php`	Class	Class source
`Config.php`	Class	Class source
`ConnectionInterface.php`	Class	Class source
`Database.php`	Class	Class source
`Forge.php`	Class	Class source
`Migration.php`	Class	Class source
`MigrationRunner.php`	Class	Class source
`ModelFactory.php`	Class	Class source
`PreparedQueryInterface.php`	Class	Class source
`Query.php`	Class	Class source
`QueryInterface.php`	Class	Class source
`ResultInterface.php`	Class	Class source
`Seeder.php`	Class	Class source

File	Role	Description
`DatabaseException.php`	Class	Class source
`DataException.php`	Class	Class source
`ExceptionInterface.php`	Class	Class source

File	Role	Description
`Builder.php`	Class	Class source
`Connection.php`	Class	Class source
`Forge.php`	Class	Class source
`PreparedQuery.php`	Class	Class source
`Result.php`	Class	Class source
`Utils.php`	Class	Class source

File	Role	Description
`Toolbar` (2 directories)
`Exceptions.php`	Class	Class source
`Iterator.php`	Class	Class source
`Timer.php`	Class	Class source
`Toolbar.php`	Class	Class source

File	Role	Description
`BaseCollector.php`	Class	Class source
`Config.php`	Class	Class source
`Database.php`	Class	Class source
`Events.php`	Class	Class source
`Files.php`	Class	Class source
`History.php`	Class	Class source
`Logs.php`	Class	Class source
`Routes.php`	Class	Class source
`Timers.php`	Class	Class source
`Views.php`	Class	Class source

File	Role	Description
`toolbar.css`	Data	Auxiliary data
`toolbar.js`	Data	Auxiliary data
`toolbar.tpl.php`	Example	Example script
`toolbarloader.js.php`	Aux.	Auxiliary script
`_config.tpl`	Data	Auxiliary data
`_database.tpl`	Data	Auxiliary data
`_events.tpl`	Data	Auxiliary data
`_files.tpl`	Data	Auxiliary data
`_history.tpl`	Data	Auxiliary data
`_logs.tpl`	Data	Auxiliary data
`_routes.tpl`	Data	Auxiliary data