Hirdetés

  2. Fórumok
  3. Szoftverfejlesztés
  4. PHP programozás
  5. (kiemelt téma)

Új hozzászólás Aktív témák

  • #17681 momoxp tag
    Új Válasz #17681
    Új hozzászólás
    Összes hozzászólása itt Válaszok az összes hozzászólására itt Válaszok erre a hozzászólásra
    Privát üzenet küldése

    momoxp

    tag

    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>

    [ Módosította: mobal ]

Új hozzászólás Aktív témák