One day I was googling to understand when a prepared statment should be used. As I searched online many claimed that you should use always prepared statments. Now the question I have is… does this also count for LIMIT? I mean it is possible (I tried) but is it really that rational? Same question on ORDE…
Tag: prepared-statement
How do I return multiple results from my Stored Procedure function if it returns only one result?
I have an application right now that uses SQL Server 2017. When I am executing a stored procedure on SSMS, it shows all of the data. But then, on PHP, when I am executing it, it only shows the first data that comes up. This is the command: The stored procedure I am using: PHP Code I am using: (note:
Handle empty variable in a prepared statement
Sometimes my script receives a $_POST[“is_searchfield”] request from a form. Then I want to use this variable as a part of a “Where” clause of a MySQL query. Otherwise this part of the “Where” clause shouldn’t afflict the rest of the query. For the query I use a prepa…
sql update multiple column in a foreach loop using prepared statement
Im studying this PHP script on how to prepare for multiple execution of a UPDATE statement. The script below shows update for 1 column using prepared statement. Example from PHP manual https://www.php.net/manual/en/function.sqlsrv-prepare.php What if I have multiple column to update, how do I create an array …
Populating my input fields depending on what selected in dropdown using ajax
I want to populate my input fields which are texts depending on what I selected on my dropdown and I am using a procedural prepared statement for my back end. I can already retrieve the data from the the dropdown but I can’t populate the fields whenever I click/select on dropdown data Problem: I’v…
populating my dropdown menu using procedural prepared statement
I would like to ask on how do I populate my dropdown/ via retrieving my data in MySQL database. I am using procedural prepared statement to add a security or avoid SQL injection. Problem:…
Use more placeholders in WHERE statement after IN statement with arrays
I need more placeholders to be added to the following query. Is this possible? I have no idea where to begin and I can not find any options on the Internet. The query now: $in2 = str_repeat(‘?,’, …
How to Add the Quantity of Duplicate Products entries. If the Product Quantity is Less than 8 return it
In my API. I have a product table with attributes product_id, category_id, item_id, size_id, brand_id, product_price, product_quantity, location_id, product_manufacture, product_expire, created_at And I am returning the products information’s response of which quantity is less than 8. Here I am previewi…
PDO insert array in array
i’m confused … I am encountering a tiny issue that drives me crazy. I have arrays in an array which i’d like to insert into an SQL table. My issue is that i don’t figure out how to insert arrays in an array … The arrays: Array ( [1] => Array ( [diploma] => Master [institut]…
How to prepare data outputted from sql in php to run through the PHP machine learning Library
I am playing around with the LeastSquares regression algorithm from the PHP ML library. I can successfully run the code with the example given but when I try to run data from my database I get a blank screen returned and no error logs on the server. Here is the working example php file from the ML library: He…