<?php

/**
 * @author Bettina Schwarzer
 * @copyright 2011
 *
 * TEST mit stmt-Klasse mysqli
 */

    include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
	$dbc = new dbconnection();
    
    echo "TEST mit stmt-Klasse mysqli<br />\n";
    
    $stmt = $dbc -> stmtinit(); // jetzt wird das $stmt-Objekt erstellt
    
    if (is_object($stmt))
    {
        $stmt -> prepare ("SELECT * FROM Vertrag WHERE contract_ID < ? ");
        $stmt -> bind_param('i',$id);
        $id=12;
        $stmt -> execute();
        $stmt -> store_result();
        $stmt -> bind_result($c_ID, $cname, $cs, $cl, $vtyp_ID, $cbegin, $cend, $cmon, $cfile, $cbem);
        
        if ($anz = $stmt -> num_rows)
        {
            echo "$anz Verträge gefunden<br />\n";
            echo "<table>\n";
            while ($stmt -> fetch())
            {
                echo "<tr><td>$c_ID</td>
                        <td>$cname</td>
                        <td>$cl</td>
                        <td>$vtyp_ID</td>
                        <td>$cbegin</td>
                        <td>$cend</td>
                        <td>$cmon</td>
                        <td>$cfile</td>
                        <td>$cbem</td></tr>\n";            
            }
            echo "</table>\n";
        }
    $stmt -> close();
    }

?>