[PHP-DB] Re: [PHP-WIN] Need Help with 2 MYSQL Table

2015-04-25 Thread Richard Quadling
On 25 April 2015 at 06:13, Guru wrote: > Hi All, > > Hope everyone is doing well. I need some help regarding a project. I have a > huge list of customers in a ledger in a mysql table (Table A). And in > another table I have their names and their ID number (Table B). What I want > is when I click

Re: [PHP-DB] Lost data after space in PHP variables

2015-02-19 Thread Richard Quadling
esults in ... array ( 'a_b' => 'c d', )array ( 'e_f' => 'g h', ) So, your spaces are automatically converted to _ by PHP. This is documented at http://php.net/manual/en/language.variables.external.php -- Richard Quadling

Re: [PHP-DB] Code Security

2015-02-05 Thread Richard Quadling
er (IonCube, Zend Guard) - not perfect as they can be reversed to access the code in a form. 3 - Don't use PHP. -- Richard Quadling

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

2014-06-05 Thread Richard Quadling
don't make the database, it's maintained elsewhere and I plan to > download it regularly and extract data from it so I need to connect to the > database with the password set. > > Any help or hints are deeply appreciated! > /Kjell > > -- > PHP Database Maili

Re: [PHP-DB] Problem wkith Query

2013-06-23 Thread Richard Quadling
syntax for > the session variable. Per the manual, associative arrays using string > indices should always use ' ' around them. They work (as mentioned in the > manual) but are wrong. > > Newbie is confused. > > Please explain. >

Re: [PHP-DB] Re: Problem with query

2013-06-23 Thread Richard Quadling
his the "actual" code you executed, or is it once again a typeover? > > The actual code > > > Any further errors might be related to your non-standard syntax for the > session variable. Per the manual, associative arrays using string indices > should always u

[PHP-DB] Wanted : Solid/documented/tests Nested Set Model class for mySQL.

2013-06-06 Thread Richard Quadling
g a little lazy and looking for a good recommendation. I've done searches on google, et al, but looking for recommendations from real use, rather than "this looks good". Ta. -- Richard Quadling Twitter : @RQuadling EE : http://e-e.com/M_248814.html Zend : http://bit.ly/9O8vFY

Re: [PHP-DB] Sorting a PHP array

2013-05-18 Thread Richard Quadling
unction.array-multisort.php<http://ca1.php.net/manual/en/function.array-multisort.php> >> >> Bastien >> >>> >>> >> I learned something. Never read up on this function. Could be useful > someday > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Richard Quadling Twitter : @RQuadling EE : http://e-e.com/M_248814.html Zend : http://bit.ly/9O8vFY

Re: [PHP-DB] pdo ?

2013-01-24 Thread Richard Quadling
On 24 January 2013 17:48, Matt Pelmear wrote: > On 01/24/2013 09:23 AM, Jim Giner wrote: >> >> On 1/24/2013 12:05 PM, Matt Pelmear wrote: >>> >>> >>> http://stackoverflow.com/questions/5801951/does-php-auto-escapes-quotes-in-string-which-is-passed-by-get-or-post >>> >>> >>> Every pro has this feat

[PHP-DB] MySQLi binding params and results and where in a loop they should be placed.

2012-08-13 Thread Richard Quadling
monstrate the re-use of a prepared statement, making it both a little vague and pointless (excluding the OBVIOUS advantage of sql injection protection - I'm using prepared statements mainly for that reason). -- Richard Quadling Twitter : EE : Zend : Fantasy Shopper @RQuadling : http://e-e.com

Re: [PHP-DB] Exporting mySQL to Excel

2011-11-09 Thread Richard Quadling
t; If you can specify a TAB delimited file (assuming you don't have tab characters in your data), then this is a slight upgrade to CSV. -- Richard Quadling Twitter : EE : Zend : PHPDoc : Fantasy Shopper @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea : fan.sh/6/370 -

Re: [PHP-DB] Exporting mySQL to Excel

2011-11-09 Thread Richard Quadling
ide Amazon's cloud services. I also Putty to create the tunnel and map the connection to allow the GoodData client to gather data from the mysql server for further reporting at GoodData. -- Richard Quadling Twitter : EE : Zend : PHPDoc : Fantasy Shopper @RQuadling : e-e.com/M_248814.html : bit.l

Re: [PHP-DB] Re: Using MySQLi (OOP) to call a stored procedure with INOUT and OUT parameters.

2011-09-13 Thread Richard Quadling
On 13 September 2011 04:21, Ross McKay wrote: > On Mon, 12 Sep 2011 21:18:34 +0100, Richard Quadling wrote: > >>I'm just trying to get PHP to talk to a stored procedure which has IN, >>INOUT and OUT parameters. >>[...] > > You'll probably need to trick

[PHP-DB] Using MySQLi (OOP) to call a stored procedure with INOUT and OUT parameters.

2011-09-12 Thread Richard Quadling
are supplied by reference to the bind_params() method, so I would assume that they would be returned by calling execute(). But they aren't so I'm missing something obvious. Any help please? Regards, Richard. P.S. I'm coming from MSSQL using the MS SQL Server Driver for PHP via PDO, so

Re: [PHP-DB] Re: MYSQLi fetch corrupting bound variables

2011-08-25 Thread Richard Quadling
s TRUE then the above test will pass. -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Listing parent ids

2011-07-28 Thread Richard Quadling
se but on the surface they seem adequate. But just look at the difference in the volume of code. NS => AL ... 1 query. Any depth. It shows just how simple using a NS is. I'll stop evangelising now. I REALLY like NS. -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Listing parent ids

2011-07-28 Thread Richard Quadling
f them) which aren't mentioned. > > But, I've found Nested Sets to be much easier for me to work with, allowing > me to provide quite complex searching based upon an n-level tree. > > How you visualise the data won't change. It is still, visually at least, a > set

Re: [PHP-DB] Listing parent ids

2011-07-28 Thread Richard Quadling
And http://www.amazon.co.uk/exec/obidos/ASIN/1558609202/onlinepricecouk -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Listing parent ids

2011-07-28 Thread Richard Quadling
kw=Celkos+SQL+Smarties&_sacat=0&_dmpt=Non_Fiction&_odkw=Celkos+SQL+Smarties&_osacat=0&_trksid=p3286.c0.m270.l1313&LH_TitleDesc=1 currently showing 2 entries) and a fourth edition on Amazon (http://www.amazon.com/Joe-Celkos-SQL-Smarties-Fourth/dp/0123820227/ref=sr_1_1?ie=UTF8&qid=1311847652&sr=8-1) -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] how does this regular expression works

2011-07-14 Thread Richard Quadling
rally «» Created with RegexBuddy -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] how does this regular expression works

2011-07-14 Thread Richard Quadling
ncy. Learning when to escape is just like learning a new language. You only need to escape anything if you need it to be a literal character. e.g. something.html vs something\.html -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVe

Re: [PHP-DB] Re: problem in connecting to mysql from php

2011-06-13 Thread Richard Quadling
> > On Mon, Jun 13, 2011 at 7:36 PM, Richard Quadling > wrote: >> >> On 13 June 2011 14:12, C0mf0rtably Numb <08.kus...@gmail.com> wrote: >> > Any help? >> > >> > On Mon, Jun 13, 2011 at 5:38 PM, C0mf0rtably Numb >> > <08.kus.

Re: [PHP-DB] Re: problem in connecting to mysql from php

2011-06-13 Thread Richard Quadling
EY_LOCAL_MACHINE\SOFTWARE\PHP\x], where x, y and z mean the PHP major, minor and release versions. If there is a value for IniFilePath in these keys, then the first one found will be used as the location of the php.ini (Windows only). [HKEY_LOCAL_MACHINE\SOFTWARE\PHP], value of IniFilePath (Windows

Re: [PHP-DB] problem in connecting to mysql from php

2011-06-13 Thread Richard Quadling
on line *2 >> > >> > *Please guide me as to how can I get rid of this error? >> > >> > Regards, >> > Kushal >> > >> >> >> -- >> Extra details: >> OSS:Gentoo Linux >> profile:x86 >> Hardware:msi ge

Re: [PHP-DB] Converting from PHP4 to php5

2011-06-03 Thread Richard Quadling
features of PHP5. This could involve moving from PHP4 procedural code to PHP5 OOP. This could require a significant investment in time (and therefore money), depending upon the project. And may not be necessary. Richard. -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_2488

Re: [PHP-DB] Converting from PHP4 to php5

2011-06-02 Thread Richard Quadling
Thank you, > Marc Hall > HallMarc Websites > 610.446.3346 > http://www.hallmarcwebsites.com/ But advertising your services is OK? -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea -- PHP Database Mailing List (http://

Re: [PHP-DB] Pause While-loop when waiting for function call to complete

2011-04-24 Thread Richard Quadling
plete before the code that follows the call continues. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP-WIN] Need Help with PHP Mails

2011-04-04 Thread Richard Quadling
> mail($email,$party_name,$contact_no); > > ?> > > > > 2011/4/4 Richard Quadling >> >> 2011/4/4 Guru™ : >> > Hi Richard, >> > I am using simple PHP mail function but, I am unable to send an email to >> > myself. What I want is when the

[PHP-DB] Re: [PHP-WIN] Need Help with PHP Mails

2011-04-04 Thread Richard Quadling
2011/4/4 Guru™ : > Hi Richard, > I am using simple PHP mail function but, I am unable to send an email to > myself. What I want is when the user click on submit button I should get an > email with the form data. > > > > 2011/4/4 Richard Quadling >> >> 2011/

[PHP-DB] Re: [PHP-WIN] Need Help with PHP Mails

2011-04-04 Thread Richard Quadling
ility. See http://uk.php.net/manual/en/book.mail.php for all the lovely documentation, especially with the runtime configuration options. Most likely, you've not set these appropriately. But, in short, you are going to need to tell us what is NOT working for any realistic help. Personally

[PHP-DB] Stored Procedures, Dynamic SQL or static SQL and testing.

2011-03-26 Thread Richard Quadling
mainly relates to SPs). Does using a different RDBMS make a difference to the SQL coding style you'd use? This isn't for any sort of thesis, just trying to see what the general consensus is of those that reply. Thanks for answering. Richard Quadling. -- Richard Quadling Twitter :

Re: [PHP-DB] UPDATE IF

2011-03-14 Thread Richard Quadling
THEN Value ELSE Column1 END WHERE IDColumn = ID something like that? -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP-WIN] Re: Error while inserting data into mysql

2011-03-01 Thread Richard Quadling
e scloth100 columns I can see are ... |scloth100_totamt|int(20)|Yes|NULL |scloth100_utp|int(20)|Yes|NULL |scloth100_val|int(20)|Yes|NULL |scloth100_vatp|int(20)|Yes|NULL |scloth100_vatr|int(10)|Yes|NULL |scloth100|varchar(100)|Yes|NULL No scloth100_qty. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.

[PHP-DB] Re: [PHP-WIN] Re: Error while inserting data into mysql

2011-03-01 Thread Richard Quadling
. Can you tell me what column in the table is scloth100_qty? I can't find it. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Error while inserting data into mysql

2011-03-01 Thread Richard Quadling
> Best, > Guru. > You have some PHP code. It is attempting to write to a mysql table. One of the columns you've coded for doesn't exist. Maybe. Can you show us the table structure and the exact SQL statement you are executing please? Richard. -- Richard Quadling Twitter :

Re: [PHP-DB] 2nd Pair of eyes please

2011-01-27 Thread Richard Quadling
Look through php.ini-development to see what choices you have and decide what would be useful. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Getting Results

2011-01-21 Thread Richard Quadling
server. Regards, Richard. [1] http://msdn.microsoft.com/en-us/library/ms188366.aspx -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Getting Results

2011-01-21 Thread Richard Quadling
On 21 January 2011 11:58, Karl DeSaulniers wrote: > So to do descending order I'd put DES or DEC? Just curious about that one. ASC and DESC -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.

Re: [PHP-DB] Re: Getting Results

2011-01-21 Thread Richard Quadling
nd previous row to the current row in a result set, where a single table is essentially bound 3 times, but with the CTE, additional optimization seems to be in play and work a LOT faster overall. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PH

[PHP-DB] Re: [PHP] Problems w/ goto

2010-12-17 Thread Richard Quadling
show the people in my office, and we all got a chuckle from teh > XKCD comic in the PHP documentation for GOTO > http://ca2.php.net/goto > > Steve > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > An

Re: [PHP-DB] NULL to 0 result

2010-12-15 Thread Richard Quadling
`rss_feed_include`, `reference` Normally COUNT() will count NULLs, but as you are grouping by the counted column, nulls would be in their own row. Richard. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http

Re: [PHP-DB] NULL values

2010-12-04 Thread Richard Quadling
retrieve as well.  How do I make a WHERE >> clause for a cell that is NULL ? >> >> Ron >> >> The Verse of the Day >> “Encouragement from God’s Word” >> http://www.TheVerseOfTheDay.info >> > http://dev.mysql.com/doc/refman/5.0/en/comparison

Re: [PHP-DB] Re: ezmlm warning

2010-11-05 Thread Richard Quadling
27;ll see a message number (not to be > confused with a message ID), and you can build a dynamic email address > to which you simply send a blank email.  Moments later, you should > receive a copy of the original email --- and usually that will come > through, by request. >

Re: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Richard Quadling
g to Sites. As far as the app goes? You tell it which of the available sites the medical record is for and insert it (along with any other user supplied data). The integrity is preserved by the DB. "Just doing my job, sir!" Richard. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e

Re: [PHP-DB] Parsing Tab Delimited file

2010-10-26 Thread Richard Quadling
gt; >> >> -- >> Andrés G. Montañez >> Zend Certified Engineer >> Montevideo - Uruguay > > > Andres - > > Sorry for the delay. > > Thanks.  With what you and Jayson sent,  it works beautifully. > > Ethan > > > -- > P

Re: [PHP-DB] Books

2010-10-19 Thread Richard Quadling
of the time I build small chunks and use them as templates. I use MS SQL, so I have MS BOL (Books OnLine). My JS work is done mainly using PrototypeJS, so there manual is online. And of course, there is the PHP manual at docs.php.net. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.

Re: [PHP-DB] session expiration

2010-09-28 Thread Richard Quadling
nd the session duration using session_cache_expire(). Make sure you call session_cache_expire() before you call session_start(). -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] formatting a word doc using php ?

2010-09-20 Thread Richard Quadling
d. And when the binary format changes (though less likely now due to the XML route), then you'd have to be waiting on the developer to fix the code first. If XML is in your capability, then I'd go with that at a first attempt, then the third party class and finally the COM. Richard. -- Ri

Re: [PHP-DB] SELECT / ORDER BY

2010-09-13 Thread Richard Quadling
dads. So, ORDER BY `bible_concordance_words`.`word` ASC, word_usage DESC,`bible_concordance_usage`.`date_accessed` DESC And as you are grouping by `bible_concordance_words`.`word`, there really is never going to be a duplicate. So, there is no need to order by anything else. So, ORDER B

Re: [PHP-DB] Is this syntax is correct?

2010-09-06 Thread Richard Quadling
salted password, sure. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP-WIN] Select the specific user data from the database

2010-09-06 Thread Richard Quadling
always the most uptodate. Cloning a table was far easier. Richard. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Test (getting bounced).

2010-08-26 Thread Richard Quadling
Test. -- Richard Quadling. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] COUNT() query help

2010-08-13 Thread Richard Quadling
WHERE `word` LIKE '$letter%' GROUP BY `bible_concordance_words`.`word`, ORDER BY `word` ASC -- Richard Quadling. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] input statement in php

2010-07-27 Thread Richard Quadling
s a predefined resource, so no need to fopen()/fclose() it. Hope this helps. Regards, Richard Quadling. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Email validation

2010-06-29 Thread Richard Quadling
py regular expressions from online libraries or discussion forums. Always test them on your own data and with your own applications." As for the MX part, PHP has the getmxrr() function for this task - http://docs.php.net/manual/en/function.getmxrr.php There are also a lot of user notes cover

Re: [PHP-DB] Major Cookie Problem

2010-05-13 Thread Richard Quadling
On 13 May 2010 12:32, Barry Zimmerman wrote: > setcookie('peg', 'YES', 'time()+190', '', 0); Can you try removing the quotes from around the expire parameter. setcookie('peg', 'YES', time()+190, '', 0); Richard -- ---

Re: [PHP-DB]how to handle exception in php

2010-05-04 Thread Richard Quadling
ions. while (False !== ($row = mysql_fetch_assoc($result))) { Whilst this offers nothing extra here, for functions where 0 or "" are valid responses and False is the "get me out of here" response, testing for type and value (!==) is important. -- - Richard Quadling "Standing

Re: [PHP-DB] session management

2010-04-23 Thread Richard Quadling
if this is > the best way ? > > What do you guys use for sessions, and which is the best possible way ? > > Thanks, > Vinay > https://code.google.com/p/loginsystem-rd/ This was developed as an easy "drop-in" secure login facility. It may give you some mileage. -- -

Re: [PHP-DB] PDO include table name prefixes in FETCH_ASSOC

2010-03-25 Thread Richard Quadling
ERE ... ORDER BY ...) >> UNION >> (SELECT col1, col2, col4 FROM table2 WHERE ... ORDER BY ...) >> >> >>> --Aaron >>> >>> >>> -- >>> PHP Database Mailing List (http://www.php.net/) >>> To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] PDO include table name prefixes in FETCH_ASSOC

2010-03-24 Thread Richard Quadling
t; > --Aaron > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > The data coming from the server dictates the column names, not PDO. If you need to identify the names, then use aliases in the SQL. --

Re: [PHP-DB] Using mssql serial command in PHP 5.3

2010-02-18 Thread Richard Quadling
;FamilyID=c6c3e9ef-ba29-4a43-8d69-a2bed18fe73c contains all the links (there are a lot). Look for "Microsoft SQL Server 2005 Driver for PHP" and "Microsoft SQL Server 2008 Native Client" for more info. The Native Client download for x86 is http://go.microsoft.com/fwlink/?LinkId=

Re: [PHP-DB] PHP Objects and SQL Results

2010-02-13 Thread Richard Quadling
? > > Thanks, > Paul You can use mysql_result() (http://docs.php.net/manual/en/function.mysql-result.php) to read a specific row from the result set. But you could also use the SQL WHERE or LIMIT clause to only retrieve the specific row or rows you wanted. -- - Richard Quadling

Re: [PHP-DB] Storing Images #2

2010-02-05 Thread Richard Quadling
your images downloaded without any checks of who is doing it. If I can enter the URL of the image directly, why would I pay you for it (for example). So, producing a symlink/alias of the images folder so that it DOES exist within docroot is completely redundant. Something like this is what I would

Re: [PHP-DB] Storing images

2010-02-03 Thread Richard Quadling
; Thanks, > > Karl > > On Feb 3, 2010, at 10:31 AM, Richard Quadling wrote: > >> If you have any writers, then you need to introduce a locking >> mechanism or some other protection. > > Karl DeSaulniers > Design Drumm > http://designdrumm.com > &g

Re: [PHP-DB] Storing images

2010-02-03 Thread Richard Quadling
anks, > > Karl > > On Feb 3, 2010, at 10:14 AM, Richard Quadling wrote: > >> On 3 February 2010 16:07, Karl DeSaulniers wrote: >>> >>> Thank you all for your numerous responses. >>> >>> I hear you loud and clear. I was wanting to see if it

Re: [PHP-DB] Storing images

2010-02-03 Thread Richard Quadling
ges/image1.jpg http://www.yoursite.com/images/image1.jpg would probably work. But ... /home/sites/your_site/public_html/getImage.php /home/sites/your_site/hidden_images/image1.jpg Now, there is no way I can load image1.jpg from my browser. I have to use getImage.php, which I assume would require me t

Re: [PHP-DB] MIME Alternatimve Emails

2010-01-30 Thread Richard Quadling
it was just the new header info I was plugging in > so to do the whole checking if a user can receive HTML emails or text. > > Any thoughts on what order I should be putting the headers I have? > TIA, > > Karl > > > On Jan 30, 2010, at 7:13 AM, Richard Quadling wrote: > &g

Re: [PHP-DB] MIME Alternatimve Emails

2010-01-30 Thread Richard Quadling
n mail($email, $subject, $message, $headers); > >   } > > My question is what order should the headers be in from top to bottom that I > have to work properly? > Currently it does not display the HTML on MAC but it does in Hotmail. MAC > mail is grabbing the text version. > So

Re: [PHP-DB] FW: semaphores WAS: [PHP-DB] Automatic logoff

2010-01-29 Thread Richard Quadling
o save the row include ... where rows_last_edited_datetime = the_datetime_I_read_when_I_started_editing_the_row But I don't like that method. It is first saves wins, rather than locking. -- - Richard Quadling "Standing on the shoulders of some very clever giants!" EE : http://www.experts-exchange.com/M_248814.html E

Re: [PHP-DB] FW: semaphores WAS: [PHP-DB] Automatic logoff

2010-01-28 Thread Richard Quadling
ry semaphores are meant to be used > for event notification (post-ability from any thread) and mutual exclusion. > Events are also sometimes called event semaphores and are used for event > notification." > > And this also helped to clarify: > http://stackoverflow.com/questio

Re: [PHP-DB] Automatic logoff

2010-01-28 Thread Richard Quadling
On 28 January 2010 20:29, listread wrote: > Richard, > > One more question (for now):   Are there advantages to using a separate > table for locking, rather than specifying a lock column in the table you > want to lock the row in? > > - Ron > > On 1/28/2010 5:47

Re: [PHP-DB] Automatic logoff

2010-01-28 Thread Richard Quadling
> - Ron > > > > > On 1/27/2010 8:14 AM, Richard Quadling wrote: >> >> The technique I've used in the past is semaphore locking, where the >> semaphore contains the session and the expected expiry time. >> >> Follow this. >> >> U

Re: [PHP-DB] Automatic logoff

2010-01-27 Thread Richard Quadling
in a separate table (rather than on the record itself). Different tables have different number of columns so take different amounts of time to edit, so each table would have a different amount of time from edit to expiry. An entry on a lookup table (just a description) should, in the main, be co

Re: [PHP-DB] Im seeking a solution to check for duplicate entries with an other sequence

2010-01-12 Thread Richard Quadling
2010/1/11 Richard Quadling : > 2010/1/11 omar zorgui : >> $sentences[] = "this is a example sentence"; >> $sentences[] = "a this is example sentence"; >> $sentences[] = "example this is a sentence"; >> $sentences[] = "this is a example

Re: [PHP-DB] Im seeking a solution to check for duplicate entries with an other sequence

2010-01-11 Thread Richard Quadling
Array ( [0] => this is a example sentence [3] => this is a example sentence for a function ) -- - Richard Quadling "Standing on the shoulders of some very clever giants!" EE : http://www.experts-exchange.com/M_248814.html Zend Certified Engineer : http://zend.c

Re: [PHP-DB] printf and unsecable char

2010-01-05 Thread Richard Quadling
ring ) ; >> or something like that ! > > echo str_repeat(' ', 30); > > (if I understand what you're trying to do correctly). > > -- > Postgresql & php tutorials > http://www.designmagick.com/ > > > -- > PHP Database Mailing List (htt

Re: [PHP-DB] unlink problems

2009-11-26 Thread Richard Quadling
u can't delete it. But a quick hack later ... http://www.beepartners.com/tenders/ is where the files are and http://www.beepartners.com/admin/tenders.php is where the script it. So, "./$filename" should probably be "../tenders/$filename" maybe. Regards, Richard.

Re: [PHP-DB] Multiple instances of mysql_connect() in single PHP document.

2009-11-12 Thread Richard Quadling
onnect("localhost", "root", "secret"); 2 connections using the same server and credentials - results in 1 real connection. $db_material = mysql_connect("localhost", "root", "secret", true); $db_labor = mysql_connect("localhost", &qu

Re: [PHP-DB] Multiple instances of mysql_connect() in single PHP document.

2009-11-12 Thread Richard Quadling
2009/11/11 Chris : > Andy Shellam (Mailing Lists) wrote: >> >> Hi, >> >>> >>> If the databases are in the same mysql server, then you could qualify >>> the table select with the database name and simply re-use the >>> connection >>> >>> select db_name.table_name.field from db_name.table_name [where

Re: [PHP-DB] Multiple instances of mysql_connect() in single PHP document.

2009-11-11 Thread Richard Quadling
; As I understand things, if you make 2 or more connections to the same database server with the same credentials, you end up with 1 shared connection. This is assuming you are not using mysql_pconnect() and you are not using the new_link option on mysql_connect(). See http://svn.php.net/viewvc/php

Re: [PHP-DB] Does PHP5 support querying an MS Access MDE file?

2009-11-03 Thread Richard Quadling
[Driver Manager]Data source name not found, and no default > driver specified, SQL state IM002 in SQLConnect in > /var/www/www.example.com/ht-secure/database_entry/test.php on line 9 > > > $mdbFilename = "/root/tims_db.mde"; > $user = "root"; > $password = "124816

Re: [PHP-DB] Does PHP5 support querying an MS Access MDE file?

2009-11-03 Thread Richard Quadling
houghts. > > Thanks for your help. > > Tim Legg > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > If you have the MS Access ODBC driver installed, then have you tried accessing the MDE as an MDB?

[PHP-DB] How exactly do I get UTF-8 data into SQL Server on Windows via ODBC SQL Native Client 10.0?

2009-10-07 Thread Richard Quadling
2009-10-07 08:46:22.730 which is what I want. I must be missing a trick as I'm sure it can't be that difficult. I'm not in a position to try PHP6 yet. Any suggestions would be gratefully received. Regards, Richard Quadling. CREATE TABLE [dbo].[Phones_Directory](

Re: [PHP-DB] scheduler

2009-09-23 Thread Richard Quadling
ust use ... C:\php\php.exe -f C:\path\to\script.php -- as the command. The -f is for completeness. If you want to pass parameters to your script, put them after the -- e.g. C:\php\php.exe -f C:\path\to\script.php -- --scriptparam1 --scriptparam2 The task scheduler is a windows service.

Re: [PHP-DB] scheduler

2009-09-23 Thread Richard Quadling
ine on windows. The command lines you use are the same for the task scheduler. -- - Richard Quadling "Standing on the shoulders of some very clever giants!" EE : http://www.experts-exchange.com/M_248814.html Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=21

Re: [PHP-DB] Re: Need help-Send email

2009-09-14 Thread Richard Quadling
ental level, this is how email is sent. You normally send it to a server you are allowed to send to (a relay). This normally requires some sort of security (not always - but may require you to POP3 login to your mailbox). You send the mail. The local server receives it. By using the domain of the recipie

Re: [PHP-DB] Image_Problem

2009-07-23 Thread Richard Quadling
at this code is doing is that, it creates a new image with the text (that > user enters) on it, but loads the image that was created previously, I want > that it should display the text on the picture which users enter on the fly. > ( e.g. If user enter TEXT as text it should display TEXT

Re: [PHP-DB] Cant get Mysql stored procedure to work.

2009-07-14 Thread Richard Quadling
>>>   $brandrequest = 'x'; >>>   $res = $db->multi_query( "CALL myproc($brandrequest, ModelID); "  ); >>>   if (!$res ) { >>>     echo 'No Listings were found for this request.'; >>>     echo mysql_error(); >>&

Re: [PHP-DB] Cant get Mysql stored procedure to work.

2009-07-14 Thread Richard Quadling
ho 'Error: could not connect to database. '; >      exit; >    } > >    $brandrequest = 'x'; >    $res = $db->multi_query( "CALL myproc($brandrequest, ModelID); "  ); >    if (!$res ) { >      echo 'No Listings were found for this request

[PHP-DB] Re: [PHP-WIN] Which ORM tool for Windows with Microsoft SQL Server 7/2000/2005.

2009-04-20 Thread Richard Quadling
ily take one of those native DB adapters and make them work with > the sql server for PHP driver. > Andi > >> -Original Message- >> From: David Sceppa [mailto:david.sce...@microsoft.com] >> Sent: Sunday, April 19, 2009 5:18 PM >> To: Richard Quadling >&g

[PHP-DB] Re: php-win-which-orm-tool-for-windows-with.html

2009-04-15 Thread Richard Quadling
com/SQL2K5PHP) would be nice. But >> this isn't PDO. >> >> Is there anyone capable of getting the Microsoft driver PDO aware? > > > I'm planning on wrapping the new 2005 driver with a PDO-interface. In case > you're interested, I'll post my pr

[PHP-DB] Which ORM tool for Windows with Microsoft SQL Server 7/2000/2005.

2009-04-14 Thread Richard Quadling
this isn't PDO. Is there anyone capable of getting the Microsoft driver PDO aware? Any help/suggestions would be appreciated. Regards, Richard Quadling. -- - Richard Quadling Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731 "Standing on the shoulder

[PHP-DB] Getting a date from MS SQL in the correct format.

2001-04-02 Thread Richard Quadling
find it. Any suggestions. In the mean time, I've had to use DATEPART to pull the three bits in separately and add a bit to the PHP templates to add them all together. Ideally I want just the value as CCYYMMDD. Regards, Richard Quadling. -- PHP Database Mailing List (http://www.php.net