fatkatie

The public firewall suddenly started blocking access. Turn it off and site is available. So the fix will be to add a rule.

I've been running an xampp apache distribution on a windows 10 box for a year. It's worked just fine. This morning no one could get to it. The site works on the host. Other boxes can ping the ip address. The service starts and stops without new errors ("server certificate does NOT include an ID which matches the server name" is an old friend). Any ideas before I reinstall it? I might just go out and hire a guy too.

@#$@#$@! You spend all day on something that has nothing to do with anything. It was a stupid join. mb_check_encoding But, I would like to know if mb_check_encoding() is worth anything. I've relied on binding which has never failed me. Thank you.

while ($pending || $row = $sth->fetch(PDO::FETCH_OBJ)) { $pending = false; $hn = $row->houseid; writeData("READ $hn", __FILE__, __LINE__); } There's the loop. houseid starts repeating. I found the record but I don't see anything wrong yet. Newlines? I'm going to rewrite the record with the check and see what that does.

I just started populating a mysql table with data collected from a form posting. I do the dance ... $post_partnumber_source = html_entity_decode(trim(fvs($_POST['nsel_pnsrc'])));where fvs is function fvs($string){$string = filter_var($string, FILTER_SANITIZE_STRING); return $string; } And then I use PDO and binding. Something has happened. Something bad. My PHP $sth->fetch(PDO::FETCH_OBJ) loops are failing. All the records are not being read (some seem to be read twice)... and it happens around the record when form input was starting to be used. It's got to illegal data messing this up. So, my question is, what now? Will mb_check_encoding() solve this or am I missing something very basic. Thank you. mysql Ver 15.1 Distrib 10.1.37-MariaDB, for Win32 (AMD64), Using configuration as supplied by xampp

I see the php functions for dealing with csv coded files, but is there a cvs handler for strings? Thanks.

We have a site that was coded years ago and it does searching in database tables for any number of things. The mysql 'like' construct is commonly used. Years pass... Is there a search module that implements a more professional search? I would expect (with our configurations) things like spelling correction, user search history, zip code locating, suggestions (you may be interested in this) and so on. Even a simple one would be better than what we have now. I expect the implementation would not be trivial. The database contains products, addresses, product reviews, and new articles; among other things. Thanks for suggestions. Env: mysql, php 5 (not7), godaddy host (shared)

The answer to that question is yes. https://github.com/jbrooksuk/MCAPI-PHP You must have a key, The key is $9.

Brand new to mailchimp. I just have one question. Is it possible to compose and then send email programmatically? (php) (ok... 2 questions) And if so, can you point me to an example. I see other examples to adjust campaigns and lists, but I don't see any examples using mailchimp to distribute mail composed on a site. We tried to mail all our alerts from our account and you can guess what happened.

Thank you for your comment.

I want to alter a table and add a new column. I want to add a second email address column and I want the design of this new column to match with the first. For example, if email varchar(128) default null then I want the new column the "same" as in: email2 varchar(128) default null Can column design values be copied in this way within the sql construct? Can column design values be collected from another separate table?

If there are no constraints on the database a read-back might be a good thing to do. . If for the count anyway.

It's easy then to intercept those two then. I'll check the mysql output myself. Thanks for a very nice presentation. As for spelling, I can handle that too. 99% of the time it comes in a short feb.

Without writing a regx, is there a php function/library that will take a string and try and convert it to a date? PHP's date is not adequate. For example, these are all "dates". I would expect it to succeed on any of these. On those that are ambiguous, there should be attribute that can be set like, expect year between 78 and 16. This is strictly best guess, I do not supply a format. Failure is expected. feb 21, 1999 Feburary 21, 1999 02/21/99 2/21/99 99/2/21 2-21-1999 19990221 sun, Feb 21, 1999 Sunday Feburary 21, 1999 anything returned by a mysql date (now(), datetime ...) Today's date is DATESTUFF You get the idea. Returns false on couldn't do it, and some array or seconds after N if successful. Thank you.

Still new. Off topic - not really php? Hope not. Who else knows mysql like the php crowd. I find this clause construct in many places on this new site: and t2.keyword like concat('%', :bc11, '%') or t2.name like concat('%', :bc12, '%') or t2.des like concat('%', :bc13, '%') He's trying to find the search term anywhere in any of the 3 fields. bc11, bc12 and bc13 are binding 'keys' that receive identical values. Is there a way to build this something like this:? and any (t2.keyword, t2.name, t2.des) like concat('%', :bc11, '%') I had to make up something my self :-). Thanks.