What's new

mysqli

The MySQLi Extension (MySQL Improved) is a relational database driver used in the PHP scripting language to provide an interface with MySQL databases.
There are three main API options when considering connecting to a MySQL database server:

PHP's MySQL Extension
PHP's MySQLi Extension
PHP Data Objects (PDO)The PHP code consists of a core, with optional extensions to the core functionality. PHP's MySQL-related extensions, such as the MySQLi extension, and the MySQL extension, are implemented using the PHP extension framework. An extension typically exposes an API to the PHP developer, to allow its facilities to be used programmatically. However, some extensions which use the PHP extension framework do not expose an API to the PHP developer.
The PDO MySQL driver extension, for example, does not expose an API to the PHP developer, but provides an interface to the PDO layer above it.
MySQLi is an improved version of the older PHP MySQL driver, offering various benefits.The authors of the PHP scripting language recommend using MySQLi when dealing with MySQL server versions 4.1.3 and newer (takes advantage of new functionality).

You do not have permission to view the full content of this post. Log in or register now.
Recent contents
  1. C

    Help Fatal Error MYSQLI

    FIXED
  2. D

    PHP Simple Sales Inventory System

    Simple Sales Inventory System (use for educational purpose only, kayo na bahala magupgrade para sa school project nyo hahaha) Functions -login -add product -edit product -delete product -add stocks -generate sales report (pfd format) -sale products (walk-in) -generate receipt (pdf format)...
  3. D

    Simple Barangay Resident Identification Card System

    Simple Barangay Resident Identification Card System Functions -login -add resident -edit resident -delete resident -generate residents identification card (pdf format) Others -set municipality name -add barangay's name -set barangay captain name xampp version use v8.0.2 Download here
  4. A

    PHP Simple Public Chat Room Using PHP and MySQLi V2 (UPDATED)!!!

    Good Day mga idol! Eto pala yung updated!!! Share ko lang ulit :) This is a simple chat system wherein you can send messages in public and send a private message to every user :) Features: Login Registration User account modification Chat Sending message with embedded emojis :) Sending...
  5. A

    PHP Simple CRUD (create, read, update and delete) System using PHP and MySQLi

    Good Day mga idol! Share ko lang din itong simple CRUD system na ginawa ko last 2019 using PHP and MySQLi :) Change nyo nalang din yung extension file nung crud - pjc.doc from ".doc" to ".zip" :) Hope this helps! -phpDev
  6. A

    PHP Simple Bulk/Multiple Uploading of Files using PHP and MySQLi

    Good Day mga idol! I just want to share this simple but helpful code on how to upload multiple files/attachments using php/mysqli :) change nyo nalang yung extension file from ".doc" to ".zip" Hope this helps :) Kampay! -phpDev
  7. D

    Closed Return to same page after update

    Hi po mga bossing, gusto ko po sanang makita agad yung changes ng update after submit sa same page kung saan ako nag update. Nag research po ako ay ito yung nakita ko, pero di po ako binabalik sa same profile page pag nagupdate po ako. Lumalabas lang yung prompt na "Updated!" tas blank page na...
  8. D

    Closed Mysql two where conditions

    Hello mga bossing, ano po kaya ang mali sa query ko? May search box po kasi ako, tas kailanga ko lang lahat ng results ay status='Active'. $query = "SELECT * FROM `firm` WHERE CONCAT(`fname`, `lname`, `age`, `position`) AND (status = 'Active') LIKE '%".$valueToSearch."%'"; Salamat po!
  9. D

    Closed Insert two values in 1 dropdown selection

    Hello mga bossing, pano po ako makakakuha ng dalawang output sa isang dropdown selection para ma push sa dalawan db columns pag submit? <select name="code" id="drop" type="text"> <option value="alpha">Alpha</option> <option value="tango">Tango</option>...
  10. D

    Closed Insert update from one table to another table

    Hello po mga bossing, may ginagawa po akong parang feedback/comment system para po sa different topic na e-po-post. Gamit ang tbl1, nakakapag-update po ako ng walang problema. Yung kailangan kulang pong gawin e-insert din po pag-submit ang laman ng $1_id, $name1, $comments1, $com_timestamp1 ni...
  11. T

    Closed How to disable date in datepicker already added from database?help please for my thesis

    Patulong sa mga web developer please para lang po sa thesis. Gusto ko po sana disable yung date na select na ng user maximum of 3 reservation in same date. Example If meron na 3 reservation in same date dapat po naka disbable na sya hindi na po clickable. Please patulong po checking po kasi...
  12. D

    Closed Database insert doesn't align in row

    Hello Po, nag-aaral po ako mag PHP and gumawa ng simple na attachment app. Pero everytime po ako nag papasok sa DB, nag a-add po ng separate row yung attachment link na dapat po sa iisang row lang. DB: CREATEDATABASE`order` CREATETABLE`item` id INT(3) UNSIGNED AUTO_INCREMENT PRIMARY KEY, name...
  13. S

    Closed CRUD (Create Read Update Delete) using bootsrap

    para sa mga baguhang kagaya ko. :D at sa mga may instructor na nagmamagalin, hindi naman makapagturo ng maayos. :D mas madali matuto sa debugging. just saying. :D visit the video on YøùTùbé nasa description yung download link. :D or just download it here: source code : http://adf.ly/1ZSzLC...
  14. D

    Tutorial How to install PHP extension MySQLi on cPanel/WHM using EasyApache Exhaustive Options List

    To install PHP extension MySQLi using EachApache: Login to WHM as 'root' user. Either search for "EasyApache" or go to Software > EasyApache Scroll down and select a build option (Previously Saved Config) Click Start "Start customizing based on profile" Select the version of Apache and click...
Back
Top