Sziasztok!
Szerintetek ebben mi a hiba? Miért nem tölti fel a mysql adatbázisba a tartalmat?
<?php
global $username;
global $deviancename;
global $deviance;
global $switchrouter;
global $port;
global $lanmacaddress;
global $wifimacaddress;
global $ip4address;
$host = 'localhost';
$user = 'root';
$password = 'valami';
$connect = mysql_connect( $host, $user, $password ) or die
( "Error: Can not connect to server" );
mysql_select_db( "routerdatabase", $connect ) or die ( "Can not connect to database" );
$username = $_POST["username"];
$deviancename = $_POST["deviancename"];
$deviance = $_POST["deviance"];
$switchrouter = $_POST["switchrouter"];
$port = $_POST["port"];
$lanmacaddress = $_POST["lanmacaddress"];
$wifimacaddress = $_POST["wifimacaddress"];
$ip4address = $_POST["ip4address"];
if ( isset($username) && isset($deviancename) && isset($deviance) && isset($switchrouter) && isset($port) && isset($lanmacaddress) && isset($wifimacaddress) && isset($ip4address) ) {
$sql = "INSERT INTO routerdatabase (username, deviancename, deviance, switchrouter, port, lanmacaddress, wifimacaddress, ip4address)
VALUES ('" . $username ."','". $deviancename. "','". $deviance. "','". $switchrouter . "','". $port . "','". $lanmacaddress . "','". $wifimacaddress . "','". $ip4address . "')";
mysql_query( $sql ) or die ("Hiba a beszúrásnál");
}
$sql = "SELECT port FROM port";
$port = mysql_query( $sql );
mysql_close($connect);
?>
<html>
<head>
<title>Az oldal címe</title>
<meta charset="UTF-8" />
<!-- CSS -->
<link rel="stylesheet" type="text/css" href="css/style.css" /><!-- Az oldal kinézete -->
</head>
<body>
<div class="header">iToth Corporation</div>
<div class="content">
<hr />
<form action="index.php" method="post">
<table>
<tr>
<td id="t">Username</td>
<td id="t">Deviance Name</td>
<td id="t">Deviance</td>
<td id="t">Router/Switch</td>
<td id="t">Router/Switch Port</td>
<td id="t">LAN M.A.C. Address</td>
<td id="t">Wirelles M.A.C. Address</td>
<td id="t">IP4 Address</td>
</tr>
<tr>
<td><input type="text" id="username" name="username" placeholder="User name" size="20" autofocus=""/></td>
<td><input type="text" id="deviancename" name="deviancename" placeholder="Devaince name" size="20" autofocus=""/></td>
<td><select id="deviance" name="deviance">
<option value="desktoppc">Desktop-PC</option>
<option value="notebook">Notebook</option>
<option value="mobile">Mobile</option>
<option value="tablet">Tablet</option>
<option value="console">Console</option>
</select></td>
<td><select id="switchrouter" name="switchrouter">
<option value="tplinkr">TP-Link Router</option>
<option value="tplinks">TP-Link Switch</option>
</select></td>
<td><input type="text" id="port" name="port" placeholder="" size="2" autofocus=""/></td>
<td><input type="text" id="lanmacaddress" name="lanmacaddress" placeholder="00:00:00:00:00" size="14" autofocus=""/></td>
<td><input type="text" id="wifimacaddress" name="wifimacaddress" placeholder="00:00:00:00:00" size="14" autofocus=""/></td>
<td><input type="text" id="ip4address" name="ip4macaddress" placeholder="000.000.000.000" size="15" autofocus=""/></td>
</tr>
</table>
<hr />
<input type="submit" value="SEND"/>
</form>
</div>
<div class="footer">Footer</div>
</body>
</html>