DBI/PERL Tutorial over the Web

Click to go to the PREVIOUS page. Click to go to the INDEX page. Click to go to the NEXT page.

SLIDE #6 SELECT RECORD FROM TABLE 


In this sixth slide, we select a record from the table.

1. THE SELECT FROM TABLE STATEMENT:

#select from table
        $statement="select * from studios";
        $sth=$dbh->prepare($statement);
        $rv=$sth->execute;
        print $statement."<br>";

2. FORM DESCRIPTION:

The first line defines the SQL statement.

The second line creates a statement object, calling the prepare method on the 
database object, and using the statement as parameter.

The third line calls the execute method on the  statement object

The fourth line displays the statement.


© Copyright 2002 International Customized Software Co.