[PHP] Newibie: fetch Obj question - data not showing.

Hello, 1) Ok, with mysqli, to fetch data from a database to a select drop down list, we would do something like this right? : query("SELECT id_cliente, nome_cliente FROM cliente"); echo ""; while($row = mysqli_fetch_assoc($result)) { echo "".$row['nome_cliente'].""; } echo ""

RE: [PHP] Newibie: fetch Obj question - data not showing.

>why did you forget to use the debugging functions : > >print_r() >and var_dump() for the results? > >So, you'll get some idea beforehand of posting the problem here. I am looking at the code in a hurry so I cant >help you much right away. > >Lenin > > www.twitter.c

RE: [PHP] Newibie: fetch Obj question - data not showing.

>On Behalf Of 9el > > >On Sun, Apr 5, 2009 at 10:08 PM, MEM < <mailto:tal...@gmail.com> tal...@gmail.com> wrote: >Hello, > >1) >Ok, with mysqli, to fetch data from a database to a select drop down list, we would do something like this >right? : >$

[PHP] Newbie: handling instance values on a attribute of the same class.

Hi all, Ok. Here is a code that I'm studying: class Connection extends PDO { private $dsn = 'mysql:dbname=testes;host=127.0.0.1'; private $user = 'root'; private $password = ''; public $handle = null; function __construct( ) { try { if ( $this

[PHP] PDO fetch_obj - question

Hi there, I’ve made a fetch_obj and, as stated on some sites, it returns a anonymous object where the properties will have the name of our columns database. However, when I do this, I notice that instead of giving me the column names as they are typed on the DB I get them uppercase. So, when

[PHP] RE: PDO fetch_obj - question

Hi there, I’ve made a fetch_obj and, as stated on some sites, it returns a anonymous object where the properties will have the name of our columns database. However, when I do this, I notice that instead of giving me the column names as they are typed on the DB I get them uppercase. So, whe

RE: [PHP] PDO fetch_obj - question

Thanks. I will see. The script for my database was been generated so, I will doublecheck this uppercase "issue"... Regards, Márcio 2009/4/15 Thodoris Hi there, I’ve made a fetch_obj and, as stated on some sites, it returns a anonymous object where the properties will have the name of our col

[PHP] niewbie - call methods from another class

Hello, I have something like this: $stmt = $this->_dbh->prepare("INSERT INTO DOG (name_dog, race_dog, id_vet) VALUES (?, ?, ?)"); $stmt->bindParam(1, $this->getNameDog() ); $stmt->bindParam(2, $this->getRaceDog()); $stmt->bindParam(3, ?

[PHP] Self-Process php forms or not?

I’m trying to understand the advantages behind opting by using a Self-Process PHP Form, instead of having a form and then point the action of the form to another .php page. Can anyone point me some resources about this. Why using one instead of another. What are the main advantages? Regard

RE: [PHP] Self-Process php forms or not?

So, on your opinion, we can call that method, on some circumstances, a good practice? What about the moto: "let's separate business from presentation?" Thanks once again, Márcio > -Original Message- > From: Sándor Tamás (HostWare Kft.) [mailto:sandorta...@hostware.hu] > Sent: sexta-fei

RE: [PHP] Self-Process php forms or not?

esentation. It is possible for a single > script > to use separate components for the presentation, business and data > access > layers. > > -- > Tony Marston > http://www.tonymarston.net > http://www.radicore.org > > ""MEM"" wrote in message &g

[PHP] Doubts concerning a general Insert method

Hello, I'm trying to understand a general CRUD class that I've seen here: http://www.phpro.org/classes/PDO-CRUD.html I'm learning PHP and I have some doubts on this method to generally insert data into DB. The class name is crud and here is the method: public function dbInsert($table, $values) {

RE: [PHP] Doubts concerning a general Insert method

> $values[0] will give you the first element of $values, namely > array('animal_name'=>'bruce', 'animal_type'=>'dingo'). > > array_keys will return an array containing the keys from the > passed array, so in this case you'll get array('animal_name', > 'animal_type'). > So... since $value

RE: [PHP] Doubts concerning a general Insert method

Nice. :-) Thanks a lot Stuart for your time and explanations. Now that I have understand, I will try to move on, and understand how can we introduce bindParams on it: For a recall, here is the original class: > public function dbInsert($table, $values) { > >$this->conn(); > >$fi

RE: [PHP] Doubts concerning a general Insert method

Ok... according to the above posts, I've started to create my generic CRUD class however, I'm wondering: Any of you have already used a DAO design pattern in conjunction with a CRUD generic class? Know that I'm trying to create a generic CRUD class on a DAO Design pattern, it seems that it mak

[PHP] Newbie: Composition by Association - Pagination Class general question.

Hello, I have a Animals DAO class that I'd like to apply a pagination class to it. Between this two classes, there will be a composition relation (more precisely, an association one). My question is: Is a Pagination that "has a" Animal. OR Is a Animal that "has a" pagination? Should we create on

RE: [PHP] Newbie: Composition by Association - Pagination Class general question.

> Pagination is the generically applicable class - it should know > nothing about what specifically it's paginating. Ok... but I need to grab values of my DAO classes, I mean, even if we paginate images on a directory or records on a database table, the pagination should have a $limit, and a off

RE: [PHP] Newbie: Composition by Association - Pagination Class general question.

> I don't know how your other classes are arranged, myPDO.class.php -> Singleton. Makes the connection to the database possible. generalDAO.class.php -> Abstract DAO Class, grabs the myPDO instance and could have other methods on the future that are shared for all the DAO classes. AnimalsDAO.c

RE: [PHP] Newbie: Composition by Association - Pagination Class general question.

> I would say your pagination logic belongs in myPDO.class.php. Where I > have this functionality it's as simple as two arguments to the method > that gets data, $page and $perpage. Setting both to false would > retrieve all rows. Interesting but, still no clue, on this side, about how to accomp

RE: [PHP] Newbie: Composition by Association - Pagination Class general question.

> I don't know much about PDO, but in raw MySQL SQL you'd have something > similar to this... > > function Select($table, $where, $page = false, $perpage = 20) > { > $sql = 'select * from '.$table.' where '.$where; > if ($page !== false) > { > $sql .= ' limit '.(($page-1)*$perpage).', '.

RE: [PHP] Re: Newbie: Composition by Association - Pagination Class general question.

> As for (1) even in my pre-OO days I was used to using a single generic > DAO > for all database access. The only time that more than one DAO existed > was > for a different DBMS engine. This is why I have one DAO class for MySQL, > one > for PostgreSQL and another for Oracle. If you are incapable

RE: [PHP] Re: Newbie: Composition by Association - Pagination Class general question.

> > As for (1) even in my pre-OO days I was used to using a single > generic > > DAO > > for all database access. The only time that more than one DAO existed > > was > > for a different DBMS engine. This is why I have one DAO class for > MySQL, > > one > > for PostgreSQL and another for Oracle. If

RE: [PHP] Re: Newbie: Composition by Association - Pagination Class general question.

> Why not? Why can't you replace a call to a mysqli function with a call > to a > PDO function? It's not just a simple replacement - I need to add bindparam, prepare, execute, placeholders and fetchObject. But I will give it a try... > > Also, I also intend to use fetchObject method instead of f

RE: [PHP] Re: Newbie: Composition by Association - Pagination Class general question.

> > > As for (1) even in my pre-OO days I was used to using a single > > > generic DAO for all database access. The only time that more > > > than one DAO existed was for a different DBMS engine. This > > > is why I have one DAO class for MySQL, one for PostgreSQL > > > and another for Oracle. If y

RE: [PHP] Re: Newbie: Composition by Association - Pagination Class general question.

Thanks a lot Tony. Unfortunately for me, I'm seeing myself in no conditions for properly learning a framework. I want to learn PHP and a framework bring so many concepts at once, that I found extremely complex and time consuming do dig in, at once, right now. Since I have no more than a few months

[PHP] stdClass - A newbie question

Hello everybody, In this class sketch: total_pages = $total_pages; $pagi_obj->offset = $offset; $pagi_obj->limit = $limit; $pagi_obj->page; return $pagi_obj; } } Why do the author used a stdClass ? What are the advantages of using

RE: [PHP] stdClass - A newbie question

> By the way, there are many reasons for creating objects inside of other > objects. This should not be considered an exception. I don't know where > this code belongs to, so I can't clear out if it is good or bad OOP > style. I do not intend to public judge the author, but the original article is

[PHP] Newbie: can't access a return value.

Hi all, When I do this: $associacao_dao->listar($limit, $offset); I can var_dump the correct $limit. I can var_dump the correct $offset. I CAN'T access the object that I was hoping to get, called $records. After this, I was hoping to do var_dump($records); and see the stdClass object. Here

[PHP] RE: Newbie: can't access a return value.

Solved. Forget to assigning the return value of the method to anything. :S Sorry. Márcio > -Original Message- > From: MEM [mailto:tal...@gmail.com] > Sent: sábado, 1 de Agosto de 2009 17:13 > To: 'php-general@lists.php.net' > Subject: Newbie: can't acce

RE: [PHP] Self-Process php forms or not?

again without redirecting again. > > And if you have to change the behavior of the page, you have to change > only > one file instead of two. > > SanTa > > - Original Message - > From: "MEM" > To: "'PHP-General List'" > Sen

RE: [PHP] Self-Process php forms or not?

7; > Subject: Re: [PHP] Self-Process php forms or not? > > On 10/1/09 10:13 AM, "tedd" wrote: > > > At 1:00 PM +0100 10/1/09, MEM wrote: > >> One last question about this: > >> > >> I've done a self submit form, after hearing all the advant

RE: [PHP] Self-Process php forms or not?

a multi-step form, the hidden field isn't necessary. It's this correct assumptions? Please advice, Regards, Márcio > -Original Message- > From: kranthi [mailto:kranthi...@gmail.com] > Sent: sexta-feira, 2 de Outubro de 2009 11:12 > To: a...@ashleysheridan.co.u

RE: [PHP] Self-Process php forms or not?

> You can set it up any number of ways. There is no > absolute need for a redirect. Everything can be > done in one form, or not -- your choice. > > Cheers, > > tedd Yes. But since I don't want to display a success information + form fields, but only the success information, I believe the only w

RE: [PHP] Self-Process php forms or not?

Thanks a lot. To all. For the moment, I'm with the redirect solution that others have pointed. But after seen tedd example and watch Manuel videos, I'm starting to understand how the hidden field solution work as well. Well... I'm *starting* to understand I've not fully understand it yet, despit

RE: [PHP] Self-Process php forms or not?

> i don't think so. if the user requests the page "a_form.php" then the > server > will normally execute the a_form.php script regardless whether the form > was > submitted or not. > > to display a blank form, the user probably requests a_form.php with the > GET > method and probably without any G

RE: [PHP] Self-Process php forms or not?

> i agree that it does seem a bit as though Márcio is in such a hurry to > make > something work that the tasks of learning and understanding the > fundamentals > are being left aside. while that's maybe understandable, it's a bit > frustrating when we're trying to explain the fundamentals. Thank

[PHP] ternary operator sintax help

Hello all, I'm trying to display a div, only when some php value is set. Since this will be near html, I'd like to keep it on one line. So, I'd love to use shortcuts and a ternary operator for the effect. I'm having something like this right now, but the div still appears even if the error is NOT

RE: [PHP] ternary operator sintax help

Thanks. I will give up on I mean, it will show the message only when the form gets submitted. At the beginning it will have ‘’. :s Regards, Marcio From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk] Sent: terça-feira, 6 de Outubro de 2009 19:49 To: MEM Cc: php-general

RE: [PHP] Re: ternary operator sintax help

r !empty. Thanks a lot, Márcio > -Original Message- > From: João Cândido de Souza Neto [mailto:j...@consultorweb.cnt.br] > Sent: terça-feira, 6 de Outubro de 2009 19:53 > To: php-general@lists.php.net > Subject: [PHP] Re: ternary operator sintax help > > class=

RE: [PHP] Re: ternary operator sintax help

Absolutely. ;) I was reporting to ashley teachings. :-) Philip, thanks for the tip. :-) Thank you all, Márcio > -Original Message- > From: Tom Worster [mailto:f...@thefsb.org] > Sent: terça-feira, 6 de Outubro de 2009 21:10 > To: MEM; php-general@lists.php.net > Subjec

[PHP] FILTER_VALIDATE_INT - newbie question

Hello all, I'm having this strange behavior, and I do not understanding why... When I use FILTER_VALIDATE_INT I'm unable to get, on my input box, values starting with 0(zero), or values that are greater (in length) then 10 digits. I was expecting to be able to input the all range of integers.

RE: [PHP] FILTER_VALIDATE_INT - newbie question

[sic] > Before your e-mail, I've considering the use of this: > if (!is_numeric($telefone)) > { > $erros['numberofsomething'] = 'Error - only numbers please.'; > } I meant this of course: if (!is_numeric($numberofsomething)) { $erros['numberofsomething'] = 'Error - only numbers please.';

RE: [PHP] FILTER_VALIDATE_INT - newbie question

> Well, it was only a guess, but if you look at the integer limit on 32-bit > systems, you'll see that the upper limit > for numbers is 2147483647 (or > 2^31-1) which would explain maybe your upper limit problem. > > Also, I think you're getting confused over the zero with exactly what you are >

RE: [PHP] FILTER_VALIDATE_INT - newbie question

> Well, at a guess, if a number is 0, PHP see's that as equivalent to a > false. In this case, shouldn't php ignore the 0 as false? > Also, numbers over 10 digits may be going over the limit for > your > PHP install, assuming PHP actually attempts to convert the string to a > real integer for

RE: [PHP] FILTER_VALIDATE_INT - newbie question

Thank you all for your replies. The issue was "solved" for a better fitting solution on this case, that was by using a regex expression. I've not tested the difference between using == or ===. I was using ! But, the main question that is not clear on my newbie head is, "why how why" couldn't th

[PHP] Newbie: Array of objects iteration

Hello all, I'm grabbing all records from a table using: $records = $stmt->fetchAll(PDO::FETCH_OBJ); return $records; In order to display the values we can do: foreach ($records as $record) { echo $record->id; echo $record->name; } Howev

RE: [PHP] Newbie: Array of objects iteration

@LinuxManMikeC and all @All Thanks. I was more or less aware of that possibility, however, please let me share the big picture will you guys: The main point is to access the properties name as well as values, of that object, and put them on a xls file. Instead of using mysql_num_rows, and mysql_n

RE: [PHP] Newbie: Array of objects iteration

>Correct about my example, although I'm not sure if you get each record as an array or as an object. Anyway, you can iterate both. > >And if you want to get the column names, I suppose you could use array_keys() on the first record if you receive an array, or maybe get_object_vars() if it's an >ob

RE: [PHP] Newbie: Array of objects iteration

> Right now, I have something like this: > > foreach ($objRecord as $record) > { > //we will have a new line. > $xls_file .="\n"; > > > foreach ($record as $column=>$value) > { > $xls_file .= $value."\t"; > } > > } > > The only thing I need now, is t

RE: [PHP] Newbie: Array of objects iteration

Dear all, it's done. Can I call your help for the remain issues please, I'm sure they are easy to explain, and at some extend, common: http://pastebin.com/m691d3e66 Instead of saving to the database, if I do a print_r or a var_dump, I get the charsets quite ok. However, they do not appear proper

RE: [PHP] Newbie: Array of objects iteration

Done. print utf8_decode($xls_file); Regards, Márcio > -Original Message- > From: MEM [mailto:tal...@gmail.com] > Sent: sexta-feira, 9 de Outubro de 2009 18:19 > To: 'MEM'; 'Fernando Castillo Aparicio'; 'Lester Caine'; 'php- > gene...

RE: [PHP] Newbie: Array of objects iteration

> > MEM, > > http://www.php.net/language.oop5.reflection > > > Regards, > Tommy > > And brand new world opens in from of my eyes... O.O. I will search more info on this on the net... just for the records, as properties names is concern, I couldn

[PHP] dynamic menu with show hide capabilities - understanding possible workflow

Hello all, I'm on my way to build my first dynamic menu using php. However, each time I say this, people start jumping at me crying out loud: "Jquery" . I don't need js for this. Really. (At least, this is what I believe). So I was wondering if It's possible to accomplish it, by using css and php

RE: [PHP] dynamic menu with show hide capabilities - understanding possible workflow

-feira, 26 de Outubro de 2009 14:38 To: MEM Cc: php-general@lists.php.net Subject: Re: [PHP] dynamic menu with show hide capabilities - understanding possible workflow On Mon, 2009-10-26 at 13:28 +, MEM wrote: Hello all, I'm on my way to build my first dynamic menu using php. Ho

RE: [PHP] dynamic menu with show hide capabilities - understanding possible workflow

Thanks a lot for your replies. Let's see if I understand, if not, please, let me know, I'm not that proficient in English. Second try, in order to accomplish this, I have to: 1) Generate the multidimensional array from query. 2) Generate the ul / li menu (echo + foreach) displaying all child

RE: [PHP] dynamic menu with show hide capabilities - understanding possible workflow

>I think the term drop-menu is bad in this case, as essentially what you are >saying is: > >1) user is presented with the basic navigation menu >2) user clicks an item and page navigates somewhere else >3) because of the item user clicked in 2) display some extra menu items > Exactly. >That's n

RE: [PHP] dynamic menu with show hide capabilities - understanding possible workflow

>That sounds about right yeah. You could also get a little bit clever and only >retrieve the rows from your db that >will go to make the array elements you'll >need. It doesn't make sense to retrieve a full product list each time >someone >visits the page, Ok. >so you only need to retrieve t

RE: [PHP] dynamic menu with show hide capabilities - understanding possible workflow

>Think of it a bit like an online shop selling operating systems: > >1) All the main OS's you sell are on the front page - Linux, MacOS & Windows >2) User clicks on Linux, and is taken to the url /products/linux and they are >shown all the Linux OS's on offer >(Fedora, SuSe, Ubuntu, Knoppix, etc)

[PHP] Help with my first recursion menu

Hello all, Please have a look here: http://www.nuvemk.com/c_categoria/seccao/1 When we click on "Fitofármacos", I can display the correspondent children! This is great! And I'm really happy! :) When we click on Fitofármacos children - "Herbicidas", I was expecting to have returned Herbicidas

[PHP] RE: Help with my first recursion menu

> -Original Message- > From: MEM [mailto:tal...@gmail.com] > Sent: quarta-feira, 28 de Outubro de 2009 15:55 > To: 'php-general@lists.php.net' > Subject: Help with my first recursion menu > > Hello all, > > Please have a look here: > ht

RE: [PHP] dynamic menu with show hide capabilities - understanding possible workflow

> -Original Message- > From: MEM [mailto:tal...@gmail.com] > Sent: terça-feira, 27 de Outubro de 2009 12:05 > To: 'a...@ashleysheridan.co.uk' > Cc: 'Jim Lucas'; 'php-general@lists.php.net' > Subject: RE: [PHP] dynamic menu with show hide

RE: [PHP] RE: Help with my first recursion menu

From: Lex Braun [mailto:lex.br...@gmail.com] Sent: sábado, 31 de Outubro de 2009 14:05 To: MEM Cc: php-general@lists.php.net Subject: Re: [PHP] RE: Help with my first recursion menu Hi, On Wed, Oct 28, 2009 at 5:22 PM, MEM wrote: I've been told that stack is the way to go, so I'm

RE: [PHP] RE: Help with my first recursion menu

From: Lex Braun [mailto:lex.br...@gmail.com] Sent: segunda-feira, 2 de Novembro de 2009 02:58 To: MEM Cc: php-general@lists.php.net Subject: Re: [PHP] RE: Help with my first recursion menu Hi, On Sat, Oct 31, 2009 at 11:07 AM, MEM wrote: From: Lex Braun [mailto:lex.br...@gmail.com] Sent

[PHP] headers help

Hello all, I must confess I know the very basics on this language and have even less knowledge about http headers. I wish you could help me out on this: I have a form that sends html e-mails and an optional file as attachment. The issue is that, if the file is NOT send, the e-mail receives two ti

[PHP] RE: headers help

> I've had a quick look and this: http://pastebin.com/RswEBPLd may work; > if not though you want to view the source of an email from anywhere > which displays correctly; and the source of one from your application - > then compare to get the fix :) > > Regards! Thanks Nathan, I will give it a t

[PHP] Migration Scheme - from one mysql DB to another mysql DB

Hello all, If possible, I would like to ask and have your help about the methods and procedures that should exist to accomplish the following task: I need to grab some data from one mySQL database with some specific table and field names, to another mySQL database with specific table and field nam

RE: [PHP] Migration Scheme - from one mysql DB to another mysql DB

> > I'd like to know > > - what type of hosting and OS the 2 databases are running. > - if they're (staying) on the same machine, and if not: whats the > available bandwith (up&down, low&peak) between the machines? any cost > to that bandwith? > - if you have admin rights on both databases. > - h

[PHP] simpleXML - can't add children - why? - stuck

Hello all, I'm struggling here, but no joy so far. Having this XML file that I'm loading using simplexml_load_file(): http://pastebin.com/JiW3LxWM I need to add some children nodes after line 8. What do I need to add? This: http://pastebin.com/mT27g3ZN In order to do so, I have used the follo