PDO SQL server connection and execution of stored procedures: want to connect execute sql queries and stored procedures

Recommend this page to a friend!

All requests

PDO SQL server connection and executi...

Request new recommendation

Featured requests

No recommendations

PDO SQL server connection and execution of stored procedures #sql server

Edit

by Faisal gali - 9 years ago (2015-11-18)

want to connect execute sql queries and stored procedures

+5	I want to connect execute SQL queries and stored procedures on MS SQL server. Also I should receive the returned values from SQL server.

Ask clarification

4 Recommendations

DbUtils: Access and Manage MySQL, PostgreSQL or MS SQL

This package can Access and Manage MySQL, PostgreSQL or Microsoft SQL database using PHP Data Objects (PDO).

It can establish database connections extending PDO class and perform several types of queries.

The class can execute arbitrary queries, select queries that return one row, queries that return a range of result set rows, execute INSERT and UPDATE queries, retrieve the last inserted record identifier or the next record sequence value, begin, commit and rollback transactions.

+4	by Kakhaber Kashmadze package author 45 - 9 years ago (2015-12-21) Comment I just added MicrosoftSQL support to my dbutils class if not jet updated on github is also source package where is kakhavk user for my page

Easy Mysqli OO: Execute common SQL queries using MySQLi extension

This class can execute common SQL queries using MySQLi extension.

It can connect to a MySQL database using the MySQLi extension and can execute common queries.

Currently it can SELECT, INSERT, UPDATE and DELETE queries using parameters that define tables, fields, field values, condition clauses, etc..

+2	by Allan Klaus package author 35 - 9 years ago (2015-12-03) Comment Use my class, use the method query passing a string with the command like "CALL MY_PROCEDURE()" and it will run the stored procedure to you.

1 Comment
3. by Dave Smith - 9 years ago (2015-12-05) in reply to comment 2 by Allan Klaus Reply
The requester wants to use PDO, not MySQLi

DB Abstract Model: Execute MySQL queries calling stored procedures

Execute MySQL queries calling stored procedures.

It can connect to a given MySQL database server using PDO.

The class can execute a stored procedure and return all the results in an array.

+2	by guillermo murillo package author 35 - 9 years ago (2015-11-30) Comment Execute MySQL queries calling stored procedures. It can connect to a given MySQL database server using PDO. The class can execute a stored procedure and return all the results in an array.

1 Comment
1. by Dave Smith - 9 years ago (2015-12-01) Reply
The requester wants to connect to a MSSQL server, not MySQL.

Database Manager: Connect and query several databases using PDO

This package connect and Query several databases using PDO.

There is a base class that can establish connections to different databases using PDO. Currently it supports MySQL, PostgreSQL, SQL Server and SQLite.

The query sub-class extends the connection class can execute arbitrary queries and retrieve the results as an array or a string.