Ermittelung der idcat in einem Modul
Verfasst: Do 15. Jan 2004, 15:18
Hallo, ist es möglich die idcat in einem Modul zu ermitteln?
Das Diskussionsforum zum Open Source Content Management System
https://forum.contenido.org/
Code: Alles auswählen
echo "<pre>";
var_dump($GLOBALS);
echo "</pre>";
Code: Alles auswählen
$hostname_Axel = "localhost";
$database_Axel = "DB60085";
$username_Axel = "name";
$password_Axel = "passwort";
$Axel = mysql_pconnect($hostname_Axel, $username_Axel, $password_Axel) or die(mysql_error());
mysql_select_db($database_Axel, $Axel);
$query_tour = "SELECT * FROM daten, dates, preise, touren, veran";
$tour = mysql_query($query_tour, $Axel) or die(mysql_error());
$row_tour = mysql_fetch_assoc($tour);
$totalRows_tour = mysql_num_rows($tour);
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}
if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "tour")) {
$insertSQL = sprintf("INSERT INTO daten (buch, EZT, GRT, Verpfleg, laenge, leist, bh_ap, erm, fahr, sonst) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($HTTP_POST_VARS['buch'], "text"),
GetSQLValueString(isset($HTTP_POST_VARS['EZT']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($HTTP_POST_VARS['GRT']) ? "true" : "", "defined","1","0"),
GetSQLValueString($HTTP_POST_VARS['Verpfleg'], "text"),
GetSQLValueString($HTTP_POST_VARS['laenge'], "text"),
GetSQLValueString($HTTP_POST_VARS['leist'], "text"),
GetSQLValueString($HTTP_POST_VARS['bh_ap'], "text"),
GetSQLValueString($HTTP_POST_VARS['erm'], "text"),
GetSQLValueString($HTTP_POST_VARS['fahr'], "text"),
GetSQLValueString($HTTP_POST_VARS['sonst'], "text"));
mysql_select_db($database_Axel, $Axel);
$Result1 = mysql_query($insertSQL, $Axel) or die(mysql_error());
}
$daten = mysql_insert_id($Axel);
if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "tour")) {
$insertSQL = sprintf("INSERT INTO dates (da1v, da1b, da2v, da2b, da3v, da3b, da4v, da4b, da5v, da5b, da6v, da6b, db1v, db1b, db2v, db2b, db3v, db3b, db4v, db4b, db5v, db5b, db6v, db6b, dc1v, dc1b, dc2v, dc2b, dc3v, dc3b, dc4v, dc4b, dc5v, dc5b, dc6v, dc6b) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($HTTP_POST_VARS['da1v'], "date"),
GetSQLValueString($HTTP_POST_VARS['da1b'], "date"),
GetSQLValueString($HTTP_POST_VARS['da2v'], "date"),
GetSQLValueString($HTTP_POST_VARS['da2b'], "date"),
GetSQLValueString($HTTP_POST_VARS['da3v'], "date"),
GetSQLValueString($HTTP_POST_VARS['da3b'], "date"),
GetSQLValueString($HTTP_POST_VARS['da4v'], "date"),
GetSQLValueString($HTTP_POST_VARS['da4b'], "date"),
GetSQLValueString($HTTP_POST_VARS['da5v'], "date"),
GetSQLValueString($HTTP_POST_VARS['da5b'], "date"),
GetSQLValueString($HTTP_POST_VARS['da6v'], "date"),
GetSQLValueString($HTTP_POST_VARS['da6b'], "date"),
GetSQLValueString($HTTP_POST_VARS['db1v'], "date"),
GetSQLValueString($HTTP_POST_VARS['db1b'], "date"),
GetSQLValueString($HTTP_POST_VARS['db2v'], "date"),
GetSQLValueString($HTTP_POST_VARS['db2b'], "date"),
GetSQLValueString($HTTP_POST_VARS['db3v'], "date"),
GetSQLValueString($HTTP_POST_VARS['db3b'], "date"),
GetSQLValueString($HTTP_POST_VARS['db4v'], "date"),
GetSQLValueString($HTTP_POST_VARS['db4b'], "date"),
GetSQLValueString($HTTP_POST_VARS['db5v'], "date"),
GetSQLValueString($HTTP_POST_VARS['db5b'], "date"),
GetSQLValueString($HTTP_POST_VARS['db6v'], "date"),
GetSQLValueString($HTTP_POST_VARS['db6b'], "date"),
GetSQLValueString($HTTP_POST_VARS['dc1v'], "date"),
GetSQLValueString($HTTP_POST_VARS['dc1b'], "date"),
GetSQLValueString($HTTP_POST_VARS['dc2v'], "date"),
GetSQLValueString($HTTP_POST_VARS['dc2b'], "date"),
GetSQLValueString($HTTP_POST_VARS['dc3v'], "date"),
GetSQLValueString($HTTP_POST_VARS['dc3b'], "date"),
GetSQLValueString($HTTP_POST_VARS['dc4v'], "date"),
GetSQLValueString($HTTP_POST_VARS['dc4b'], "date"),
GetSQLValueString($HTTP_POST_VARS['dc5v'], "date"),
GetSQLValueString($HTTP_POST_VARS['dc5b'], "date"),
GetSQLValueString($HTTP_POST_VARS['dc6v'], "date"),
GetSQLValueString($HTTP_POST_VARS['dc6b'], "date"));
mysql_select_db($database_Axel, $Axel);
$Result2 = mysql_query($insertSQL, $Axel) or die(mysql_error());
}
$dates = mysql_insert_id($Axel);
if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "tour")) {
$insertSQL = sprintf("INSERT INTO preise (p1be, p1, p2, p2be, p3, p3be, p4, p4be, p5be, p5, p6be, p6) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($HTTP_POST_VARS['p1be'], "text"),
GetSQLValueString($HTTP_POST_VARS['p1'], "text"),
GetSQLValueString($HTTP_POST_VARS['p2be'], "text"),
GetSQLValueString($HTTP_POST_VARS['p2'], "text"),
GetSQLValueString($HTTP_POST_VARS['p3be'], "text"),
GetSQLValueString($HTTP_POST_VARS['p3'], "text"),
GetSQLValueString($HTTP_POST_VARS['p4be'], "text"),
GetSQLValueString($HTTP_POST_VARS['p4'], "text"),
GetSQLValueString($HTTP_POST_VARS['p5be'], "text"),
GetSQLValueString($HTTP_POST_VARS['p5'], "text"),
GetSQLValueString($HTTP_POST_VARS['p6be'], "text"),
GetSQLValueString($HTTP_POST_VARS['p6'], "text"));
mysql_select_db($database_Axel, $Axel);
$Result3 = mysql_query($insertSQL, $Axel) or die(mysql_error());
}
$preise = mysql_insert_id($Axel);
if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "tour")) {
$insertSQL = sprintf("INSERT INTO veran (Name, Text) VALUES (%s, %s)",
GetSQLValueString($HTTP_POST_VARS['vername'], "text"),
GetSQLValueString($HTTP_POST_VARS['vertext'], "text"));
mysql_select_db($database_Axel, $Axel);
$Result4 = mysql_query($insertSQL, $Axel) or die(mysql_error());
}
$veran = mysql_insert_id($Axel);
$insertSQL = "INSERT INTO touren (Name, idcatlang_ID, daten_ID, dates_ID, preise_ID, ver_ID) VALUES ('$tname', '$idcatlang_ID', '$daten', '$dates', '$preise', '$veran')";
mysql_select_db($database_Axel, $Axel);
$Result5 = mysql_query($insertSQL, $Axel) or die(mysql_error());
?>
<table width="61%" border="0">
<tr align="left" valign="top">
<td colspan="2">
<table width="266" align="center">
<tr valign="baseline">
<td width="91" align="right" nowrap>Tourname:</td>
<td width="215"><input type="text" name="tname" value="" size="32"></td>
</tr>
</table></td>
</tr>
<tr align="left" valign="top">
<td width="53%" rowspan="3">
<table width="346" align="left">
<tr valign="baseline">
<td width="91" align="right" nowrap>Buchungscode:</td>
<td width="335" align="left" valign="top"> <input type="text" name="buch" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">EZT:</td>
<td align="left" valign="top"> <input type="checkbox" name="EZT" value="" ></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">GRT:</td>
<td align="left" valign="top"> <input type="checkbox" name="GRT" value="" ></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Verpflegung:</td>
<td align="left" valign="top"> <input type="text" name="Verpfleg" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right" valign="top">Tourlänge:</td>
<td align="left" valign="top"> <input type="text" name="laenge" value="" Size="32"></input>
</td>
</tr>
<tr valign="baseline">
<td nowrap align="right" valign="top">Leistungen:</td>
<td align="left" valign="top"> <textarea name="leist" cols="35" rows="5"></textarea></td>
</tr>
<tr valign="baseline">
<td nowrap align="right" valign="top">Bahn/Flugh:</td>
<td align="left" valign="top"> <textarea name="bh_ap" cols="35" rows="3"></textarea>
</td>
</tr>
<tr valign="baseline">
<td height="26" align="right" nowrap>Ermäsigung:</td>
<td align="left" valign="top"> <input type="text" name="erm" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Fahrad:</td>
<td align="left" valign="top"> <input type="text" name="fahr" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td height="123" align="right" valign="top" nowrap>Sonstiges:</td>
<td align="left" valign="top"> <textarea name="sonst" cols="35" rows="5"></textarea>
</td>
</tr>
</table></td>
<td width="47%">
<table width="75%" border="0">
<tr>
<td width="50">1.1Von:</td>
<td width="61"><input type="text" name="da1v" value="" size="10"></td>
<td width="1" rowspan="12" bgcolor="#CCCCCC"> </td>
<td width="49">1.2Von:</td>
<td width="60"><input type="text" name="db1v" value="" size="10"></td>
<td width="1" rowspan="12" bgcolor="#CCCCCC"> </td>
<td width="12">1.3Von:</td>
<td width="9"><input type="text" name="dc1v" value="" size="10"></td>
</tr>
<tr>
<td>1.1Bis:</td>
<td><input type="text" name="da1b" value="" size="10"></td>
<td>1.2Bis:</td>
<td><input type="text" name="db1b" value="" size="10"></td>
<td>1.3Bis:</td>
<td><input type="text" name="dc1b" value="" size="10"></td>
</tr>
<tr>
<td>2.1Von:</td>
<td><input type="text" name="da2v" value="" size="10"></td>
<td>2.2Von:</td>
<td><input type="text" name="db2v" value="" size="10"></td>
<td>2.3Von:</td>
<td><input type="text" name="dc2v" value="" size="10"></td>
</tr>
<tr>
<td>2.1Bis:</td>
<td><input type="text" name="da2b" value="" size="10"></td>
<td>2.2Bis:</td>
<td><input type="text" name="db2b" value="" size="10"></td>
<td>2.3Bis:</td>
<td><input type="text" name="dc2b" value="" size="10"></td>
</tr>
<tr>
<td>3.1Von:</td>
<td><input type="text" name="da3v" value="" size="10"></td>
<td>3.2Von:</td>
<td><input type="text" name="db3v" value="" size="10"></td>
<td>3.3Von:</td>
<td><input type="text" name="dc3v" value="" size="10"></td>
</tr>
<tr>
<td>3.1Bis:</td>
<td><input type="text" name="da3b" value="" size="10"></td>
<td>3.2Bis:</td>
<td><input type="text" name="db3b" value="" size="10"></td>
<td>3.3Bis:</td>
<td><input type="text" name="dc3b" value="" size="10"></td>
</tr>
<tr>
<td>4.1Von:</td>
<td><input type="text" name="da4v" value="" size="10"></td>
<td>4.2Von:</td>
<td><input type="text" name="db4v" value="" size="10"></td>
<td>4.3Von:</td>
<td><input type="text" name="dc4v" value="" size="10"></td>
</tr>
<tr>
<td>4.1Bis:</td>
<td><input type="text" name="da4b" value="" size="10"></td>
<td>4.2Bis:</td>
<td><input type="text" name="db4b" value="" size="10"></td>
<td>4.3Bis:</td>
<td><input type="text" name="dc4b" value="" size="10"></td>
</tr>
<tr>
<td>5.1Von:</td>
<td><input type="text" name="da5v" value="" size="10"></td>
<td>5.2Von:</td>
<td><input type="text" name="db5v" value="" size="10"></td>
<td>5.3Von:</td>
<td><input type="text" name="dc5v" value="" size="10"></td>
</tr>
<tr>
<td>5.1Bis:</td>
<td><input type="text" name="da5b" value="" size="10"></td>
<td>5.2Bis:</td>
<td><input type="text" name="db5b" value="" size="10"></td>
<td>5.3Bis:</td>
<td><input type="text" name="dc5b" value="" size="10"></td>
</tr>
<tr>
<td>6.1Von:</td>
<td><input type="text" name="da6v" value="" size="10"></td>
<td>6.2Von:</td>
<td><input type="text" name="db6v" value="" size="10"></td>
<td>6.3Von:</td>
<td><input type="text" name="dc6v" value="" size="10"></td>
</tr>
<tr>
<td>6.1Bis:</td>
<td><input type="text" name="da6b" value="" size="10"></td>
<td>6.2Bis:</td>
<td><input type="text" name="db6b" value="" size="10"></td>
<td>6.3Bis:</td>
<td><input type="text" name="dc6b" value="" size="10"></td>
</tr>
</table></td>
</tr>
<tr>
<td>
<table width="59%" border="0">
<tr>
<td width="81">1Preisbeschr:</td>
<td width="90"><input type="text" name="p1be" value="" size="15"></td>
<td width="1" rowspan="6" bgcolor="#CCCCCC"> </td>
<td width="81">4Preisbeschr:</td>
<td width="90"><input type="text" name="p4be" value="" size="15"></td>
</tr>
<tr>
<td>1Preis:</td>
<td><input type="text" name="p1" value="" size="5"></td>
<td>4Preis:</td>
<td><input type="text" name="p4" value="" size="5"></td>
</tr>
<tr>
<td>2Preisbeschr:</td>
<td><input type="text" name="p2be" value="" size="15"></td>
<td>5Preisbeschr:</td>
<td><input type="text" name="p5be" value="" size="15"></td>
</tr>
<tr>
<td>2Preis:</td>
<td><input type="text" name="p2" value="" size="5"></td>
<td>5Preis:</td>
<td><input type="text" name="p5" value="" size="5"></td>
</tr>
<tr>
<td>3Preisbeschr:</td>
<td><input type="text" name="p3be" value="" size="15"></td>
<td>6Preisbeschr:</td>
<td><input type="text" name="p6be" value="" size="15"></td>
</tr>
<tr>
<td>3Preis:</td>
<td><input type="text" name="p3" value="" size="5"></td>
<td>6Preis:</td>
<td><input type="text" name="p6" value="" size="5"></td>
</tr>
</table></td>
</tr>
<tr>
<td>
<table align="left">
<tr>
<td colspan="2" align="left" nowrap>Veranstallterdaten</td>
</tr>
<tr>
<td align="right" valign="baseline" nowrap>Name:</td>
<td valign="baseline"> <input type="text" name="vername" value="" size="32"></td>
</tr>
<tr>
<td nowrap align="right" valign="top">Text:</td>
<td valign="baseline"> <textarea name="vertext" cols="47" rows="5"></textarea></td>
</tr>
</table></td>
</tr>
<tr align="left" valign="top">
<td colspan="2"> </td>
</tr>
<tr align="left" valign="top">
<td> </td>
<td>
<input type="hidden" name="idcatlang_ID" value="<? echo "$idcat" ?>"> <input type="hidden" name="daten_ID" value="<? echo "$daten" ?>">
<input type="hidden" name="dates_ID" value="<? echo "$dates" ?>"> <input type="hidden" name="preise_ID" value="<? echo "$preise" ?>">
<input type="hidden" name="ver_ID" value="<? echo "$veran" ?>"> <input type="hidden" name="MM_insert" value="tour">
<input name="submit" type="submit" value="Datensatz einfügen"> </td>
</tr>
</table>
<? mysql_free_result($tour);