Mam skrypt addevent.php
[php:1:83746fede9]<?php
<html>
<head>
<title>Add Event</title>
</head>
<body>
<font size="+2"><b>Add Event</b></font><br><br>
<?php
if ($action == "add") {
include("common.php");
$link = dbConnect();
if ($year < 60) {
$year += 2000;
} else if ($year < 100) {
$year += 1900;
}
$month--;
$event = nl2br($event);
$event = eregi_replace("[nr]+", "", $event);
$query = "INSERT INTO $table (year, month, day, title, event) VALUES ($year, $month, $day, '$title', '$event')";
// Execute query
$result = mysql_query($query);
if ($result)
{
print "<font color="#0000ff">Event added</font><br>n";
}
else
{
// Otherwise, inform user of failure
print "<font color="#ff0000">Couldn't add event</font><br>n";
}
mysql_close($link);
}
?>
<form action="addevent.php" METHOD="post">
<table border="1" cellspacing="2" cellpadding="3">
<tr>
<td>Date</td>
<td>
Day <input type="number" name="day" size="2">
Month <input type="number" name="month" size="2">
Year <input type="number" name="year" size="4">
</td>
</tr>
<tr>
<td>Title</td>
<td><input type="text" name="title" size="50"></td>
</tr>
<tr>
<td>Event</td>
<td><textarea name="event" cols="50" rows="5"></textarea></td>
</tr>
<tr>
<td colspan="2">
<input type="hidden" name="action" value="add">
<input type="submit" value="Add Event">
</td>
</tr>
</table>
</form>
</body>
?>
</html>
[/php:1:83746fede9]
i skrypt common.php
[php:1:83746fede9]
<?
$dbHost = "localhost";
$dbUser = "nazwa";
$dbPass = "nazwa";
$dbName = "nazwa";
$table = "nazwa";
function dbConnect() {
global $dbHost;
global $dbUser;
global $dbPass;
global $dbName;
$link = @mysql_connect($dbHost, $dbUser, $dbPass);
if (!$link) {
fail("Couldn't connect to database server");
}
if (!@mysql_select_db($dbName)) {
fail("Couldn't find database $dbName");
}
return $link;
}
function fail($errorMsg) {
$errorMsg = urlencode($errorMsg);
print "&result=Fail&errormsg=$errorMsg";
exit;
}
?>
Dlaczego nie dodają mi się rekordy do tabeli.
Z wiersza poleceń działa.
Czy moga to być jakies problemy z ustawieniami?
Bo testowałem już (niestety bardzo długo) z różnymi skryptami.
?>[/php:1:83746fede9]