Started in 1980 with BASIC on a Sinclair ZX80. Various flavours of BASIC later, went to Uni and did a final year project using a dynamically assigned 48 processor array (Transputers - who remembers them?) to calculate fractals, stint in support, LAMP stack coder from 2004, never looked back.

Kids nowadays eh? They've got it easy! GUI? I'd have killed for a GUI! We had to code on clay tablets

Apr
14
awarded Caucus
Apr
9
comment PHP - Advise on large data validation and Imports
Not exactly an answer (hence why this is a comment) but could you import the data into a temporary table on the SQL server, run the comparison query in T-SQL and then return the data to the PHP? I would guess that the comparison would run quicker on the SQL than on PHP due to the lack of moving data around from SQL to PHP etc
Apr
9
comment PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Connection refused
As @TNC said, check connection from the command line of your machine. Also, check whether the DB server is doing a DNS name resolution. You've allowed 'root'@'192.168.56.102' access but your DB server may be resolving that to a name and failing. Either add a 'root'@'machinename' user or disable name resolution in the my.cnf file using skip-name-resolve
Apr
8
comment PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Connection refused
Have you configured the user to be allowed from your machine? MySQL user permissions are based on username and source machine name/IP address
Mar
25
comment How store data in an associative array from an input field?
@NileshBhunjun - if you want an array in PHP, you need to define the field as such on the form. A simple test script would have told you as much. This is basic PHP/HTML
Mar
25
comment How store data in an associative array from an input field?
@NileshBhunjun - no, it's not possible. You need to use the syntax Marc gave. If you come up with another method, come back and tell us because we'd love to know how you did it
Mar
25
comment What's the purpose of MySqlDataReader.NextResult?
Why don't you create a small table with a limited set of data, a small test script, and try it? Try using .NextResult() then .Read and see what comes back. If there is no data lost, you have your answer
Mar
18
comment How do I perform 2 actions with 1 submit button?
I was going to suggest cURL but you beat me to it. Huzzah!
Mar
17
comment Unable to add user to MySQL database using PHP, error code #1064
You check for $login_ok to be true but you only ever assign it to be false. Put $login_ok=$row; just before the if ($login_ok).... Really, this should be asked as a new question - the original has been marked as accepted so it will show as such on the main SO page. If you ask a new question, I'll provide a longer answer for you
Mar
17
answered Unable to add user to MySQL database using PHP, error code #1064
Mar
17
comment Unable to add user to MySQL database using PHP, error code #1064
I see it but you don't call it. You call prepare and call the SELECT... statement, assign the INSERT... statement to a variable and then do a redirect
Mar
17
comment Unable to add user to MySQL database using PHP, error code #1064
This is using prepared statements in PDO. Using mysql_ anything is not recommended as that set of functions is deprecated
Mar
17
comment Unable to add user to MySQL database using PHP, error code #1064
Where do you actually call the INSERT... statement? I can only see a prepare/execute with the SELECT... statement
Mar
16
answered Reverse of number in PHP not showing correct output
Mar
16
comment $_POST via cURL not working
isset(...) can accept multiple values. It will evaluate from left to right and will return false on the first parameter that is not found
Mar
10
comment Multiple Select box from2 Arrays
Replace the whole if structure with $selected=(in_array($val,$b) ? 'selected="selected"' : '');
Mar
10
comment Multiple Select box from2 Arrays
A foreach loop with an in_array call should give the result you desire
Mar
5
comment Populate a table with data from MySQL table PHP
Stop using the mysql_ functions - they're deprecated. Use mysqi_ or PDO calls. Look into stored procedures too as they will make using variables from forms easier and more secure
Mar
5
answered Display each mail body as it is in browser using PHP
Mar
3
comment PHP search MySQL table with dropdown box
If the DB is being connected to, what is the output of your query? Dump each row to a log file as you retrieve them (CSV/print_r/var_export) so you can check that the data is actually sensible. If you're using JavaScript, check for errors and log the output there to the console
1 2 3 4 5