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

2012-05-05 Thread Matijn Woudt
On Thu, May 3, 2012 at 4:20 PM, Ethan Rosenberg wrote: > 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 y

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

2012-05-04 Thread Marco Behnke
Am 04.05.2012 16:09, schrieb Ethan Rosenberg: function handle_data() { global $cxn; What does this function? It neither takes any parameters nor returns any value. And it does not write back anything to its global $cxn. So it is quite useless and can be deleted. $query = "select * from I

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

2012-05-04 Thread Govinda
Ethan, before you get frustrated or feel abandoned, let me *sincerely* try to help: Here is honestly what I am utterly convinced you need to do to get any where in the medium/long run: Break everything down into very small steps. Making web apps is just building a whole lot of layers/colle

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

2012-05-04 Thread Jim Giner
Nor will posting to multiple lists.(Sorry to the rest of you - didn't realize it until now.) ""Jim Giner"" wrote in message news:c6.f8.38082.efae3...@pb1.pair.com... >I don't think posting the same voluminous code is going to generate any >better responses. > > The suggestion to start over and

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

2012-05-04 Thread Jim Giner
I don't think posting the same voluminous code is going to generate any better responses. The suggestion to start over and make your insert/retrieve queries fool proof before starting to write some logic into your code was a very good one. Why don't you work on that so that any requests for he

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

2012-05-03 Thread Ethan Rosenberg
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're doing. It might

Re: [PHP] PHP & Database Problems

2012-05-02 Thread Jim Lucas
On 5/2/2012 4:28 PM, Duken Marga wrote: But I don't see any attachments in this message. This was in the first email of this thread. I can easily extract data from the database. However, if I try to enter data, it goes into the incorrect record. Following are some screenshots. The program i

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

2012-05-02 Thread Duken Marga
It is a good habbit to write the core code just for inserting/retrieving data from database. It will reduce much of your code complexity. When you see your code is working, you can continue to embed it with your visual front-end or with your filter. On Thu, May 3, 2012 at 4:43 AM, Ethan Rosenberg

Re: [PHP] PHP & Database Problems

2012-05-02 Thread Duken Marga
But I don't see any attachments in this message. On Thu, May 3, 2012 at 2:28 AM, Jim Lucas wrote: > I do believe attachments are allowed. Looking back, I see that there have > been messages sent to the list that had odt, php, and ini attachments > > > On 05/02/2012 12:12 PM, Gavin Chalkley wrot

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

2012-05-02 Thread Matijn Woudt
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're doing. It might help if you understand what the code is doing...

Re: [PHP] PHP & Database Problems

2012-05-02 Thread Terry Ally (Gmail)
Dear Ethan, It would be useful to see what code you are using. The syntax is: UPDATE table_name SET column1=value, column2=value2,... WHERE some_column=some_value The data that you are required to enter is for Intake3. I am assuming that the only change is the History and/or Phone that you nee

Re: [PHP] PHP & Database Problems

2012-05-02 Thread Jim Lucas
I do believe attachments are allowed. Looking back, I see that there have been messages sent to the list that had odt, php, and ini attachments On 05/02/2012 12:12 PM, Gavin Chalkley wrote: Ethan, Some coding you are using would be helpful (as far as i am aware attachments are not support on

Re: [PHP] PHP database interface layer

2010-07-22 Thread Marc Guay
> Let me repeat myself: did you have a look at Doctrine2? Hi Peter, I didn't mean to ignore your suggestion, I just got extremely overwealmed by the Doctrine website and didn't even have a response. I get the impression that, like Zend and others, learning how to install and use that would take l

Re: [PHP] PHP database interface layer

2010-07-22 Thread Peter Lind
On 22 July 2010 21:14, Marc Guay wrote: >> i recommend propel >> http://www.propelorm.org/ > > Holy Moses that thing is a monster.  It requires installing extra > libraries (Phing) in order to create an XML schema reverse-engineered > from my existing database.  The code looks simple enough but th

Re: [PHP] PHP database interface layer

2010-07-22 Thread Nathan Nobbe
On Thu, Jul 22, 2010 at 1:14 PM, Marc Guay wrote: > > i recommend propel > > http://www.propelorm.org/ > > Holy Moses that thing is a monster. It requires installing extra > libraries (Phing) in order to create an XML schema reverse-engineered > from my existing database. The code looks simple

Re: [PHP] PHP database interface layer

2010-07-22 Thread Floyd Resler
On Jul 22, 2010, at 3:14 PM, Marc Guay wrote: >> i recommend propel >> http://www.propelorm.org/ > > Holy Moses that thing is a monster. It requires installing extra > libraries (Phing) in order to create an XML schema reverse-engineered > from my existing database. The code looks simple enoug

Re: [PHP] PHP database interface layer

2010-07-22 Thread Marc Guay
> i recommend propel > http://www.propelorm.org/ Holy Moses that thing is a monster. It requires installing extra libraries (Phing) in order to create an XML schema reverse-engineered from my existing database. The code looks simple enough but that installation is brutal. Any other suggestions?

Re: [PHP] PHP database interface layer

2010-07-22 Thread Marc Guay
> i recommend propel > http://www.propelorm.org/ This looks hopeful. I'd checked it out before but for some reason lumped it in with all of the other half-baked tools that didn't do what I wanted, but even that basic example seems to cover most of what I want. Thanks for the suggestions. Marc

Re: [PHP] PHP database interface layer

2010-07-22 Thread Nathan Nobbe
On Thu, Jul 22, 2010 at 7:35 AM, Marc Guay wrote: > Hi everyone, > > I've built a fairly large normalized database schema for a project. > This is fun for me as I like thinking about how everything is > interconnected. Foreign keys are all set up, many-to-many tables are > go, etc, and so on.

Re: [PHP] PHP database interface layer

2010-07-22 Thread Peter Lind
On 22 July 2010 15:35, Marc Guay wrote: > Hi everyone, > > I've built a fairly large normalized database schema for a project. > This is fun for me as I like thinking about how everything is > interconnected.  Foreign keys are all set up, many-to-many tables are > go, etc, and so on.   But now it'

Re: [PHP] PHP Database

2002-11-15 Thread Marek Kilimajer
You need to understand the relations between the entities in order to design the database, there are 3 types: 1 to 1: - one team has one couch, no team has more couches and no couch has more teams. - usually in one table (team_name, couch_name), but might be also in two interconnected w

Re: [PHP] PHP Database

2002-11-15 Thread Jason Wong
On Friday 15 November 2002 14:00, Steven Priddy wrote: > I am looking into how I can make a database like this one that is MySql > controlled. With a lot of hard work I would say. > http://www.uhlfans.com/uhlstats/ That is one of my partners > sites but the guy that created the database can't or

Re: [PHP] Php Database

2001-02-03 Thread Richard Lynch
> Hi everyone! > To use de DBA database format, first i had to configurate php with > --with-db2 option. All works (configure, make and make install). But the > php script still not works. The line of the script that has a problem > is: > > $id = dba_open ("/home/httpd/html/testes/test.db", "n", "

Re: [PHP] Php database

2001-01-31 Thread Michael Hall
Bom dia Vinicius: Yo nao falo o portugues muito bem ... sabes espanol? Si no puedes usar un database SQL, porque no pruebas un database DBA que es un database 'flat file' mas o menos como un '.txt file' ... entonces podrias tratar del data con los funciones DBA de PHP que seguramente son mas fa