PHP categoryfunction::categoryselectlastdatafunction Examples

Example #1

File: category_function.php Project: eteks/wct

    public function categoryselectfunction()
    {
        $temp_arr = array();
        $res = mysql_query("SELECT * FROM wc_categories ORDER BY categories_id DESC") or die(mysql_error());
        $count = mysql_num_rows($res);
        while ($row = mysql_fetch_array($res)) {
            $temp_arr[] = $row;
        }
        return $temp_arr;
    }
}
if (isset($_POST['category_add'])) {
    $sport = new categoryfunction();
    $sport->categoryname = $_POST['category_name'];
    if ($sport->categoryinsertfunction()) {
        $last_data = $sport->categoryselectlastdatafunction();
        echo "<tr class='align_center delete_color'><td class='category_id'>" . $last_data['categories_id'] . "</td><td class='category_name'>" . $last_data['categories_name'] . "</td><td><span class='edit_state'>Edit</span><span class='delete_state'>Delete</span></td></tr>";
    } else {
        echo "error";
    }
}
if (isset($_POST['category_update'])) {
    $sport = new categoryfunction();
    $sport->categoryname = $_POST['category_name'];
    $sport->categoryid = $_POST['category_id'];
    if ($sport->categoryupdatefunction()) {
        echo $_POST['category_name'] . '-' . $_POST['category_id'];
    } else {
        echo "error";
    }
}