A basic example to create a search feature in php
bootstrap version
vanilla html
For this step, you will need composer. Install composer and runs the next line (in the root folder of the project)
You chould change the values indicates with **
composer init
Welcome to the Composer config generator
Package name (<vendor>/<name>) : **jorge/example-search**
Description []:
Author <you name>, n to skip]:
Minimum Stability []:
Package Type (e.g. library, project, metapackage, composer-plugin) []: **project**
License []: **MIT**
Define your dependencies.
Would you like to define your dependencies (require) interactively yes?
Search for a package: **eftec/bladeone**
Enter the version constraint to require (or leave blank to use the latest version):
Using version ^3.37 for eftec/bladeone
Enter package # to add, or the complete package name if it is not listed: **eftec/bladeone**
Enter the version constraint to require (or leave blank to use the latest version):
Using version ^1.33 for eftec/pdoone
Search for a package:
Would you like to define your dev dependencies (require-dev) interactively yes? **no**
{
"name": "jorge/example-search",
"type": "project",
"require": {
"eftec/bladeone": "^3.37",
"eftec/pdoone": "^1.33"
},
"license": "MIT",
"authors": [
{
"name": "you",
"email": "you email"
}
]
}
Do you confirm generation yes? **yes**
Would you like the vendor directory added to your .gitignore yes? **yes**
Would you like to install dependencies now yes? **yes**
Loading composer repositories with package information
Updating dependencies (including require-dev)
It will create a file called composer.json. It also will create a folder called vendor (with the libraries)
📁 root project
📁 composer.json (created in the previous step)
---- 📁 vendor (created in the previous step)
____ 📁 compiles
____ 📁 views
including vendor/autoload.php will deal with all the (ahem) includes. :-3
include "vendor/autoload.php";We will use PdoOne to connect to the database. Type of database :mysql, server =127.0.0.1, user=root, password =abc.123, database=sakila (you must change it according your config)
use eftec\PdoOne;
$pdoOne=new PdoOne('mysql','127.0.0.1','root','abc.123','sakila');
$pdoOne->connect();If the table does not exist, then it will create.
It also will add example data.
if (!$pdoOne->tableExist('test_products')) {
// No, then let's create a new table
$pdoOne->createTable('test_products'
,['idProduct'=>'int not null','name'=>'varchar(50)']
,['idProduct'=>'PRIMARY KEY']);
// and let's add some example data
$pdoOne->insertObject('test_products', ['idProduct'=>1,'name'=>'Cocacola']);
$pdoOne->insertObject('test_products', ['idProduct'=>2,'name'=>'Fanta']);
// another way to insert values
$pdoOne->set(['idProduct','i',3,'name','s','Sprite'])
->insert('test_products');
}We will use BladeOne for view.
It will use the folders views and compiles (created in a previous step).
use eftec\bladeone\BladeOne;
$blade=new BladeOne();The view is called "list", so we must create the next file (in the folder views/)
views/list.blade.php
<body>
....
</body>
We will pass to the view the next data searchText and Result.
echo $blade->run('list'
,[
'searchText'=>$searchText
,'result'=>$result
]);See search.php or search_bootstrap.php file
<?php /** @noinspection PhpUnhandledExceptionInspection */
use eftec\bladeone\BladeOne;
use eftec\PdoOne;
include "vendor/autoload.php";
$pdoOne=new PdoOne('mysql','127.0.0.1','root','abc.123','sakila');
$pdoOne->connect();
// Does the table exist?
if (!$pdoOne->tableExist('test_products')) {
// No, then let's create a new table
$pdoOne->createTable('test_products'
,['idProduct'=>'int not null','name'=>'varchar(50)']
,['idProduct'=>'PRIMARY KEY']);
// and let's add some example data
$pdoOne->insertObject('test_products', ['idProduct'=>1,'name'=>'Cocacola']);
$pdoOne->insertObject('test_products', ['idProduct'=>2,'name'=>'Fanta']);
// another way to insert values
$pdoOne->set(['idProduct','i',3,'name','s','Sprite'])
->insert('test_products');
}
$button=@$_POST['button'];
if($button) {
// we press the button
$searchText=@$_POST['searchText'];
$result=$pdoOne->select('*')->from('test_products')->where('name like ?',["%$searchText%"])->toList();
if($result===false) {
// result is false if the operation failed.
$result=[];
}
} else {
$searchText='';
$result=$pdoOne->select('*')->from('test_products')->toList();
}
$blade=new BladeOne();
echo $blade->run('list'
,[
'searchText'=>$searchText
,'result'=>$result
,'count'=>count($result)
]);
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent