How to use HExecuteSQLQuery() in WEBDEV PHP?

Can someone please write a working example of how to use HExecuteSQLQuery() in WEBDEV PHP?

Hi,

Is there something you're not telling us that prompted your question, like what DB are you using and have you already tried anything yourself?

You would develop a PHP site in the same way as any other site; i.e. using WLanguage.

[help.windev.com]
[help.windev.com]

Regards,
Darren.

[doc.windev.com]

[infosonline.net]

All examples of the HExecuteSQLQuery() function in the documentation use the "Data Source" variable type, which is not supported in the PHP configuration.

I need a piece of code like this example, that works in PHP/MySQL:

QRY is Data Source
sMyQry is string = "SELECT * FROM ZIPCODES LIMIT 10" // The SQL query must be specified in this way...
 
HExecuteSQLQuery(QRY, hQueryDefault, sMyQry) // how to write this line in PHP configuration?
HReadFirst(QRY) // is it ok?
Info("here I need value of second colon in first row of query")



Edited 4 time(s). Last edit at 01/10/2023 07:51AM by Marijan Tomasic.

I switched to the SQLxxx set of functions, which can do what I wanted.
If someone knows the answer to my question, please write... maybe it will be useful to someone.

This may help you, however, I do not know if is going to work or it is what you need.
You need to create the variables

// Connect to the database
$connection = hConnectToSQLite("mydatabase.db");

// Define the SQL query
$query = "SELECT * FROM mytable WHERE id = ?";

// Define the parameters for the query
$params = array(1);

// Execute the query
$result = HExecuteSQLQuery($query, $params, $connection);

// Check for errors
if (!$result) {
echo hErrorInfo($connection);
return;
}

// Fetch the result
$data = hReadSQLRecord($result);

// Close the connection
hCloseSQLConnection($connection);


In this example, we first connect to an SQLite database named "mydatabase.db" using the hConnectToSQLite() function. Then we define a query that selects all columns from a table named "mytable" where the "id" column is equal to 1. The parameter of the query is passed as an array of parameters.

Then we use the HExecuteSQLQuery() function to execute the query. If the function returns false, it means an error occurred and we can use the hErrorInfo() function to get more information about the error. If the function returns a valid result, we use the hReadSQLRecord() function to fetch the result, and finally close the connection using hCloseSQLConnection().