Login   Register  
PHP Classes
elePHPant
Icontem

File: example.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Tamas Hernadi  >  Datamodul  >  example.php  >  Download  
File: example.php
Role: Example script
Content type: text/plain
Description: mysql database countener class example
Class: Datamodul
MySQL database access wrapper
Author: By
Last change:
Date: 2006-08-09 16:01
Size: 2,376 bytes
 

Contents

Class file image Download
<?php

/*

    Class Datamodul (class.mysql_datamodul_php4.inc.php) usable function list:

    dm_info
    dm_select_result_info
    get_server
    set_selected_db
    get_selected_db
    get_user
    get_pass
    get_db_names
    get_db_table_names
    get_db_table_field_names
    get_db_table_field_name
    get_db_table_field_types
     get_db_table_field_nulls
     get_db_table_field_keys
     get_db_table_field_defaults
     get_db_table_field_extras
    get_db_count
    get_db_table_count
    get_db_table_field_counts
    get_db_table_field_count
    execute_sql
    set_sql_row_index
    get_sql_row_index
    get_sql_rows
    get_sql_table_names
    get_sql_field_names
    get_sql_table_count
    get_sql_field_count
    get_sql_row_count
    get_sql_row_first
    get_sql_row_next
    get_sql_row_back
    get_sql_row_last
    get_sql_field_index
    get_sql_affected_row_count
    get_sql_executed_count
    get_sql_string


*  details in the class.mysql_datamodul_php4.inc.php source file *
*/

//class datamodul simple example
//our test database contents the test_table and the test_table2 ( with 2-2 rows), which have 3 fields as field1, field2, field3 ( with the values 1,2,3)

require_once('class.mysql_datamodul_php4.inc.php');

$dm=new DataModul("your_server","your_user","your_password","db_test");
$dm->dm_info();

echo 
'<br><br>example1:<br><br>';
$dm->execute_sql("SELECT * FROM test_table");
$dm->dm_select_result_info();

echo 
'-------------------<br>example2:<br><br>';
$dm->execute_sql("SELECT field1,field2 as second_field FROM test_table");

$row=$dm->get_sql_row_first();
   do
    {
        echo 
'<b>Row number:</b> ',$dm->get_sql_row_index(),'<br> Field2 value: ',$row[$dm->get_sql_field_index('second_field')],' <br> Field1 value: ',$row[$dm->get_sql_field_index('field1')],'<br>';
    }
   while (
$row=$dm->get_sql_row_next());

echo 
'-------------------<br>example3:<br><br>';
$dm2=new NewDataModul($dm);
$dm2->execute_sql('SELECT * FROM test_table2');

$row=$dm2->get_sql_row_last();
echo 
'<b>Row number:</b> ',$dm2->get_sql_row_index(),'<br> Field2 value: '$row[1], '<br>';
$row=$dm2->get_sql_row_back();
echo 
'<b>Row number:</b> ',$dm2->get_sql_row_index(),'<br> Field3 value: ',$row[$dm2->get_sql_field_index('field3')],'<br>';

//I hope it will be usefull :)
?>