14 Archived Topics
Remove Filter  | Hello, I hope not to scare you with this long post. I'm testing [Solr](https://lucene.apache.org/solr/) (read solar) and it works fine. I have an issue with the **DataImport** handler, it's set to get data from a MariaDB database, which works fine if I save the database credentials in plain text in …  |
| | Hello, so, I'm playing a bit with **MariaDB 10.0.29** and I cannot understand why `FOUND_ROWS()` keeps returning the `1` whatever happens to the latest select query. Here's my test: > CREATE TABLE `test` (`id` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, `msg` VARCHAR(100) NULL) ENGINE = InnoDB; Query OK, 0 rows affected … |
| | I was asked to fix few bugs, looking at the code, this is what I saw at the end, 600 lines later: } } } } } } } } Looks like vertical [brainf4ck code.](https://en.wikipedia.org/wiki/Brainfuck) You can imagine how it looks the rest.  |
| | ###Simple Advice This is just a reminder. When setting environment variables through **.htaccess**, **CLI** or **dotenv** use `filter_var()` to evaluate a boolean. For example, start the built-in PHP server with these variables: DEBUG=FALSE LOG=TRUE SMS=1 SMTP=0 CONNECT=yes BACKUP=no php -d variables_order=EGPCS -S localhost:8000 And then test through `boolval()`: if you … |
| | Hello, on Hotmail/Outlook webmail, when I receive an email message in the spam folder (formally Junk), I can mark the message as **Not Junk**. The server will then start to deliver the messages from that source, directly into the Inbox, working like a whitelist. Is it possible to do the … |
| | Hello everybody, so, I realized that when I try to load some XML into a MySQL table through the `LOAD XML LOCAL INFILE ...` statement, if there is a parent with the same name of the child, MySQL will insert an extra row. Here's the example to reproduce the issue: … |
| | When using emails as usernames you want them to be unique over your table, but this can be a problem if you consider a GMail account, because of their [username](https://support.google.com/mail/answer/12096?hl=en) [policy](https://support.google.com/mail/answer/10313?hl=en). They allow: * dots * digits * letters * plus addressing text by using the `+` sign, i.e. `orange+juice@gmail.com` … |
| | Hello, so I was trying few relations between tables and I noted an unexpected behaviour when using `group_concat()`. Let say I have three tables: fruits, fruitstock and fruitprices. These are the structures: create table fruits ( id tinyint unsigned not null auto_increment primary key, name varchar(50) not null, quality varchar(50) … |
| | Hello, I'm wondering if I can get help to understand the behaviour of a PHP function: `dns_get_record()`. This returns an array with DNS records for the given domain name, here is an example of the output: php > print_r(dns_get_record('php.net', DNS_TXT)); Array ( [0] => Array ( [host] => php.net [type] … |
| | Hello, I've an array with different type of values: int, null, strings, arrays. I'm trying to remove nulls and empty strings, but I want to save ints, even when it equals to zero, so I tried with `array_filter()`, by default it will remove `0`, `''` and `null`, but by applying … |
| | #This is for Laravel 3.*# ## Hello, ## With this snippet I'm providing a simple way to automatically filter `Input::get()` and `Input::old()`. To achieve this result we need to make few changes: * extend Input and Redirect classes by creating new files in `application/libraries/`, the files are: **input.php** and **redirect.php**; … |
| | > There is a vulnerability in certain CGI-based setups (Apache+mod_php and nginx+php-fpm are not affected) that has gone unnoticed for at least 8 years... read more: http://www.php.net/archive/2012.php#id2012-05-03-1  |
| | Hello, I'm trying to display a message depending on the value of an input field. But it stops working when going back to default. Here's the JQuery code: $(document).ready(function(){ test(); }); function test() { $('#quantity').keyup(function(){ var quantity = $('input:text#quantity').val(); if(isInteger(quantity)) { var msg = false; if(quantity > 1) { msg … |
| | Hi! *Minimize HTTP requests*. One of the suggestion I always read is to combine files, so I made a little Class that merges files on the fly, the supported formats are CSS and Javascript. With little efforts, I think, it can work fine also with JSON and CSV. Usage is … |
The End.