On Sun, Apr 5, 2009 at 10:08 PM, MEM <talofo@xxxxxxxxx> 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
> $result = $mysqli->query("SELECT id_cliente, nome_cliente FROM cliente");
> echo "<select id='listacliente' name='listacliente'>";
>
> while($row = mysqli_fetch_assoc($result)) {
> echo "<option
> value=".$row['id_cliente'].">".$row['nome_cliente']."</option>";
> }
>
> echo "</select>";
> ?>
>
> 2)
> What I’m trying to achieve?
> The same thing, but using PDO, the prepare/execute methods, and FETCH_OBJ
> method to fetch data.
>
> 3)
> Here is what I have done so far:
> For simplifying I’m just trying to echo:
>
> $queryh=$conn->prepare('SELECT id_cliente, nome_cliente FROM cliente');
> $queryh->execute();
>
> /*trys to access the method fetchObject of the PDOStatement generated by
> the execute() PDO method, and save it on $row variable:*/
> $row=$queryh->fetchObject();
>
> /*now I'm trying to echo the results. The 'id_cliente' and 'nome_cliente'
> are the column names of my database and, if I get it right, the
> fectchObject() method should allow me to access those names as anonymous
> properties. So: */
> echo "Id: ".$row->id_cliente." - Nome: ".$row->nome_cliente."</ br>";
>
>
> 4)
> Here is the issue that I’m getting:
> I’m getting no values from the database upon echo request.
>
>
> 5)
> Question:
> What is wrong with this code? :(
>
There is something definitely wrong with your code. But 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.com/nine_L
