I want to prevent SQL injection in Question2Answer. This is how I store data in MySQL via HTML form. I know it’s a security risk. Examples – OR and SQL query is – How should I post data in the latest PHP 7 and above version? I think escaping strings is deprecated or outdated. Answer Based on…
Tag: php
Sort MySQL query in PHP
I’m trying to sort different users ‘points’ by descending order (highest first). But at the moment the query is being returned in order of the user’s ID (order they appear in the database). I’m not sure what is wrong with my code? The user can be in multiple leagues, so it first …
PHP/SQL Find duplicate rows in a column, with the condition that another column is different
I need an SQL query to do the following task: I have two columns. Column ‘foo’ and column ‘bar’. The query needs to return results if and only if column ‘foo’ has different values but ‘bar’ has the same values. For example: If I was to run the query on the above…
How to update multiple records in Codeigniter
In above code snippet first function is declared in controller and second function is declared in model. I want to update owner for multiple rows having ids in $astrep. Can anyone please help me? Answer You can use whereIn() or orWhereIn() methods from query builder class. Refer https://codeigniter4.github.io…
How to get Table field names at top of result array
Here is my Sample table: Here is My Query: Result for above query is: I need to get the field names in the first element of the array. Expected result array is: How can I modify the Query to get this result? Thanks in advance… Answer Display issues should generally be dealt with in application code, not…
How to perform mysql query with goal of returning 2 rows when a single record is found in
This will return one row with a result of: How would it be possible to return multiple rows for a given column while retaining the other column field values. Essentially, adding rows on the fly when the conditions are met. My thought process attempted: Desired Result: Answer Are you looking for union all? Or …
Update row if exists or insert
I’m working on a web based PHP form that’s currently connect to an Oracle database. I’m trying to get the functionality working so that after a user submits the form it’ll check if a row exists based on the Job Number, if it does then update, otherwise insert the values. It’s bri…
Get results from SELECT then UPDATE it into the database MySQL and PHP
I want to get the time average by using this command in PHP : so is this code below correct to combine update and avg: I have two requests: I want to UPDATE another column with the average, so how can I do that? When I use the above SELECT I got the HH:MM but I just want the minutes
how to show the selected value from database in select box in codeigniter
Here I have a select box where I want to show the value which is stored in the database that is in the JSON format. If the value is present, it shows the selected value, otherwise it shows the default option Delete leads option. It’s not working properly. Can anyone please help me? Answer I think you co…
Showing two different values depending on SESSION value in INNER JOIN
I have two different tables, one named users, and another named transactions. Transactions contains wallet1, wallet2, amount. Users contains user details such as firstname, lastname, and wallet. I am trying to display the corresponding first name and last name, depending on whether or not the SESSION_wallet i…