[PHP-DB] Books

Dear List - I posted part of this question on the general list. I am posting here just in case this list did not see the post. This should NOT be taken as any type of negative reference to the general list, the members of which have furnished me excellent help. Question: What books would

[PHP-DB] Database and Table creation

Dear List - Thanks for your help. Using PHP, how do I create a database, add tables to it, then add and extract data from the tables.? Sample code please. Please be aware that I am a newbie. Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.ne

[PHP-DB] Parsing Tab Delimited file

Dear list - Thanks for all your help. I have a tab delimited file which I wish to import into a data base. In MySQL I can use the LOAD DATA command. As far as I know, that command cannot be used in PHP as a mysqli_query. As I understand, I have to parse the file and use the INSERT command.

Re: [PHP-DB] Parsing Tab Delimited file

At 02:54 PM 10/24/2010, Jason Pruim wrote: On Oct 24, 2010, at 2:46 PM, Ethan Rosenberg wrote: Dear list - Thanks for all your help. I have a tab delimited file which I wish to import into a data base. In MySQL I can use the LOAD DATA command. As far as I know, that command cannot be used

Re: [PHP-DB] Parsing Tab Delimited file

e.txt'); foreach ($data AS $row) { $row = explode("\n", trim($row)); var_dump($row); } And there you go. Cheers. On 24 October 2010 16:46, Ethan Rosenberg wrote: > Dear list - > > Thanks for all your help. > > I have a tab delimited file which I wish to import into

[PHP-DB] Incrementing Primary Key

Dear List - Thanks for all your excellent help. I am setting up a database for medical research, which will be conducted at various sites. The sites will be identified by a letter {A,B,C }. The medical record number [primary key] will start at 1001 and increment by one(1) for each pati

[PHP-DB] Books

Dear List - Is anybody aware of any books on PROCEDURAL PHP programming, NOT OO. Thanks. Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Incrementing Primary Key

At 10:10 AM 10/27/2010, Richard Quadling wrote: On 27 October 2010 14:11, Ethan Rosenberg wrote: > Dear List - > > Thanks for all your excellent help. > > I am setting up a database for medical research, which will be conducted at > various sites. Â The sites will be identifi

Re: [PHP-DB] Incrementing Primary Key

At 03:40 AM 10/28/2010, Max E.K wrote: From: "Ethan Rosenberg" To: rquadl...@googlemail.com, "Ethan Rosenberg" Cc: "php-db-lists.php.net" Sent: Thursday, October 28, 2010 4:55:34 AM GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna Subject: Re:

Re: [PHP-DB] Incrementing Primary Key

At 01:17 PM 10/28/2010, Bastien Koert wrote: On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg wrote: > At 03:40 AM 10/28/2010, Max E.K wrote: > >> From: "Ethan Rosenberg" >> To: rquadl...@googlemail.com, "Ethan Rosenberg" >> Cc: "php-db-lists.p

[PHP-DB] Variable Assignment

Dear List - I cannot figure this one out: mysql> $st=1000; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$st=1000' at line 1 Ethan MySQL 5.1 PHP 5 Linux [Debian (sid)] -- PHP

Re: [PHP-DB] Variable Assignment

At 05:13 PM 10/28/2010, Andrés G. Montañez wrote: mysql> SET @st=100; mysql> SELECT @st; +--+ | @st | +--+ | 100 | +--+ Cheers. On 28 October 2010 19:10, Ethan Rosenberg wrote: > Dear List - > > I cannot figure this one out: > > mysql> $st=1000; > E

[PHP-DB] printf

Dear List - I am afraid that I am missing something in a major way. mysql> printf("%b %d %f %s\n", 123, 123, 123, "test"); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'printf("%b %

[PHP-DB] Reading from file

Dear List - Thank you for all your help. Here is another one. I have a file [/home/ethan/PHP/RecNum] which consists of the number 1005. It also has been "1005". No matter how I do it, it is only recognized as 1. Here is the code. In this case, the file is "1005". $fptr1 = fopen("/ho

Re: [PHP-DB] Reading from file

st be passed by reference." so you should expect an array. print_r it to see what is inside. art On 2 November 2010 03:34, Ethan Rosenberg wrote: > Dear List - > > Thank you for all your help. Here is another one. > > I have a file [/home/ethan/PHP/RecNum] which co

[PHP-DB] If condition in query

Dear list - Thank you for all your excellent help. I wish to search a table. In this case, I have five(5) columns: site, Record, BMI, Weight and Height. I wish to be able to search on one or more of the columns. If I use a query like: $ste = $_POST['site']; $req = $_POST['Record']; $wgt =

[PHP-DB] Closing Browser

Dear List - How do I close the browser window, with a script [shell or Perl], after I exit PHP? Thanks. Ethan MySQL 5.1 PHP 5 Linux [Debian (sid)] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Resetting auto_increment

Dear List - Thanks for all your help. How do I reset auto_increment so that the primary key will start from 1. The primary key is now 2421. I have deleted all the data in the table and started over, and the primary key just increments from its previous value. Setting auto_increment=0 does

Re: [PHP-DB] Resetting auto_increment

At 12:38 PM 12/14/2010, Daniel Brown wrote: On Tue, Dec 14, 2010 at 12:34, Ethan Rosenberg wrote: > Dear List - > > Thanks for all your help. > > How do I reset auto_increment so that the primary key will start from 1. > The primary key is now 2421. I have deleted all the

[PHP-DB] Problems w/ goto

Dear List - I am sending this again since it does not seem to have posted. Ethan +++ Dear List - Thank you with your excellent help in the past. Here is another puzzler I am trying to write a program that can have two(2) independent forms in one PHP file. When I run the code below [

[PHP-DB] goto - My comments

Dear List - Thanks to all for your EXCELLENT comments. I definitly agree that goto is a command to be avoided at all costs. In this case, I could not figure out how to acheive the desired result without the goto. So being a newbie, I humbly request that you show [and at the same time t

[PHP-DB] Regex for telephone numbers

Dear List - Thank you for all your help in the past. Here is another one I would like to have a regex which would validate that a telephone number is in the format xxx-xxx-. Thanks. Ethan MySQL 5.1 PHP 5 Linux [Debian (sid)] -- PHP Database Mailing List (http://www.php.net/

[PHP-DB] Re: [PHP] Regex for telephone numbers

At 07:27 PM 12/29/2010, Josh Kehn wrote: On Dec 29, 2010, at 7:12 PM, Ethan Rosenberg wrote: > Dear List - > > Thank you for all your help in the past. > > Here is another one > > I would like to have a regex which would validate that a telephone number is in th

[PHP-DB] Job Search

Dear list - I am an entry level data base programmer [PHP/MySQL HTTP/CSS] looking for work in the NY metropolitan area. Any ideas? Should we have a job search board? Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Two forms on one page

Dear List - I would like to have two(2) forms in one PHP script. I would like to have the forms appear sequentially; ie, that the first form would appear, the data would be entered, and then the second form would appear, the data would be entered, and the script would exit. The code below d

[PHP-DB] Two forms on one page

Oooops - left out the text that was supposed to be in the quotes. Dear List - I would like to have two(2) forms in one PHP script. I would like to have the forms appear sequentially; ie, that the first form would appear, the data would be entered, and then the second form would appear, the d

[PHP-DB] Two forms on one page - THE ANSWER

Jim - Much thanks to you for solving a problem with which I have been struggling for the last two weeks. Here is the code: === http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> Enter your date of birth, in mm/dd/ format: FORM

[PHP-DB] Craigslist Jobs

Dear List - I am a NEWBIE, so . How do I handle Craigslist postings? Is there anything special I should do? Any advice for other web sites? At this point I am talking about small jobs. 1] My payment. Should I ask for something up front? If so how much? 2] How do I protect myself so t

[PHP-DB] Displaying Results

Dear List - I have a form. In one field, the customer types the name of a product. The first seven(7) results of the MySQL query that the entry generates should be displayed as a clickable drop down list. How do I do it? Thanks. Ethan MySQL 5.1 PHP 5.3.3-6 Linux [Debian (sid)] --

[PHP-DB] Multiple Access to Database

Dear List - I have a database: mysql> show tables; +-+ | Tables_in_hospital2 | +-+ | Intake3 | | Visit3 | +-+ mysql> describe Intake3; ++-+--+-+-+---+ | Field | Type

[PHP-DB] Multiple Access to Database

Dear List - I have a database: mysql> show tables; +-+ | Tables_in_hospital2 | +-+ | Intake3 | | Visit3 | +-+ mysql> describe Intake3; ++-+--+-+-+---+ | Field | Type

[PHP-DB] Multiple Access to Database - The Answer

o 'john'@'localhost'; grant select (Site,MedRec,Weight,BMI,Date) on hospital2.Visit3 to 'john'@'localhost'; logout and login as bob ethan@rosenberg:~/Desktop$ /usr/bin/mysql -u bob -p Enter password: Welcome to the MySQL m

[PHP-DB] Problem w/query - again

Dear list - This did not seem to post, so I am sending it again. If it did post, and I missed it, my apologies. Ethan Dear list - I have the following code: $query = "select * from Intake3 where 1"; $allowed_fields = array('Site', 'MedRec', 'Fname', 'Lname',

Re: [PHP-DB] Problem w/query - again

At 12:13 AM 2/10/2012, Amit Tandon wrote: Dear Ethan It seems you are trying to build a query.But you are not getting field names. If you required field names then change the following line to foreach ( $allowed_fields AS $field => $_POST['field']) to foreach ( $allowed_fields AS $field) This

Re: [PHP-DB] Problem w/query - again

ween fiction and reality? Fiction has to make sense." On Fri, Feb 10, 2012 at 11:04 AM, Ethan Rosenberg <<mailto:eth...@earthlink.net>eth...@earthlink.net> wrote: At 12:13 AM 2/10/2012, Amit Tandon wrote: Dear Ethan It seems you are trying to build a query.But you are not ge

Re: [PHP-DB] Problem w/query - again - CORRECTION

ween fiction and reality? Fiction has to make sense." On Fri, Feb 10, 2012 at 11:04 AM, Ethan Rosenberg <<mailto:eth...@earthlink.net>eth...@earthlink.net> wrote: At 12:13 AM 2/10/2012, Amit Tandon wrote: Dear Ethan It seems you are trying to build a query.But you are not ge

[PHP-DB] search of data base - again

;\n"; echo " $Indx \n"; echo " $Site \n"; echo " $MedRec \n"; echo " $Notes \n"; echo " $Weight \n"; echo " $BMI \n"; echo " $Date \n"; echo "\n"; echo ""; The date value is not inserted properly

Re: [PHP-DB] search of data base - again

At 07:15 PM 3/29/2012, Matijn Woudt wrote: On Fri, Mar 30, 2012 at 1:10 AM, Ethan Rosenberg wrote: > Sending again, since no response on 1st try. > > Ethan > == > Dear List > > I am trying to insert data into a table, with no success. > > I have two

Re: [PHP-DB] search of data base - again

See below- - Original Message - From: "Ethan Rosenberg" Newsgroups: php.db To: "Matijn Woudt" Cc: "php-db-lists.php.net" ; Sent: Friday, March 30, 2012 1:00 PM Subject: Re: [PHP-DB] search of data base - again At 07:15 PM 3/29/2012, Matijn Woudt w

[PHP-DB] foreach

($host,$user,$password,$db); $value = mysql_real_escape_string( $_POST[$fld] ); $query .= " AND $fld = '$_POST[value]' "; echo "#1 $query"; //never echos the query } } These are the messages I receive on execution of the script: Notice: Undefined variable: allowed_fields in /var/www/srchrhsptl5.php on line 198 Warning: Invalid argument supplied for foreach() in /var/www/srchrhsptl5.php on line 198 Advice and help, please. Thank you. Ethan Rosenberg -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP & Database Problems

have a database mysql> describe Intake3; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | Site | varchar(6) | NO | PRI | | | | MedRec | int(6) | NO |

[PHP-DB] PHP & Database Problems -- Code Snippets

sult2, MYSQLI_BOTH)) { global $finished; echo "\n"; echo " $row8[0] \n"; echo " $_GLOBALS[mdr] \n"; echo " $row8[2] \n"; echo " $row8[3] \n"; echo " $row8

[PHP-DB] Re: [PHP] PHP & Database Problems -- Code Snippets

At 06:47 PM 5/2/2012, Matijn Woudt wrote: On Wed, May 2, 2012 at 11:43 PM, Ethan Rosenberg wrote: > Dear list - > > Sorry for the attachment. Â Here are code snippets --- Ethan, I don't want to sound rude, but it appears to me you don't have any understanding of what you

[PHP-DB] [PHP] PHP & Database Problems -- Code Snippets - Any more Ideas?

echo " $row8[2] \n"; echo " $row8[3] \n"; echo " $row8[4] \n"; echo " $row8[5] \n"; echo " $row8[6] \n"; echo "\n"; echo "row8"; print_r($row8[1]); }

[PHP-DB] Database Problems

Dear List - I have a database: +-+ | Tables_in_hospital2 | +-+ | Intake3 | | Visit3 | +-+ mysql> describe Intake3; ++-+--+-+-+---+ | Field | Type| Null | Key | D

Re: [PHP-DB] Re: Database Problems

At 03:30 PM 6/17/2012, Jim Giner wrote: "Ethan Rosenberg" wrote in message news:0m5r005qyzrnm...@mta6.srv.hcvlny.cv.net... > Dear List - > > > The same query in a PHP program will only give me results for MedRec 10003 > why the "where 1" cl

Re: [PHP-DB] Re: Database Problems

At 04:21 PM 6/17/2012, Jim Giner wrote: "Ethan Rosenberg" wrote in message news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... > At 03:30 PM 6/17/2012, Jim Giner wrote: >>"Ethan Rosenberg" wrote in message >>news:0m5r005qyzrnm...@mta6.srv.hcvlny.cv.net... >

[PHP-DB] mysql query

Dear List - I can't figure this out mysql> describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+ | UPC | varchar(14) | YES | | NUL

Re: [PHP-DB] mysql query

On 08/21/2013 07:52 PM, Toby Hart Dyke wrote: 1) What is the error message? 2) This has an error: >values ('$upc', $qnt,'$mnf','$itm', odrpt, 0, $stk) Missing '$' in front of 'odrpt'. Toby On 8/22/2013 12:48 AM, Ethan Rosenberg wr

Re: [PHP-DB] Re: mysql query

On 08/22/2013 11:54 AM, Jim Giner wrote: On 8/22/2013 9:52 AM, Jim Giner wrote: On 8/21/2013 7:48 PM, Ethan Rosenberg wrote: Dear List - I can't figure this out mysql> describe Inventory; +-+-+--+-+-+---+ | Field | Type

Re: [PHP-DB] Re: mysql query

Ethan Rosenberg, PhD /Pres/CEO/ *Hygeia Biomedical Research, Inc* 2 Cameo Ridge Road Monsey, NY 10952 T: 845 352-3908 F: 845 352-7566 erosenb...@hygeiabiomedical.com On 08/22/2013 06:56 PM, Jim Giner wrote: On 8/22/2013 4:14 PM, Ethan Rosenberg wrote: On 08/22/2013 11:54 AM, Jim Giner wrote

[PHP-DB] Bluefish for PHP

Dear List - How do I configure Bluefish for PHP? I am running version 2.2.4 of Bluefish. TIA Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Newbie Question $2

Dear List - I have the following code: The input from the form is a 10 digit string [1234567890] which is converted to phone number format [123-456-7890] $phn = $_POST[phone]; $phn = (string)$phn; $dsh = '-'; $Phn = $phn[0].$phn[1].$phn[2].$dsh.$phn[3].$phn[4].$phn[5].$dsh.$phn[6].$phn[7]

[PHP-DB] What is my Mistake?

Dear List - I know I have a mistake here, but I cannot find it. This is a part of a switch. The switch is fed with a formatted phone number [123-456-7890], which is then tested for validity, and if valid the results of the query are displayed. I cannot get to the display part. Here is the

[PHP-DB] www-data file

Dear list - When I use fopen, the file owner and group are both www-data. How can I ensure that the owner and group will be ethan? TIA Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Writing Problems

Dear List - I can't figure this one out. 1] Straighten out ownership ethan@meow:/var/www$ rm receipt.txt ethan@meow:/var/www$ touch receipt.txt ethan@meow:/var/www$ ls -l receipt.txt -rw-r--r-- 1 ethan ethan 0 Aug 26 19:31 receipt.txt ethan@meow:/var/www$ chmod 766 receipt.txt ethan@meow:/v

Re: [PHP-DB] Writing Problems

On 08/26/2014 09:19 PM, Matt Pelmear wrote: Do you check whether $fh2 is a resource after you fopen()? Do you check whether $fh2 is a resource after you fopen()? How? TIA Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.ne

[PHP-DB] Number of Lines in Table.

Dear List - This works: mysql> describe Purchases; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | indx | smallint(6) | NO | PRI | NULL| auto_i

[PHP-DB] Number of Lines in Table. SOLVED

Dear List - This works: mysql> describe Purchases; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | indx | smallint(6) | NO | PRI | NULL| auto_i

[PHP-DB] Duplicate Writes

Dear List - I seem to be getting dual writes causing a dual insert into the database, and I cannot figure out why. Database mysql> describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+--

[PHP-DB] Re: [PHP] SESSIONS - SOLVED

g shell_exec from a script to another script in processing a browser call is just weird) then you would have to pass the session values you need in the shell_exec call as parameters. Bastien On Thu, Jan 1, 2015 at 11:13 PM Ethan Rosenberg, PhD mailto:erosenb...@hygeiabiomedical.com>> wrote:

[PHP-DB] Code Security

Dear List - How do I prevent someone from opening a terminal window, going to /var/www and stealing all my code? TIA Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Code Security

On 02/05/2015 11:04 AM, Bastien Koert wrote: I'm with the two Richard's on this, those users shouldn't have telnet access to the host server at all. Users should be using the browser to access your site. Other than that, the most important thing you can do is to regularly back up your code and d

Re: [PHP-DB] Code Security

e wants to process CC data. Bastien On Thu, Feb 5, 2015 at 11:24 PM, Ethan Rosenberg mailto:erosenb...@hygeiabiomedical.com>> wrote: On 02/05/2015 11:04 AM, Bastien Koert wrote: I'm with the two Richard's on this, those users shouldn't have telnet access t

Re: [PHP-DB] Code Security

On 02/13/2015 02:58 AM, Karl DeSaulniers wrote: Prevent THIS from ever happening. On Feb 12, 2015, at 11:03 PM, Ethan Rosenberg wrote: He asks Mr.[naive]Nice if he could look at the computer while it is logged in. Otherwise, I would say an external key that has a salt stored on it that

Re: [PHP-DB] Code Security

o use PHP to do something it was never meant to do, and that can only turn out badly. You can think about it all you want, but you are just looking for a bigger hammer to drive something that isn't a nail. On Sun, Feb 15, 2015 at 7:21 PM, Ethan Rosenberg mailto:erosenb...@hygeiabiomedical.c

[PHP-DB] Waiting for localhost

Dear List - I am getting the message - waiting for localhost. Here are some diagnostic steps I have tried root@meow:/home/ethan# cat /var/www/cgi-bin/httpd.conf ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/jkj ServerName 127.0.0.1:80 Listen xx.xx.xx.xx:80 Listen 127.0.0.1:80 root@meow:/home/eth

Re: [PHP-DB] Waiting for localhost

.com On Mar 8, 2015, at 12:29 AM, Ethan Rosenberg wrote: window.open("HandleWeight.php","_self") Karl - Thank you. OK here is the code- "; ?> <!-- window.location.assign("end.php")

Re: [PHP-DB] Waiting for localhost

On 03/08/2015 01:50 AM, Karl DeSaulniers wrote: Shit! — Half Price Books! Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Mar 8, 2015, at 12:49 AM, Ethan Rosenberg wrote: On 03/08/2015 01:43 AM, Karl DeSaulniers wrote: The Dummies series is a great start. (No pun or

Re: Fwd: [PHP-DB] Waiting for localhost

On 03/08/2015 07:00 PM, Karl DeSaulniers wrote: Sorry, missed a parenthesis. if($row7[0] === 1) { echo('window.location = "HandleWeight.php";'); } Best, Karl DeSaulniers Design Drumm http://designdrumm.com Begin forwarded message: *From: *Karl DeSaulniers mailto

Re: [PHP-DB] Waiting for localhost

On 03/09/2015 08:27 AM, Ethan Rosenberg, PhD wrote: On 03/09/2015 06:55 AM, Karl DeSaulniers wrote: Don't know what to tell you bub. Time for the books? I "think" that it has to do with php parsing or not parsing the echo because its echoing a script. Can't remember of

Re: [PHP-DB] Waiting for localhost

On 03/15/2015 09:44 AM, Jason Pruim wrote: If you load up handleweight.php outside of the script does it load normally? Trying to pin down where the actual problem is. Jason Pruim 352.359.0002 On Mar 14, 2015, at 10:17 PM, Ethan Rosenberg wrote: On 03/09/2015 08:27 AM, Ethan Rosenberg

Re: [PHP-DB] Waiting for localhost

. The. You can concentrate on fixing just that part instead of the entire site. Jason Pruim 352.359.0002 On Mar 15, 2015, at 2:40 PM, Ethan Rosenberg wrote: On 03/15/2015 09:44 AM, Jason Pruim wrote: If you load up handleweight.php outside of the script does it load normally? Trying t

Re: [PHP-DB] Waiting for localhost

that directs to this form. Also, I noticed you spelt weight wrong. value= 'WEIGH' Could that be it or just a keyboard error in your mail program? Did you copy and paste that code? Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Mar 15, 2015, at 11:02 PM, Ethan Ro

Re: [PHP-DB] Waiting for localhost

On 03/18/2015 07:51 AM, Richard wrote: Original Message Date: Wednesday, March 18, 2015 00:23:00 -0400 From: Ethan Rosenberg To: Karl DeSaulniers , PHP Database List Subject: Re: [PHP-DB] Waiting for localhost Karl - Thanks to you and all others that have

Re: [PHP-DB] Waiting for localhost

On 03/18/2015 07:51 AM, Richard wrote: Original Message Date: Wednesday, March 18, 2015 00:23:00 -0400 From: Ethan Rosenberg To: Karl DeSaulniers , PHP Database List Subject: Re: [PHP-DB] Waiting for localhost Karl - Thanks to you and all others that have

Re: [PHP-DB] Waiting for localhost

2015 02:18:13 -0400 From: "Ethan Rosenberg, PhD" Subject: Re: [users@httpd] Apache is Slow Some more info Changed the host in the connect $cxn = mysqli_connect($host,$user,$password); $host="127.0.1.1"; Now get an error... Warning: mysqli_connect(): (HY000/2003): Can

Re: [PHP-DB] Waiting for localhost

On 04/01/2015 07:34 AM, Richard wrote: Original Message Date: Wednesday, April 01, 2015 00:05:29 -0400 From: Ethan Rosenberg To: php-db@lists.php.net Richard - As we saw in the Apache list, the problem lies in PHP/MySQL Richard - Thanks. The problem is in

Re: [PHP-DB] Waiting for localhost

t? Or are they interchangeable? Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Apr 1, 2015, at 10:35 PM, Ethan Rosenberg wrote: Richard - Thanks. The problem is in the database connection. from MySQL mysql> show tables; +-+ | Tables_

Re: [PHP-DB] Waiting for localhost

On 04/02/2015 06:17 AM, Richard wrote: Here are some hints service apache2 restart [] Restarting web server: apache2AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this mes

[PHP-DB] Zero Values

Dear List - I have a payment/charges table - mysql> describe Charges; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | Indx | mediumint(9)

Re: [PHP-DB] Zero Values

On 09/01/2015 11:43 PM, Aziz Saleh wrote: On Tue, Sep 1, 2015 at 11:36 PM, Ethan Rosenberg < erosenb...@hygeiabiomedical.com> wrote: Dear List - I have a payment/charges table - mysql> describe Charges; +--+--+--+-+-+---+ | Field

[PHP-DB] Th is a test #2 w/ copy

Dear list - I am not receiving replies. I have been instructed to send a test email. Ethan -- Ethan Rosenberg, PhD /Pres/CEO/ *Hygeia Biomedical Research, Inc* 2 Cameo Ridge Road Monsey, NY 10952 T: 845 352-3908 F: 845 352-7566 erosenb...@hygeiabiomedical.com -- PHP Database Mailing List

[PHP-DB] Th is a test

Dear list - I am not receiving replies. I have been instructed to send a test email. Ethan -- Ethan Rosenberg, PhD /Pres/CEO/ *Hygeia Biomedical Research, Inc* 2 Cameo Ridge Road Monsey, NY 10952 T: 845 352-3908 F: 845 352-7566 erosenb...@hygeiabiomedical.com -- PHP Database Mailing List

[PHP-DB] Prepared Statements Insert Problem

{ print_r($stmt); mysqli_stmt_bind_param($stmt, 'sisssisssi', $Site, $MedRec, $fname, $lname, $phone, $hgt, $sx, $hx, $bday, $age); mysqli_execute($stmt); mysqli_stmt_bind_result($stmt, $Site, $MedRec, $fname, $lname, $phone, $hgt, $sx, $hx, $bday, $age); echo

Re: [PHP-DB] Prepared Statements Insert Problem

Ethan Rosenberg, PhD /Pres/CEO/ *Hygeia Biomedical Research, Inc* 2 Cameo Ridge Road Monsey, NY 10952 T: 845 352-3908 F: 845 352-7566 erosenb...@hygeiabiomedical.com On 09/02/2012 08:33 AM, Matijn Woudt wrote: On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD wrote: Dear List - I wish

Re: [PHP-DB] Prepared Statements Insert Problem - Any more ideas?

On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD wrote: Dear List - I wish to accomplish the following with prepared statements: $stmt = mysqli_stmt_init($cxn); if($stmt = mysqli_stmt_prepare($stmt, "INSERT INTO Intake3 (Site, MedRec, Fname, Lname, Phone, Height, Sex, Hx, Bday

[PHP-DB] Adding entry to /dev

Dear list - How do I add a new entry to /dev; eg, /dev/sdb? Thanks, Ethan Rosenberg -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Problems w/ insert

;Site'], $_POST['MedRec'], $_POST['Notes'], $_POST['Weight'], $_POST['BMI'], $_POST['Date']); *//The error is in this statement* mysqli_stmt_fetch($stmt); mysqli_stmt_close($stmt); *Warning: mysqli_stmt_bind_r

[PHP-DB] Prepared Statements - Search

Dear List - Here is another problem I am having with prepared statements. The last one was INSERT, this one is SELECT. Here is the database: mysql> describe Intake3; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++---

Re: [PHP-DB] Re: Problems w/ insert -- SOLVED!!!

Dear list - Thanks to all. It now works! The problem, as you correctly noted, was the erroneous inclusion of the bind-results statement. Removed that and it worked!! Thanks again! Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.ph

[PHP-DB] Prepared Statements - Search -- SOLVED!!!

Dear List - -->> THANKS TO ALL. See below <-- Here is another problem I am having with prepared statements. The last one was INSERT, this one is SELECT. Here is the database: mysql> describe Intake3; ++-+--+-+-+---+ | Field | Type| Null | Ke

[PHP-DB] Prepared Statements - Select

Dear List - Thanks to all for your responses. Here is another one I wish to accomplish the following mysqli_stmt_bind_param($stmt, 'sis', $_POST['Site'], $_POST['MedRec'], $_POST['Sex']); This statemnt was hand coded. I wish to be able to generalize it. Therefore - $sql11 =

[PHP-DB] Prepared Statements - Select - Bind Parameters

Dear list - Thanks to all for your help. I hope [??] that this question will solve all the remaining problems. So that we are on the same page, here is what was previously stated. mysqli_stmt_bind_param expects three variables, in this order mysqli_stmt_bind_param($stmt, "num", $a, $b, $

[PHP-DB] Prepared Statements - Select - Bind Parameters w/ correction

Dear list - SEE CORRECTION IN $_POST VARIABLE BELOW. Thanks to all for your help. I hope [??] that this question will solve all the remaining problems. So that we are on the same page, here is what was previously stated. mysqli_stmt_bind_param expects three variables, in this order mysq

[PHP-DB] Debuggers

Dear list. I am running Debian 6 (sid) and Firefox 15.0 I have three debuggers: Firebug - I have never been able to make it step thru the code. Aptana - "Aptana Firefox extension launching...please wait". Never goes beyond this point. Netbeans - 1]Will only give a Java debugger. 2] No col

[PHP-DB] Program Dies

Dear List - Thank you ever so much for all your help. I apologize in advance for dumping all this code on you. I cannot get any debugger to work for me [see my separate email on debuggers]. I placed numerous echo and print_r statements in the code, and could not find the error. The progra

[PHP-DB] Debugger

Dear list - A. Is anyone aware of a debugger that: 1] will step thru the code, 2] will stop at a point that input is requested [eg, form] and allow input? B. Aptana gives the following message: 'Launching Firefox' internal server has failed. Server configuration null not found. Advice

[PHP-DB] Formatting

Dear list - When I run the following code, the results are preceded by at least one screen full of blank lines. I am showing you a large code block since I do not know where the error is: if(isset($_REQUEST['Sex'])&& trim($_POST['Sex']) != '' ) { if ($_REQUEST['Sex'] === "0")

Re: [PHP-DB] Re: Formatting

List - Any more ideas. = Keep on debugging jg Jim - I've been at this for a few weeks, and am stuck. Thanks for all your help. Ethan + On Nov 25, 2012, at 1:59 PM, "Ethan Rosenberg, PhD" wrote: On 11/25/2012 12:56 PM, Jim Giner wrote: On 11/25/2012

  1   2   >