Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: neveikia DELETE ir UPDATE

Parašė nerkiuz· 2012 Spa. 11 14:10:25
#1

Taigi, persidarinejau viena moda ir su INSERT i mysql viskas veikia gerai, bet jei noriu UPDATE'inti ar DELETE'inti niekas nesikeicia ir neissitrina. Gal kas galite pagelbeti, nes niekaip nerandu kur kas blogai.

Dalis kodo:


if (isset($_GET['status']) && !isset($message)) {
	if ($_GET['status'] == "sn") {
		$message = $locale['zaid_010'];
	} elseif ($_GET['status'] == "su") {
		$message = $locale['zaid_011'];
	} elseif ($_GET['status'] == "deln") {
		$message = $locale['zaid_012']."<br />\n<span class='small'>".$locale['zaid_015']."</span>";
	} elseif ($_GET['status'] == "dely") {
		$message = $locale['zaid_013'];
	}
	if ($message) {	echo "<div class='admin-message'>".$message."</div>\n"; }
}
opentable ($locale['zaid_014']);
require_once INFUSIONS."atp_zaidejai/inc/panel_tab.php";
closetable();
if ((isset($_GET['action']) && $_GET['action'] == "delete") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {
	$result = dbquery("SELECT * FROM ".DB_ATP_ZAID." WHERE zaid_id='".$_GET['zaid_id']."'");
	if (dbrows($result) != 0) {
		redirect(FUSION_SELF.$aidlink."&status=deln");
	} else {
		$result = dbquery("DELETE FROM ".DB_ATP_ZAID." WHERE zaid_id='".$_GET['zaid_id']."'");
		redirect(FUSION_SELF.$aidlink."&status=dely");
	}
} else {
	if (isset($_POST['save_cat'])) {
		$pav_var = stripinput($_POST['pav_var']);
		$reit = stripinput($_POST['reit']);
        $amzius = stripinput($_POST['amzius']);
		$gim_vieta = stripinput($_POST['gim_vieta']);
        $gyv_vieta = stripinput($_POST['gyv_vieta']);
        $ugis = stripinput($_POST['ugis']);
        $svoris = stripinput($_POST['svoris']);
        $ranka = stripinput($_POST['ranka']);
        $sporte_nuo = stripinput($_POST['sporte_nuo']);
        $treneris = stripinput($_POST['treneris']);
		$info = addslash($_POST['info']);
		$laimejimai = addslash($_POST['laimejimai']);
		if ($pav_var) {
			if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {
				$result = dbquery("UPDATE ".DB_ATP_ZAID." SET (zaid_pav_var, zaid_reit, zaid_amzius, zaid_gim_vieta, zaid_gyv_vieta, zaid_ugis, zaid_svoris, zaid_ranka, zaid_sporte_nuo, zaid_treneris, zaid_info, zaid_laimejimai) VALUES('$pav_var', '$reit', '$amzius', '$gim_vieta', '$gyv_vieta', '$ugis', '$svoris', '$ranka', '$sporte_nuo', '$treneris', '$info', '$laimejimai') WHERE zaid_id='".$_GET['zaid_id']."'");
				redirect(FUSION_SELF.$aidlink."&status=su");
			} else {
				$result = dbquery("INSERT INTO ".DB_ATP_ZAID." (zaid_pav_var, zaid_reit, zaid_amzius, zaid_gim_vieta, zaid_gyv_vieta, zaid_ugis, zaid_svoris, zaid_ranka, zaid_sporte_nuo, zaid_treneris, zaid_info, zaid_laimejimai) VALUES('$pav_var', '$reit', '$amzius', '$gim_vieta', '$gyv_vieta', '$ugis', '$svoris', '$ranka', '$sporte_nuo', '$treneris', '$info', '$laimejimai')");
				redirect(FUSION_SELF.$aidlink."&status=sn");
			}
		} else {
			redirect(FUSION_SELF.$aidlink);
		}
	}
	if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {
		$result = dbquery("SELECT * FROM ".DB_ATP_ZAID." WHERE zaid_id='".$_GET['zaid_id']."'");
		if (dbrows($result)) {
			$data = dbarray($result);
			$pav_var = $data['zaid_pav_var'];
			$reit = $data['zaid_reit'];
            $amzius = $data['zaid_amzius'];
			$gim_vieta = $data['zaid_gim_vieta'];
            $gyv_vieta = $data['zaid_gyv_vieta'];
            $ugis = $data['zaid_ugis'];
            $svoris = $data['zaid_svoris'];
            $ranka = $data['zaid_ranka'];
            $sporte_nuo = $data['zaid_sporte_nuo'];
            $treneris = $data['zaid_treneris'];
			$info = $data['zaid_info'];
			$laimejimai = $data['zaid_laimejimai'];
 
			$formaction = FUSION_SELF.$aidlink."&amp;action=edit&amp;zaid_id=".$data['zaid_id'];
			opentable($locale['zaid_016']);
		} else {
			redirect(FUSION_SELF.$aidlink);
		}
	} else {
		$pav_var = "";
		$reit = "";
		$amzius = "";
		$gim_vieta = "";
        $gyv_vieta = "";
        $ugis = "";
        $svoris = "";
        $ranka = ""; 
        $sporte_nuo = "";
        $treneris = "";
		$info = "";
		$laimejimai = "";
		$formaction = FUSION_SELF.$aidlink;
		opentable($locale['zaid_009']);
	}


Dekui visiems, kas gales pagelbeti!