I have such control structure: And my NULL case is never invoked because as I found in php manual: Note that switch/case does loose comparision. I know I can use IF instead of SWITCH but I wouldn’t like to, I have already some IF’s in every CASE of my SWITCH. Is there any way to rewrite somehow SW…
Tag: php
ereg(“^[0-9a-z] restricts only 0-9 and a-z character what about other language character
I have a form and I want to allow users with all character without any space . so I was using this for english character ereg(“^[0-9a-z] but later I have decided to allow other character of …
WordPress prepared statement with IN() condition
I have three values in a string like this: When I feed it into a prepared statement like this: echo $query; shows: It is not writing the string as three separate values — it is just one string with the double quotes escaped. How can I properly implement a prepared statement in WordPress with multiple va…
SQL get results 21-30?
This seems like a really simple question but I can’t seem to find information on it. If I have 100 results, and I only want to get the results results between 21 and 30 (from the order my SQL query is grabbing them), how would I accomplish this? Answer You can use this: E.g.,
Unable to access an error message corresponding to your field name
I have a callback function that check_captcha which sees if $row is ==0 or == 1 (this information is queried from sql). The problem is that I can not call it from $self->form_validation->set_rule(‘captcha’, ‘call_back_check_captcha’) due to the fact that my function takes in a $r…
How to attach PDF to email using PHP mail function
I am sending an email using PHP mail function, but I would like to add a specified PDF file as a file attachment to the email. How would I do that? Here is my current code: Answer You should consider using a PHP mail library such as PHPMailer which would make the procedure to send mail much simpler and better…
Selecting one row from MySQL using mysql_* API
I have the following query: and the output I am getting is: Resource id #2 Ultimately, I want to be able to echo out a single field like so: Without having to use a while loop, as since I am only trying to get one field I do not see the point. I have tried using mysql_result with no luck
MySQL commit and transaction
I have a question regarding MySQL commits and transactions. I have a couple of PHP statements that execute MySQL queries. Do I just say the following? What exactly would this do? How does it help? For updates, deletes and insertions I also found this to block other queries from reading: Would this block other…
MySQL INSERT IGNORE INTO keeps adding duplicate entries
Here’s the particular area im having an issue with when testing this it keeps adding the same entry to the table even though I have set IGNORE INTO. Answer It looks like you don’t have a UNIQUE INDEX on the IP column. In order for INSERT IGNORE to work as required, that’s neccessary. Try thi…
Check if all values in array are the same
I need to check if all values in an array equal the same thing. For example: If every value in the array equals ‘true’ then I want to echo ‘all true’. If any value in the array equals ‘false’ then I want to echo ‘some false’ Any idea on how I can do this? Answer…