php and mysql Archives

This PHP tutorial help to create an HTML listing using the PostgreSQL database. It's very simple and easy to create HTML listing using PHP, as like other databases used, except PostgreSQL database connection string and Postgres method to fetch data.PHP provides PostgreSQL libs to communicate PHP with Postgres database. We will follow the following steps to integrate PostgreSQL with php. Enable Postgres module from php.ini fileCreate connection string using postgres database.Get data and display into an HTML template. How to Enable postgres data in php.ini we will enable postgres extension from php.ini file, we will un-comment the below the lines. uncommented, extensionphp_pdo_pgsql.dll, uncommented, extensionphp_pgsql.dll, uncommented, extension_dir "c:/wamp/bin/php/php5.3.5/ext/", Note: You can read second part : jQuery Ajax Add, Edit and Delete Using PHP and PostgreSQL How to Connect Postgres Database with PHP We will use pg_connect method to create a database connection with PostgreSQL. I will pass dbhost, db name, port and password. We have created a 'test' database and created employees using the below script. CREATE TABLE employee ( id char(5), employee_name varchar(100), employee_salary integer, employee_age integer, CONSTRAINT code_title PRIMARY KEY(id) ); we will create connection.php file and add the below code, servername "localhost"; $this->username "test"; $this->password "test123"; $this->dbname "test"; $this->port "5432"; } function getConnstring() { $con pg_connect("host".$this->servername." port".$this->port." dbname".$this->dbname." user".$this->username." password".$this->password."") or die("Connection failed: ".pg_last_error()); /* check connection */ if (pg_last_error()) { printf("Connect failed: %s\n", pg_last_error()); exit(); } else { $this->conn $con; } return $this->conn; } } ?> We will create response.php file and add the below code to access data records from PostgreSQL table. include("connection.php"); class Employee { protected $conn; protected $data array(); function __construct() { $db new dbObj(); $connString $db->getConnstring(); $this->conn $connString; } public function getEmployees() { $sql "SELECT * FROM employee"; $queryRecords pg_query($this->conn, $sql) or die("error to fetch employees data"); $data pg_fetch_all($queryRecords); return $data; } } Included connection.php file at the top of file, This file used to access the Postgres database connection object. We have defined the Employee class and assigned the connection object into a class variable. Finally, created getEmployees() method to access employee data from the postgres database and return data. We will use this method later on into index.php file to get results set. We will create index.php and included required css and js libs files. We will import response.php file to access data from postgres using the method. getEmployees(); ?> Now, we have all employee's data in $emps php variable. We will iterate on $emps array and bind data with html table column using foreach() method. Name Salary Age Action $emp) Edit Delete View You can download the source code and see Demo from the below link. Download Source Code Conclusion: We have enabled postgres database driver into php using php.ini file, Also created a database connection object using pg_connect() method, fetched data from postgres database using PHP and display into HTML table.

php and mysql

Simple Poll Example Using PHP, Bootstrap and MySQLi

HTML Table Listing Using PHP and PostgreSQL Database

Categories

php and mysql

Simple Poll Example Using PHP, Bootstrap and MySQLi

HTML Table Listing Using PHP and PostgreSQL Database

Categories

Headline