Skip to main content
260 questions
Newest Active Bountied Unanswered
1 vote
0 answers
42 views

I've been doing what I'm about to explain using ASP classic and ASP.Net with MSSQL Server for all that time and it works beautifully! Please, read carefully. Example #5 comes from here: https://www....
Bob Jensen's user avatar
  • 19
-2 votes
1 answer
51 views

I have been struggling for 3 days but cannot get a simple solution. $asup = $connection->prepare(' update company_assign set ...
Umesh Gaire's user avatar
  • 19
0 votes
0 answers
115 views

I'm new in Stackoverflow and I'm sorry if I might not be clear with my question. I don't understand what's wrong in my code and I would like to have your help. This is the php code snippet: $giorno = &...
Dany's user avatar
  • 1
2 votes
1 answer
128 views

I've been trying to streamline how I write my MySQLi code with PHP after learning more about SQL injection and safe coding with bind_param. I wrote a function that can estimate what the "...
bookworm's user avatar
  • 51
0 votes
0 answers
30 views

I'm trying to create a feature where users can chose which columns in the database they would like to filter on. Filter options are from_date, to_date, reference, offset, status and customer_id which ...
Jasper's user avatar
  • 1
0 votes
0 answers
26 views

I have an odd problem with bind_param() for mysqli in PHP. Here's the code: $q = <<<SQL INSERT INTO customers (name, company, email) VALUES (?, ?, ?) SQL; $...
Simon's user avatar
  • 1,406
0 votes
1 answer
68 views

I have never done a bind_param() on a key/value table. So, I'm not sure that CASE WHEN can even be applied this way. The variable column holds all those "cust_xxx" items while their actual ...
General Admission's user avatar
  • 3
0 votes
0 answers
33 views

I have a web service that receives a JSON string with multiple places. The first thing I do is put this JSON in an array, which I have checked and all its elements are correct. $json = ...
wiki's user avatar
  • 289
0 votes
2 answers
814 views

I'm working on a program to update the user's password with PHP/MySQL. The table is titled 'utilisateurs' and contains several fields: • numero (auto-increment); • identifiant (user ID); • motdepasse (...
Fabien Nguyen's user avatar
  • 5
0 votes
0 answers
92 views

So I am trying to edit my DB, which has HTML stored in it. I am trying to replace the max-width:auto; css styling with a max-width:100%;. I figured the best way would be to use db2_bind_param in order ...
BoogaBooga's user avatar
  • 157
0 votes
0 answers
25 views

I am having trouble using PDO bind param when using foreach. There is an array in which the key is a named parameter ':param' = array(data=>$param, type=> PDO::PARAM_INT) [0] => Array ...
Денис Корнецов's user avatar
  • 1
0 votes
0 answers
26 views

SQL statement works perfectly on db, param value evaluates correctly. Connection works (there's a previous db request that has successfully closed), but bind_param fails. $sql3 = "SELECT ...
Enedc's user avatar
  • 3
0 votes
0 answers
73 views

How can I bind params in multiple foreach loops? With ? SQL output is wrong '%term%'SELECT * FROM `user` WHERE (LOWER(`name`) LIKE '\\' ESCAPE '%second_term%') OR (LOWER(`name`) LIKE '\\' ESCAPE ) $...
Arthur's user avatar
  • 1
0 votes
0 answers
111 views

This might be less complicated than I'm making it, but I'm stuck. I have two tables with columns that have related data that I'd like to join when the user searches for one or two terms. Example ...
Niwa's user avatar
  • 77
1 vote
0 answers
31 views

I'm not sure about this behaviour. $query = 'INSERT INTO XXX (row1) VALUES (:myparam)'; $stmt = $mycon->prepare($query); $stmt->bindParam(':myparam','',PDO::PARAM_STR); above code will fail at ...
Jens Körte's user avatar
  • 63

15 30 50 per page
1
2 3 4 5
…
18