Re: [PHP-DB] Books

2010-10-19 Thread Richard Quadling 
On 18 October 2010 15:06, Ethan Rosenberg eth...@earthlink.net wrote:
 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 your recommend to learn HTML/CSS, MySQL and PHP?  The books
 should start from the basic level and proceed to the intermediate/advanced
 level.

 Thanks.

 Ethan

Learning HTML/CSS, MySQL and PHP ...

On my desk I have php|Architect's Guide to PHP Design Patterns,
php|Architect's Zend PHP 5 Certification Guide, Microsoft's Code
Complete, The Gang of 4 and Jan Goyvaerts Regular Expression Cookbook.

For my HTML and CSS, I use online references and validators - most 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.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] Database and Table creation

2010-10-19 Thread Ethan Rosenberg 

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.net/unsub.php

Re: [PHP-DB] Database and Table creation

2010-10-19 Thread kesavan trichy rengarajan 
Hi Ethan,

Database Creation: http://www.php.net/manual/en/function.mysql-create-db.php
 http://www.php.net/manual/en/function.mysql-create-db.phpAdding Tables,
Extract Data: http://www.freewebmasterhelp.com/tutorials/phpmysql/1

http://www.freewebmasterhelp.com/tutorials/phpmysql/1Explore the function
list on the left from the first link if you are curious.

Kesavan.

On Wed, Oct 20, 2010 at 9:23 AM, Ethan Rosenberg eth...@earthlink.netwrote:

 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.net/unsub.php

[PHP-DB] RE: php-db Digest 19 Oct 2010 22:24:15 -0000 Issue 4629

2010-10-19 Thread Jimmy Sole 
Hello everyone,

I'm having trouble executing a insert select query in PHP

Here is the code:

$exec = self::init()-prepare(INSERT INTO owners (f_name, l_name, username,
password, email, company, str_address,
   city, state,
zip, phone, website, desc, categories)
   SELECT f_name, l_name, username,
password, email, company, street_address,
  city, state, zip,
phone_number, website, description, categories FROM pending
   WHERE pid  '0');

   
if ($exec-execute() !== false) {
return true;
} else {
throw new Exception(Error processing the query.);
}

Any help would be appreciated, as PDO is not returning an error or anything.

Thanks!

Jimmy

-Original Message-
From: php-db-digest-h...@lists.php.net
[mailto:php-db-digest-h...@lists.php.net] 
Sent: Tuesday, October 19, 2010 6:24 PM
To: php-db@lists.php.net
Subject: php-db Digest 19 Oct 2010 22:24:15 - Issue 4629


php-db Digest 19 Oct 2010 22:24:15 - Issue 4629

Topics (messages 47397 through 47397):

Database and Table creation
47397 by: Ethan Rosenberg

Administrivia:

To subscribe to the digest, e-mail:
php-db-digest-subscr...@lists.php.net

To unsubscribe from the digest, e-mail:
php-db-digest-unsubscr...@lists.php.net

To post to the list, e-mail:
php-db@lists.php.net


--


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] RE: php-db Digest 19 Oct 2010 22:24:15 -0000 Issue 4629

2010-10-19 Thread Chris 

On 20/10/10 09:55, Jimmy Sole wrote:

Hello everyone,

I'm having trouble executing a insert select query in PHP

Here is the code:

$exec = self::init()-prepare(INSERT INTO owners (f_name, l_name, username,
password, email, company, str_address,
city, state,
zip, phone, website, desc, categories)
SELECT f_name, l_name, username,
password, email, company, street_address,
   city, state, zip,
phone_number, website, description, categories FROM pending
WHERE pid  '0');


 if ($exec-execute() !== false) {
 return true;
 } else {
 throw new Exception(Error processing the query.);
 }

Any help would be appreciated, as PDO is not returning an error or anything.


Doesn't look like it should - it looks like a valid query.

Check your database logs or even run the query inside a transaction (and 
rollback) to see if it errors.


--
Postgresql  php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php