Re: [PHP-DB] use php variable within postgresql query

2023-06-12 Thread Karl DeSaulniers
Oh I see now I am late to the conversation. Slow email load. Carry on. > On Jun 12, 2023, at 1:42 PM, Karl DeSaulniers wrote: > > Hi, > I am assuming this is just a typo in your post and not your code, correct? > (see quoted text below) > If not, then try the other bracket?

Re: [PHP-DB] use php variable within postgresql query

2023-06-12 Thread Karl DeSaulniers
Hi, I am assuming this is just a typo in your post and not your code, correct? (see quoted text below) If not, then try the other bracket? $query=$_GET['databasecolumn']; > On Jun 9, 2023, at 4:05 AM, e-letter wrote: > > $query=$_GET['databasecolumn'[;

Re: [PHP-DB] Realtime connection to postgres database

2020-11-09 Thread Karl DeSaulniers
o postgresql database (v9.6) HTH, Best, Karl DeSaulniers Design Drumm http://designdrumm.com <http://designdrumm.com/> > On Nov 9, 2020, at 11:41 PM, Rodrigo Sánchez wrote: > > connected to postgresql > database (v9.6)

Re: [PHP-DB] Realtime connection to postgres database

2020-10-26 Thread Karl DeSaulniers
Sounds like a good cron job candidate. Best, Karl Sent from losPhone > On Oct 25, 2020, at 4:43 PM, Aziz Saleh wrote: > > Another way to do this is to have an ajax call on timeout to an update > endpoint, if there is an update inject that update on the page (or refresh > it). > > Some js ex

Re: [PHP-DB] MySQL connection

2017-03-05 Thread Karl DeSaulniers
That makes complete sense. Thank you Joshua. Best, Karl DeSaulniers Design Drumm http://designdrumm.com > On Mar 5, 2017, at 6:44 PM, Arneson, Joshua wrote: > > If you have multiple calls to the database that are grouped, definitely > perform them during the same connection

Re: [PHP-DB] MySQL connection

2017-03-05 Thread Karl DeSaulniers
27;ll leave it, but if it is a matter of best practices to open and close, I will change the method I am using. Again, TIA! Best, Karl DeSaulniers Design Drumm http://designdrumm.com > On Mar 5, 2017, at 6:19 PM, Arneson, Joshua wrote: > > Right off the bat, you need to consider conc

[PHP-DB] MySQL connection

2017-03-05 Thread Karl DeSaulniers
connection. Either for performance reasons or security or best practices. Just wondering your professional. TIA Best, Karl DeSaulniers Design Drumm http://designdrumm.com <http://designdrumm.com/>

Re: [PHP-DB] Any method to get primary key matching a given value ?

2016-10-10 Thread Karl DeSaulniers
You may be correct. Admittedly, I am stabbing in the dark here. I work on MySQL, not SQLite. Just good at key word searches. :) This link seems to be promising. http://www.sqlite.org/c3ref/table_column_metadata.html Sorry I can't help more. Best, Karl DeSaulniers Design Drumm

Re: [PHP-DB] Any method to get primary key matching a given value ?

2016-10-10 Thread Karl DeSaulniers
#x27;pk']; } } Best, Karl DeSaulniers Design Drumm http://designdrumm.com <http://designdrumm.com/> > On Oct 10, 2016, at 7:12 PM, Ratin wrote: > > Sorry about my late reply but this was my function - a bit of a hack but > works properly on my

Re: [PHP-DB] Corn job anomaly

2016-09-27 Thread Karl DeSaulniers
> On Sep 27, 2016, at 2:24 AM, Ford, Mike wrote: > >> -Original Message----- >> From: Karl DeSaulniers [mailto:k...@designdrumm.com] >> Sent: 25 September 2016 09:59 >> To: PHP List Database >> Subject: Re: [PHP-DB] Corn job anomaly >> >

Re: [PHP-DB] Corn job anomaly

2016-09-25 Thread Karl DeSaulniers
ard > wrote: > > > >> Date: Sunday, September 25, 2016 08:37:14 -0400 >> From: Aziz Saleh >> Subject: Re: [PHP-DB] Corn job anomaly >> >> On Sun, Sep 25, 2016 at 4:59 AM, Karl DeSaulniers >> wrote: >> >>>> On Sep 23, 2016, at 5:

Re: [PHP-DB] Corn job anomaly

2016-09-25 Thread Karl DeSaulniers
> On Sep 23, 2016, at 5:38 AM, Richard > wrote: > > > >> Date: Friday, September 23, 2016 03:28:47 -0500 >> From: Karl DeSaulniers >> >> Ok, so I have run down all the possible things (that I know of) >> that could be keeping this from working. I

Re: [PHP-DB] Corn job anomaly

2016-09-23 Thread Karl DeSaulniers
and that my calls to MySQL are making the script time out? What bothers me is that the cron errors out saying access denied but ssh says timeout error. Does anyone have any ideas for me to try at this point? If I don't get this to work in the next couple of days, I am toast! TIA, Best,

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Karl DeSaulniers
ing the pipe and semicolon literally. I have since found this out on my own that my original code works. It is as Richard and Bert had said. My cron runs under the server admin user and so I have to contact my client to find out what that password is or change it. Much thanks to everyone

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Karl DeSaulniers
another user and that my original CL works, just not sure how to find out. I would call my hosting provider to ask, but I always get the same response ... We don't troubleshoot peoples code it is out of our scope of support. Best, Karl DeSaulniers Design Drumm http://designdrumm.com >

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Karl DeSaulniers
On Sep 20, 2016, at 7:21 AM, Richard wrote: > > > >> Date: Tuesday, September 20, 2016 03:26:39 -0500 >> From: Karl DeSaulniers >> >>> On Sep 20, 2016, at 3:22 AM, Lester Caine >>> wrote: >>> >>>> On 20/09/16 09:14, Karl

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Karl DeSaulniers
> On Sep 20, 2016, at 3:22 AM, Lester Caine wrote: > > On 20/09/16 09:14, Karl DeSaulniers wrote: >> Pardon my ignorance, but what do you mean full path? > Full path to php application. > Cron jobs run as 'root' and so need and user account settings added >

Re: [PHP-DB] Cron job anomaly

2016-09-20 Thread Karl DeSaulniers
> On Sep 20, 2016, at 3:20 AM, Lester Caine wrote: > > On 20/09/16 09:10, Karl DeSaulniers wrote: >> Hi Lester, >> They are listed inside the php file. >> >> The error message I get is: >> >> Access denied for user '(user name rem

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Karl DeSaulniers
> On Sep 20, 2016, at 3:14 AM, Karl DeSaulniers wrote: > >> On Sep 20, 2016, at 3:06 AM, Lester Caine wrote: >> >> On 20/09/16 06:16, Karl DeSaulniers wrote: >>> Was probably a newb question, however, now it is saying that my database >>> user

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Karl DeSaulniers
> On Sep 20, 2016, at 3:06 AM, Lester Caine wrote: > > On 20/09/16 06:16, Karl DeSaulniers wrote: >> Was probably a newb question, however, now it is saying that my database >> user is not allowed access. >> I have a mysql connection inside my script that reads t

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Karl DeSaulniers
> On Sep 20, 2016, at 3:06 AM, Lester Caine wrote: > > On 20/09/16 06:16, Karl DeSaulniers wrote: >> Was probably a newb question, however, now it is saying that my database >> user is not allowed access. >> I have a mysql connection inside my script that reads t

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread Karl DeSaulniers
> On Sep 20, 2016, at 12:16 AM, Karl DeSaulniers wrote: > >> On Sep 19, 2016, at 6:14 AM, Richard >> wrote: >> >> >> >>> Date: Monday, September 19, 2016 03:26:54 -0500 >>> From: Karl DeSaulniers >>> >>> I am hopin

Re: [PHP-DB] MySQL two tables and an uneven number of rows

2016-09-19 Thread Karl DeSaulniers
Thanks Bert, Sorry for late response, but I had to step away from this for a moment to work on other things. Will most likely be back though as things are not working still. Thank you for your responses. Best, Karl DeSaulniers Design Drumm http://designdrumm.com > On Sep 13, 2016, at 2

Re: [PHP-DB] Corn job anomaly

2016-09-19 Thread Karl DeSaulniers
> On Sep 19, 2016, at 6:14 AM, Richard > wrote: > > > >> Date: Monday, September 19, 2016 03:26:54 -0500 >> From: Karl DeSaulniers >> >> I am hoping someone can enlighten me on this issue I am having. >> I am trying to set up a cron job to ru

[PHP-DB] Corn job anomaly

2016-09-19 Thread Karl DeSaulniers
I am hoping someone can enlighten me on this issue I am having. I am trying to set up a cron job to run a php file. I am getting a strange error though. /home/(protected directory)/auto_reminder.php: line 1: ?php: No such file or directory /home/(protected directory)/auto_reminder.php: line 2: =:

Re: [PHP-DB] MySQL two tables and an uneven number of rows

2016-09-12 Thread Karl DeSaulniers
> On Sep 12, 2016, at 2:53 PM, B. Aerts wrote: > > On 12/09/16 05:24, Karl DeSaulniers wrote: >> Hello All, >> Hoping you can help clear my head on this. I have two MySQL tables for >> custom fields data to be stored. >> >> custom_fiel

[PHP-DB] MySQL two tables and an uneven number of rows

2016-09-11 Thread Karl DeSaulniers
m in or is this just going to be too costly on server resources? TIA, Best, Karl DeSaulniers Design Drumm http://designdrumm.com <http://designdrumm.com/>

Re: [PHP-DB] Any method to get primary key matching a given value ?

2016-08-20 Thread Karl DeSaulniers
This may also shed some light for you. The accepted answer and possibly the one below it if you are on .NET http://stackoverflow.com/questions/763516/information-schema-columns-on-sqlite HTH, Best, Karl DeSaulniers Design Drumm http://designdrumm.com > On Aug 20, 2016, at 5:30 AM, K

Re: [PHP-DB] Any method to get primary key matching a given value ?

2016-08-20 Thread Karl DeSaulniers
Hey Ratin, Have you looked into the table column named 'pk' inside table_info? That is where a column is indicated to be a primary key or not. Best, Karl DeSaulniers Design Drumm http://designdrumm.com <http://designdrumm.com/> > On Aug 18, 2016, at 6:51 PM, Ratin

Re: [PHP-DB] Any method to get primary key matching a given value ?

2016-08-18 Thread Karl DeSaulniers
Hi Ratin, Going to take a stab at this one. Have you looked into INFORMATION_SCHEMA.COLUMNS for your query? Might be where you want to look for what you are trying. Sorry can't help more. Best, Karl DeSaulniers Design Drumm http://designdrumm.com > On Aug 18, 2016, at 1:27 PM, Rati

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

2016-01-26 Thread Karl DeSaulniers
Oh ok, thanks for the clarification. Sorry for the noise. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Jan 26, 2016, at 1:07 PM, Alko Kotalko wrote: > It shouldn't be like that because I'm preparing a statement, which would > later have had parameters pa

Re: [PHP-DB] PDO and SAP HANA prepared statements issue

2016-01-26 Thread Karl DeSaulniers
7;".$1."' AND col2='".$2."' AND col3='".$1."' " ? I have found that letting php create the string without the quotes and periods in a SQL statement can cause issues. Don't ask me why it causes issues, I couldn't tell you :) Just my experience. Best, Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Select on Group

2015-11-16 Thread Karl DeSaulniers
WHERE ft.Field_Group='%s' AND mt.Page_ID=%d AND ft.Field_Display='%s' ORDER BY ft.Field_ID ASC"; $Fields = $wpdb->get_results($wpdb->prepare($SQL, $field_group, $Page_ID, $display)); } [end code]

Re: [PHP-DB] Correct Syntax?

2015-10-30 Thread Karl DeSaulniers
Hi, I have since moved on from this as it wasn't what I needed. Thanks for your response though. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Oct 30, 2015, at 3:32 AM, chimurenga chimurenga wrote: > make vehicle licence the unique key > > On 14 Oct 201

Re: [PHP-DB] Correct Syntax?

2015-10-13 Thread Karl DeSaulniers
On Oct 13, 2015, at 8:40 PM, Roberto Spadim wrote: > instead of +, use ",' > > 2015-10-13 20:21 GMT-03:00 Karl DeSaulniers : > Quick question. Is this viable in MySQL? > > UNIQUE KEY `Vehicle_Name` > (`Vehicle_Make`+`Vehicle_Model`+`Vehicle_Style`+`Vehic

[PHP-DB] Correct Syntax?

2015-10-13 Thread Karl DeSaulniers
Quick question. Is this viable in MySQL? UNIQUE KEY `Vehicle_Name` (`Vehicle_Make`+`Vehicle_Model`+`Vehicle_Style`+`Vehicle_License`) TIA Best, Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Zero Values

2015-09-02 Thread Karl DeSaulniers
|0.00 | > | -72.00 |65.00 |0.00 | > > TIA > > Ethan Something like? $SQL = "SELECT * FROM `Charges` WHERE Cust_Num=".$Cust_Num." AND Charges!='NULL' AND Ballance!='NULL' AND Payments!='NULL' ORDER BY Date ASC";

Re: [PHP-DB] Zero Values

2015-09-02 Thread Karl DeSaulniers
, visit: http://www.php.net/unsub.php > I would recommend storing the zero value if you plan on using that value for calculation later. Just makes things easier than having to do a if(NULL) statement. 2¢ Best, Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] For my understanding

2015-07-25 Thread Karl DeSaulniers
#x27;, '$val = trim($val);')); Is this creating php variables from the contents of the $Options array? TIA Best, Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Grouping results

2015-07-23 Thread Karl DeSaulniers
elds as $i=>$Field) { $ReturnString .= /*Other code to build html*/ } } return $ReturnString; I am working on a WordPress site. Hence the $wpdb->get_results(). FYI, for those who aren't familiar. Best, Karl DeSaulniers Design Drumm http://designdrumm.com PS: Th

[PHP-DB] Grouping results

2015-07-22 Thread Karl DeSaulniers
//Field_Group = BOB //empty Field_Group //empty Field_Group //Field_Group = Charlie Am I setting this up right? TIA Best, Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] SQL Injection

2015-05-16 Thread Karl DeSaulniers
On May 16, 2015, at 8:42 AM, Lester Caine wrote: > On 16/05/15 10:00, Karl DeSaulniers wrote: >> That does clarify things a bit better on both the @ question >> and prepared statements. Thank you for the link as well. >> >> So new question.. what is the best typ

Re: [PHP-DB] SQL Injection

2015-05-16 Thread Karl DeSaulniers
On May 16, 2015, at 3:51 AM, Lester Caine wrote: > On 15/05/15 06:21, Karl DeSaulniers wrote: >> Oh ok. Now it makes a little more sense. >> I have worked in ASP before, but I am programming in PHP and MySQL at the >> moment. >> >> I am going to look int

Re: [PHP-DB] SQL Injection

2015-05-14 Thread Karl DeSaulniers
server, you will ned to rework a lot of > your code. Not so with PDO. > > Hope this helps, > > -Kevin Waddell > Proverbs 3:5-6 Oh ok. Now it makes a little more sense. I have worked in ASP before, but I am programming in PHP and MySQL at the moment. I am going to look

Re: [PHP-DB] SQL Injection

2015-05-14 Thread Karl DeSaulniers
On May 14, 2015, at 8:37 PM, Jigme Datse Yli-Rasku wrote: > On 15/05/14 18:19 , Karl DeSaulniers wrote: >> On May 14, 2015, at 8:09 PM, Aziz Saleh wrote: >> >>> >>> >>> On Thu, May 14, 2015 at 9:05 PM, Karl DeSaulniers >>> wrote: >>

Re: [PHP-DB] SQL Injection

2015-05-14 Thread Karl DeSaulniers
On May 14, 2015, at 8:09 PM, Aziz Saleh wrote: > > > On Thu, May 14, 2015 at 9:05 PM, Karl DeSaulniers > wrote: > Hello Everyone, > Have a quick question. Was reading some material and wanted some Players > perspective. > I know w3schools is not the de-facto on ev

[PHP-DB] SQL Injection

2015-05-14 Thread Karl DeSaulniers
SQL Values and because this talks about SQL and not MySQL specifically, does this not apply to MySQL? To my uneducated eyes it seems legit. Any clarification is greatly appreciated. TIA, Best, Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Input Mathematical symbol in HTML textbox

2015-05-07 Thread Karl DeSaulniers
^ is the caret in ascii Best, Karl Sent from losPhone > On May 7, 2015, at 9:18 AM, Guru wrote: > > Hi All, > > I need help with a tool I am developing for my client. What I want is, how > can I type X^2 square or M Cube (M^3) in html text box. Is there any method > I can follow. Also it shou

Re: [PHP-DB] Waiting for localhost

2015-04-02 Thread Karl DeSaulniers
My apology to the list. That was meant for Ethan's email only. I hit reply all when I though I just hit reply. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Apr 2, 2015, at 2:18 PM, Karl DeSaulniers wrote: > Bro. Pick a SQL. mysql_ or mysqli_. > > Best, &g

Re: [PHP-DB] Waiting for localhost

2015-04-02 Thread Karl DeSaulniers
Bro. Pick a SQL. mysql_ or mysqli_. Best, Karl Sent from losPhone > On Apr 2, 2015, at 12:48 PM, Ethan Rosenberg > wrote: > >> On 04/02/2015 06:17 AM, Richard wrote: > > >>> Here are some hints >>> >>> service apache2 restart >>> [] Restarting web server: apache2AH00558: apache2: C

Re: [PHP-DB] Waiting for localhost

2015-04-01 Thread Karl DeSaulniers
Question to list, since I have not had to venture to the mysqli territory just yet, but is it proper to use mysql_error() with mysqli transactions? This may be what your missing Ethan. mysql_error() looks for a mysql_ transactions doesn't it? Or are they interchangeable? Best,

Re: [PHP-DB] Waiting for localhost

2015-03-17 Thread Karl DeSaulniers
No, can't say I do. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Mar 17, 2015, at 11:48 PM, "Ethan Rosenberg, PhD" wrote: > Karl - > > Thanks to you and all others that have replied. > > With a little bit of patience [which I should have us

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Karl DeSaulniers
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 Rosenberg wrote: > > Jayson, Karl

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Karl DeSaulniers
Also, if it is a matter of calling this script. Maybe try curl instead of echoing a javascript file? Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Mar 15, 2015, at 8:25 PM, Karl DeSaulniers wrote: > Why are you not calling a database for the weight? Or is that what

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Karl DeSaulniers
Why are you not calling a database for the weight? Or is that what the handleweight.php does? If it is a matter of echoing the results from this page, can it's code be merged into the current? Then instead of echoing the you just echo the results. Best, Karl DeSaulniers Design Drumm &l

Re: [PHP-DB] Waiting for localhost

2015-03-14 Thread Karl DeSaulniers
Fresh out of ideas. Sorry Ethan. Maybe try an different approach to calling that file? Seems like your trying to fit a square peg in a hexagon hole. Might get it in there but it wont be a perfect fit. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Mar 14, 2015, at 9:17 PM

Re: [PHP-DB] Code Security

2015-02-13 Thread Karl DeSaulniers
iomedical.com] > Sent: Friday, February 13, 2015 9:12 AM > To: php-db@lists.php.net > Subject: 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 P

Re: [PHP-DB] Re: Code Security

2015-02-13 Thread Karl DeSaulniers
up > being significantly arduous for the end users... > Respectfully, > Joshua D. Arneson > -Original Message-From: Ethan Rosenberg > [mailto:erosenb...@hygeiabiomedical.com] Sent: Friday, February 13, > 2015 9:12 AMTo: php...@lists.php.netSubject: Re: [PHP-DB] Code >

Re: [PHP-DB] Code Security

2015-02-12 Thread Karl DeSaulniers
the system can be accessed. Like an access key card. Immediate shut down when tampered and/or removed. Just a stab in the dark though. Best, Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.

Re: [PHP-DB] MySQLi

2014-09-15 Thread Karl DeSaulniers
On Sep 15, 2014, at 11:51 AM, Jasper Kips wrote: > > >> Op 15 sep. 2014 om 01:08 heeft Karl DeSaulniers het >> volgende geschreven: >> >> Procedural php. Haven't had a chance to learn OOP. Would love to though. : / >> I think I may be moling it a bi

Re: [PHP-DB] MySQLi

2014-09-14 Thread Karl DeSaulniers
Procedural php. Haven't had a chance to learn OOP. Would love to though. : / I think I may be moling it a bit too. Guess I was hoping for an easy fix, don't judge me.. :P Thanks for all your responses everyone. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Sep 14,

Re: [PHP-DB] MySQLi

2014-09-13 Thread Karl DeSaulniers
Awesome, thanks for the link. I know even less about PDO then I do regular MySQL however. I am hoping MySQLi isn't too far off a shoot. Just need to sit down with it all and figure out a path. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Sep 13, 2014, at 10:52 PM,

Re: [PHP-DB] MySQLi

2014-09-13 Thread Karl DeSaulniers
On Sep 13, 2014, at 7:40 AM, Lester Caine wrote: > On 13/09/14 11:40, Karl DeSaulniers wrote: >> Hope this message finds you well. Quick question about MySQLi and PHP. >> I have a website that was built back in 2012 that is still on PHP 5.2 and >> MySQL >> and I am

[PHP-DB] MySQLi

2014-09-13 Thread Karl DeSaulniers
sugar remedy for this medicine or do I just grow a pair and take it? Any MySQL => MySQLi converters out there? Any PHP5.2 => PHP 5.7 cheat sheets? If I update my server to PHP 5.7 is everything going to break? Or stupid question of course it is? lol TIA, Best, Karl DeSaulniers Design Drum

Re: [PHP-DB] Number of Lines in Table.

2014-09-02 Thread Karl DeSaulniers
On Sep 3, 2014, at 12:13 AM, Karl DeSaulniers wrote: >> >> >>> Dear List - >>> >>> This works: >>> >>> mysql> describe Purchases; >>> +---+-+--+-+-+-

Re: [PHP-DB] Number of Lines in Table.

2014-09-02 Thread Karl DeSaulniers
I see. Ok thanks Matt. Will look into that if I start working with those size databases. My apology Ethan, wasn't aware of the scope. Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Sep 3, 2014, at 12:09 AM, Matt Pelmear wrote: > Karl, > > This works for small

Re: [PHP-DB] Number of Lines in Table.

2014-09-02 Thread Karl DeSaulniers
Whoops, this should be.. print_r('Results { '.$rowarray.' }'); Karl DeSaulniers Design Drumm http://designdrumm.com On Sep 2, 2014, at 11:57 PM, Karl DeSaulniers wrote: > print_r('Results { '.$row.' }'); -- PHP Database Mailing List (http:

Re: [PHP-DB] Number of Lines in Table.

2014-09-02 Thread Karl DeSaulniers
_array($result); $numrows = count($rowarray); //return $rowarray; print_r('Number of rows: '.$numrows); print_r('Results { '.$row.' }'); Haven't tested this, but I believe it should work out the box. May need to tweek to taste. HTH, Best, Karl DeSauln

Re: [PHP-DB] www-data file

2014-08-25 Thread Karl DeSaulniers
On Aug 25, 2014, at 11:20 PM, Ethan Rosenberg wrote: > 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 Are we talking about file permissions? Best, Ka

Re: [PHP-DB] What is my Mistake?

2014-06-24 Thread Karl DeSaulniers
On Jun 24, 2014, at 2:53 AM, Karl DeSaulniers wrote: > On Jun 24, 2014, at 2:46 AM, Karl DeSaulniers wrote: > >> On Jun 24, 2014, at 12:27 AM, Ethan Rosenberg >> wrote: >> >>> Dear List - >>> >>> I know I have a mistake here, but I

Re: [PHP-DB] What is my Mistake?

2014-06-24 Thread Karl DeSaulniers
On Jun 24, 2014, at 2:46 AM, Karl DeSaulniers wrote: > On Jun 24, 2014, at 12:27 AM, Ethan Rosenberg > wrote: > >> Dear List - >> >> I know I have a mistake here, but I cannot find it. >> >> This is a part of a switch. >> >> The switch

Re: [PHP-DB] What is my Mistake?

2014-06-24 Thread Karl DeSaulniers
$return_string .= ' '.htmlspecialchars($row1[0]).' '.htmlspecialchars($row1[1]).' '.htmlspecialchars($row1[2]).' '; } } $return_string .= ''; break; } [END CODE] Best, Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] VAR_DUMP INTO PHP VARIABLES

2014-06-18 Thread Karl DeSaulniers
Sent from losPhone > On Jun 19, 2014, at 12:40 AM, Oriole Computing > wrote: > > dear List, > > we have the following var_dump output from a soap response > > array(1) { > ["return"]=> > array(3) { >["responseCode"]=> >string(1) "3" >["responseMessage"]=> >string(39) "Dupl

Re: [PHP-DB] Newbie Question $2

2014-06-18 Thread Karl DeSaulniers
Sent from losPhone > On Jun 18, 2014, at 7:56 AM, Jim Giner wrote: > >> On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote: >>> On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote: >>> Hi Ethan, >>> >>> Here are some things to clean up your code: >>> >>> Your line: >>> >>> $phn = $_POST[phone

Re: [PHP-DB] Newbie Question $2

2014-06-16 Thread Karl DeSaulniers
On Jun 16, 2014, at 10:05 PM, Karl DeSaulniers wrote: > On Jun 16, 2014, at 9:58 PM, Ethan Rosenberg > wrote: > >> Dear List - >> >> I have the following code: >> >> The input from the form is a 10 digit string [1234567890] which is converted

Re: [PHP-DB] Newbie Question $2

2014-06-16 Thread Karl DeSaulniers
l and mysqli. Don't know if that is wise or permissible since I think mysql has been depreciated. Go with mysqli. Next you may want to try... $sql1 = 'SELECT Lname, Fname FROM Customers WHERE Phone = '.$Phn; Best, Karl DeSaulniers Design Drumm http://designdrumm.com > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MS Access Connection with database password

2014-06-06 Thread Karl DeSaulniers
I think the code you translated might be for the .accdb file. In your translated code I noticed .mdb so per that page, this apples for .mdb With database password (mdb file) This is the connection string to use when you have an Access 97 - 2003 database protected with a password using the "Set D

Re: [PHP-DB] Subject Matter

2013-08-26 Thread Karl DeSaulniers
to throw out the random rant about off topic conversations in hopes that it sinks into these newbies and that some day they too will trim the conversations down to the brass tax, then by all means vent away.. in retrospect, they need to hear this. Just don't go threatening to aband

Re: [PHP-DB] Bluefish for PHP

2013-08-23 Thread Karl DeSaulniers
Komodo is very nice. Karl DeSaulniers Design Drumm http://designdrumm.com On Aug 23, 2013, at 2:58 AM, Michael Oki wrote: > Install Komodo IDE or Adobe Dreamweaver. They'll highlight errors and > warnings. > > > On 23 August 2013 08:20, Lester Caine wrote: > &

Re: [PHP-DB] Re: mysql query

2013-08-23 Thread Karl DeSaulniers
If your on a PC I would just get Eclipse. But if you have netbeans, you can set the syntax highlighting for the different scripts you write in the preferences. PHP, java, javascript, etc... Best, Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http

Re: [PHP-DB] Re: One query, different tables?

2013-08-09 Thread Karl DeSaulniers
Probably with separate queries I would say. Query store 1, move to truck then query truck and move to store 2. Best, Karl Sent from losPhone On Aug 9, 2013, at 10:13 AM, Jim Giner wrote: > On 8/9/2013 10:56 AM, Karl-Arne Gjersøyen wrote: >> Hello. >> I am newbie in this and need som basic hel

Re: [PHP-DB] Problem with query

2013-06-25 Thread Karl DeSaulniers
Im going to play devils advocate here and say, why is it the one who's helping that needs to be polite and respectful? Isn't it also the newbies responsibility to respect and be polite to those taking time out of their day to help them and not be so stubborn as to not take the advice given which

Re: [PHP-DB] Placing a form on a page

2013-05-06 Thread Karl DeSaulniers
I would suggest googling your problem. In this case "centering an HTML form". Hth, Best, Karl DeSaulniers Design Drumm http://designdrumm.com On May 6, 2013, at 12:00 AM, Ethan Rosenberg, PhD wrote: > > On 05/06/2013 12:48 AM, tamouse mailing lists wrote: >> On Sun

Re: [PHP-DB] Saving Image in mySQL

2013-03-20 Thread Karl DeSaulniers
atalog for instance, dont store image data, use the url instead. If its ui images for a couple of web pages, then storing the image data wouldn't be a bad thing. As long as the total size for all of your images is reasonable. Your call. Best, Karl On Mar 19, 2013, at 6:11 PM, Karl DeSaulnie

Re: [PHP-DB] Saving Image in mySQL

2013-03-19 Thread Karl DeSaulniers
$_FILES["file"]["name"], PDO::PARAM_STR); $stmt->bindValue(':image', $file, PDO::PARAM_STR); # execute query if ( $stmt->execute() or die(print_r($stmt->errorInfo(), true)) ) { # retrieve auto_increment value $new_rec

Re: [PHP-DB] My Comments

2013-02-21 Thread Karl DeSaulniers
s you obviously DO NOT have a degree in. The people here really do want to help you, believe it or not. But they are not going to help tout your ego or continue to butt heads with a stubborn person. They'll just let it alone and let you fend for yourself. Just a suggestion, all sarcasm

Re: [PHP-DB] My Comments

2013-02-21 Thread Karl DeSaulniers
P, HTML, etc... GL 2 U, Best, Karl DeSaulniers Associates in Visual Communications (Graphic Design) Self Taught HTML, CSS, Javascript, Ajax, JQuery, XML, PHP and MySQL toot toot! Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Processing Account Login

2013-02-07 Thread Karl DeSaulniers
HP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Query will not work - SOLVED

2013-02-02 Thread Karl DeSaulniers
am I doing wrong?? Ethan = I was using the "worker@localhost", which did not have the Update privilege. Added the privilege that, and everything worked. Sorry for bothering you with trivia. Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] pdo ?

2013-01-24 Thread Karl DeSaulniers
gest the last one if your not going to sanitize yourself as it will make you vulnerable. But all-in-all very simple to implement. Best, Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: SQL syntax

2013-01-15 Thread Karl DeSaulniers
On Jan 15, 2013, at 6:47 AM, Bastien wrote: Try It And See Bastien Koert On 2013-01-15, at 7:43 AM, Karl DeSaulniers wrote: On Jan 15, 2013, at 5:31 AM, David Robley wrote: Karl DeSaulniers wrote: Hello Everyone, Hope your 2013 is treating you well. Quick question and apologies if it i

Re: [PHP-DB] Re: SQL syntax

2013-01-15 Thread Karl DeSaulniers
On Jan 15, 2013, at 5:31 AM, David Robley wrote: Karl DeSaulniers wrote: Hello Everyone, Hope your 2013 is treating you well. Quick question and apologies if it is a stupid question. Is this a viable syntax? $sql = "SELECT orderid FROM ORDERS_TABLE WHERE orderstatus = 'Can

Re: [PHP-DB] SQL syntax

2013-01-15 Thread Karl DeSaulniers
d-in-set >. This is useful if your data type is SET/ENUM type - Field<http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_field > On Tue, Jan 15, 2013 at 2:59 PM, Karl DeSaulniers >wrote: SELECT orderid FROM ORDERS_TABLE WHERE ordersta

[PHP-DB] SQL syntax

2013-01-15 Thread Karl DeSaulniers
_TABLE WHERE orderstatus = 'Cancelled' OR (orderstatus = 'New' AND orderdate < '".mysqli_real_escape_string($yesterday)."') OR (orderstatus = 'Denied' AND orderdate < '".mysqli_real_escape_string($yesterday)."') OR (orderstatus = 'Expired' AND orderdate < '".mysqli_real_escape_string($yesterday)."') ... etc"; TIA, Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Preventing repetition of a Form

2013-01-07 Thread Karl DeSaulniers
tion being called when welcome_already_seen isset() and if it is not and if there is an error and if not, regardless of what page is being displayed. Put the function call only in the switch statement for each page you want it called and not for 10. Karl DeSaulniers Design Drumm http://d

Re: [PHP-DB] Programs not running

2013-01-07 Thread Karl DeSaulniers
On Jan 6, 2013, at 9:09 PM, tamouse mailing lists wrote: On Sun, Jan 6, 2013 at 2:14 PM, Karl DeSaulniers wrote: Unfortunately, I am still working on an old G4 Powerbook trying to finish a website of mine. Adobe GoLive was the program I imprinted on and it stuck. Sadly it has gone away

Re: [PHP-DB] Programs not running

2013-01-06 Thread Karl DeSaulniers
On Jan 6, 2013, at 4:55 AM, tamouse mailing lists wrote: On Sun, Jan 6, 2013 at 1:21 AM, Karl DeSaulniers wrote: I likey.. :) Thanks! Best, Karl On Jan 5, 2013, at 10:05 PM, Bastien wrote: Get net beans. It's free and a great IDE with debuggers and other stuff Bastien

Re: [PHP-DB] Programs not running

2013-01-05 Thread Karl DeSaulniers
I likey.. :) Thanks! Best, Karl On Jan 5, 2013, at 10:05 PM, Bastien wrote: Get net beans. It's free and a great IDE with debuggers and other stuff Bastien Koert On 2013-01-05, at 7:14 PM, Karl DeSaulniers wrote: On Jan 5, 2013, at 8:52 AM, tamouse mailing lists wrote: O

Re: [PHP-DB] Programs not running

2013-01-05 Thread Karl DeSaulniers
On Jan 5, 2013, at 8:52 AM, tamouse mailing lists wrote: On Sat, Jan 5, 2013 at 12:48 AM, Karl DeSaulniers > wrote: On Jan 4, 2013, at 8:00 PM, tamouse mailing lists wrote: On Fri, Jan 4, 2013 at 6:09 PM, Matt Pelmear wrote: On 01/04/2013 01:40 PM, tamouse mailing lists wrote: One sho

Re: [PHP-DB] Programs not running

2013-01-04 Thread Karl DeSaulniers
production without testing it? I personally have not used command line. It is new to me, but sounds integral. Where can one study its use? Best, Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

  1   2   3   4   >