[PHP] PHP & MS Sequel Server

http://www.aspfree.com/c/a/MS-SQL-Server/Using-PHP-with-MS-SQL-Server/ This article seems to sate that PHP can interface with MS Sequel Server ? If so, is it about the same level of complexity as working with PHP & MySQL? If one was to choose php & one DB over the other in a general comparison

Re: [PHP] Creating an Entire .html page with PHP

On 1/26/2010 6:08 PM, clanc...@cybec.com.au wrote: In principle this is extremely simple. Take your existing procedure to generate the page then: 1. $page = ''; 2. Replace every echo 'whatever'; statement with $page .= 'whatever';, and every with $page .= ''; 3. file_put_contents($page,$fil

[PHP] Setting up a 2 Column Display for SQL Recordset

-100 records) is on the left column and part 2 (101 - 200 records) is on the right column. Q: I'm not quite sure how to split / display the records ... Is there some kind of internal sql rec number that I can monitor? What is the best way to set this up? -- Thanks, Dave - DealTek

[PHP] Updating Multiple rows in mysql w php at once (newbie)

Hi all, another newbie question I have a recordset from mysql - a list of 20 or so products... 1 - I would like create an edit form to loop through the records and edit a text field called 'favorite' for each of the records - (this, I have done)... 2 - then I would like to submit the for

[PHP] Noobie starting to learn OOP for databases needs help

ot;SELECT SUM(price) FROM mytable" ... what I tried seemed to fail... And if anyone can point to some good OOP training URL's I'd appreciate it. Thanks in advance for any assistance... -- Thanks, Dave - DealTek deal...@gmail.com [db-12] -- PHP General Mailing List (http://w

Re: [PHP] Noobie starting to learn OOP for databases needs help

On Dec 16, 2012, at 10:08 AM, Sebastian Krebs wrote: > 2012/12/16 dealTek > >> Hi all, >> >> Noobie starting to learn oop for databases from here: >> >> >> https://github.com/JeffreyWay/PHP-MySQL-Database-Class/blob/master/MysqlDb.php >>

[PHP] newbie with imap_mail_move

Dave - DealTek deal...@gmail.com [db-3] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Newbie is trying to set up OOP With PHP and MySQL or MySQLi database class (using CRUD)

e.net/forums/topic/223360-connect-to-your-database-using-oop-php5-with-mysql-and-mysqli/ http://snipplr.com/view/8417/ http://snipplr.com/view/12535/ any assistance is appreciated! -- Thanks, Dave - DealTek deal...@gmail.com [db-3] -- PHP General Mailing List (http://www.php.net/) To unsubscribe,

[PHP] Re: Newbie is trying to set up OOP With PHP and MySQL or MySQLi database class (using CRUD)

On Feb 14, 2013, at 9:49 AM, dealTek wrote: > Hi everybody, > > Newbie is trying to set up OOP With PHP and MySQL or MySQLi database class > (using CRUD) > > Simple story: creating this class database by myself is way over my head. So > it be best for me to find some

Re: [PHP] Newbie is trying to set up OOP With PHP and MySQL or MySQLi database class (using CRUD)

gt; > Bastien Thanks Bastien, I imagine this is what you were referring to? http://www.dreamincode.net/forums/topic/54239-introduction-to-mysqli-and-prepared-statements/ -- Thanks, Dave - DealTek deal...@gmail.com [db-3]

[PHP] Re: Newbie is trying to set up OOP With PHP and MySQL or MySQLi database class (using CRUD)

>sql, __METHOD__); } /** * * @Function : exec; * @Param $ : $sql, $method; * @Return Int ; */ public function exec($sql, $method = '') { try { $this->sql = $sql . $this->tail; $efnum = parent::exec($this->sql); } catch(PDOException $e) { echo 'PDO ' . $method . ' Error: ' . $e->getMessage(); } return intval($efnum); } /** * * @Function : setLimit; * @Param $ : $start, $length; * @Return ; */ public function set_limit($start = 0, $length = 20) { $this->tail = ' limit ' . $start . ', ' . $length; } } ?> -- Thanks, Dave - DealTek deal...@gmail.com [db-3] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Newbie Question - Parse XML with PHP...

#2 SKU-123456 test product description abc 1 5. 1. 7.00 2.00 1.00 2.00 1.00 sales 12345 SKU-123456 test 2 product description abc 2 2.5000 2. 7.00 2.00 1.00 2.00 1.00 sales 12345 -- Thanks, Dave - DealTek deal...@gmail.com [db-3]

Re: [PHP] Newbie Question - Parse XML with PHP...

assign the php to the XML somehow... I hope I am making myself clear Thanks in advance for the help > Or you use a specialized library like Guzzle. > > Am 19.04.2013 22:17 schrieb "dealTek" : > Hi all, > > newbie - just starting with trying to parse XML... >

Re: [PHP] Newbie Question - Parse XML with PHP...

$ch = curl_init(); // Initialize curl handle curl_setopt($ch, CURLOPT_URL, $gatewayURL); // Set POST URL $headers = array(); $headers[] = "Content-type: text/xml"; curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); // Add http headers to let it know we're sending XML $xmlString = $xmlRequest->saveXML(); curl_setopt($ch, CURLOPT_FAILONERROR, 1); // Fail on errors curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1); // Allow redirects curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); // Return into a variable curl_setopt($ch, CURLOPT_PORT, 443); // Set the port number curl_setopt($ch, CURLOPT_TIMEOUT, 15); // Times out after 15s curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $xmlString); // Add XML directly in POST curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2); // This should be unset in production use. With it on, it forces the ssl cert to be valid // before sending info. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); if (!($data = curl_exec($ch))) { print "curl error =>" .curl_error($ch) ."\n"; throw New Exception(" CURL ERROR :" . curl_error($ch)); } curl_close($ch); return $data; } // Helper function to make building xml dom easier function appendXmlNode($parentNode,$name, $value) { $tempNode = new DOMElement($name,$value); $parentNode->appendChild($tempNode); } ?> -- Thanks, Dave - DealTek deal...@gmail.com [db-3]

[PHP] looking for a PDF generator class/library for PHP 5?

pdf was able to split it up without losing part of the font when crossing page boundaries etc... -- Thanks, Dave - DealTek deal...@gmail.com [db-3] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Moving from mysql functions to mysqli or PDO - which is best?

inions! -- Thanks, Dave - DealTek deal...@gmail.com [db-3] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] looking for a PDF generator class/library for PHP 5?

Thanks Jose and Ali - I will look into them. -- Thanks, Dave - DealTek deal...@gmail.com [db-3]

Re: [PHP] Moving from mysql functions to mysqli or PDO - which is best?

ecommendations of both MySQLi or PDO classes from this good group would be a better starting point. Thanks in advance! -- Thanks, Dave - DealTek deal...@gmail.com [db-3]

[PHP] Can javascript or php help with this

ons so it's best to set this up prior to submitting the form. -- Thanks, Dave - DealTek deal...@gmail.com [db-3] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Re: Can javascript or php help with this

avoid the values being arithmetically > added instead of concatenated, but this is one way. > > And of course - you could try posting on a js site instead of a php one. > Thanks so much Jim - I will check into this (and I did just join a javascript list) -- Thanks, Dave - DealTek deal...@gmail.com [db-3]

Re: [PHP] Can javascript or php help with this

On May 26, 2013, at 5:48 AM, Jim Giner wrote: > On 5/25/2013 9:11 PM, dealTek wrote: >> >> On May 25, 2013, at 4:30 PM, Jim Giner wrote: >>>> >>>> >>> So - create another field on your form. Add an onclick event to your >>> sub

[PHP] Looking for a good working PDO and/or mysqli database class to get started with OOP

u-doing-it-correctly/ http://www.phpclasses.org/package/7533-PHP-Access-SQL-databases-using-PDO.html http://www.doctrine-project.org/projects/dbal.html http://pear.php.net/package/MDB2 -- Thanks, Dave - DealTek deal...@gmail.com [db-3]

Re: [PHP] Looking for a good working PDO and/or mysqli database class to get started with OOP

MDB2 -- Thanks, Dave - DealTek deal...@gmail.com [db-3]

[PHP] Using Table prefixes

ago to use a prefix "tbl_" like tbl_Mytable but I don't really see much need for this by itself ... Am I missing something? -- Thanks, Dave - DealTek deal...@gmail.com [db-3]

[PHP] Detect and Redirect Mobile Users

need right now. Thanks in advance - Dave -- Thanks, Dave - DealTek deal...@gmail.com [db-3] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] newbie PDO query display question

these fail - so what will work echo $results["First"]; echo $results["First"][0]; ??? echo $results["First"][1]; ??? -- Thanks, Dave r...@musenet.com [db-3] -- Thanks, Dave - DealTek deal...@gmail.com [db-3]

Re: [PHP] newbie PDO query display question

hat will work? echo $results["First"]; echo $results["First"][0]; ??? echo $results["First"][1]; ??? > While works better than foreach for getting the result rows from PDO -- Thanks, Dave - DealTek deal...@gmail.com [db-3]

Re: [PHP] newbie PDO query display question

> > And you could also do > > list( $result["id"], $result["name"]) = $stmt->fetch(PDO::FETCH_NUM)); > > > -- > Stephen > Thanks very much for your help Stephen - I will try this asap! -- Thanks, Dave - DealTek deal...@gmail.com [db-3]

[PHP] Making a Timeout Expiration Length to Session Variables

-- Thanks, Dave - DealTek deal...@gmail.com [db-3]

[PHP] query order issue

quot;refresh" does work but the error flashes 1st for a second... Q: I would have thought that it would not go past the line - meta http-equiv="refresh" - but it does any insight on this -- Thanks, Dave - DealTek deal...@gmail.com [db-3]

[PHP] Session Vars not staying active

anks in advance. -- Thanks, Dave - DealTek deal...@gmail.com [db-3]

[PHP] Session_unset - session_destroy issue

SESSIONS? test1 '. $_SESSION['var1'].' '; session_unset(); session_destroy(); $_SESSION = array(); $_SESSION['var1'] = 'test2'; echo ' test2 ' . $_SESSION['var1']; ?> -- Thanks, Dave - DealTek deal...@gmail.com [db-3]

[PHP] Sending PHP mail with Authentication

/PHP_Email_SMTP_Authentication.htm -- Thanks, Dave - DealTek deal...@gmail.com [db-3] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Newbie security database connection question

e secure way to communicate from the website to the MySQL data source that is somehow sending encrypted information rather than clear text back and forth? Thanks in advance for your help. -- Thanks, Dave - DealTek deal...@gmail.com [db-11] -- PHP General Mailing List (http://www.php.net/)

[PHP] Geo IP Location help needed...

cause that particular IP is NOT seen by Geo IP Location? We just installed the latest version (I think) yesterday Is it reading from some old outdated database - or Q: Is there some code that can ALWAYS tell the country name of the IP? -- Thanks, Dave - DealTek deal...@gmail.com [db-11]

Re: [PHP] Geo IP Location help needed...

On Oct 24, 2011, at 6:23 PM, Bastien wrote: > > On 2011-10-24, at 9:07 PM, DealTek wrote: > > > Dave, > > If the IP is showing, could there be some left over debug in some function? > > If the IP is not in your list it could be anything from a new range for a

Re: [PHP] Working on a Subsummary Report

4 etc summary heading2 CAT 2 sub head 3--- Prod 3 --- sales prod data 5 --- sales prod data 6 etc any other hints will help a lot... -- Thanks, Dave - DealTek deal...@gmail.com [db-11] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Working on a Subsummary Report

but the table 2 only shows 1 record Q: ... like the query number row number? needs to be reset - but how? - like ... like 2x ...         > > > -- -- Thanks, Dave - DealTek deal...@gmail

Re: [PHP] Working on a Subsummary Report

s happen 1st of every month) then product (only 2 products needed for this) 4 - html for now 5 - for now just display and printing like: JAN 2011 --- PRODUCT 1 data row 1 data row 2 --- PRODUCT 2 data row 3 data row 4 like that... - thanks for checking this out.... -- Thanks, Dave - DealTek deal...@gmail.com [db-11]

Re: [PHP] Working on a Subsummary Report

ys... more beginner questions... - as stated - when I try to loop through 2x ... - the table 2 only shows 1 record.. - Q: ... like the query number row number? needs to be reset - but how? So is it not possible to loop more than 1x? Is that why we are loading into array? -- Thanks, Dave - DealT