plugin pro WP

Naučíme tě pracovat na home-office.

Zjistit více...

php

<?php
/**
* Plugin Name: Databaze
* Plugin URI: http://kpep.cz/
* Description: Databaze členů klubu.
* Version: 2.0
* Author: Radek Forgač
* Author URI: http://kpep.cz
**/


// Register the user database
add_action('admin_menu', 'create_database');
 
function create_database(){
        add_menu_page( 
        	'Databaze',
        	'Databaze', 
        	'manage_options', 
        	'database-plugin', 
        	'database_init'
        	);
}

//Link CSS file
echo("<link rel='stylesheet' type='text/css' href='css/style.css' />");

//MySQL connect

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "kpep_user";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";

// Register form inside
$stmt = $conn->prepare("INSERT INTO users (user_id, name, lastname, tel, email) VALUES (?, ?, ?, ?, ?)");
$stmt->bind_param("sssss", $user_id, $name, $lastname, $tel, $email);

// parameters
$user_id = $_POST['user_id'];
$name = $_POST['name'];
$lastname = $_POST['lastname'];
$tel = $_POST['tel'];
$email = $_POST['email'];
$stmt->execute();

// Main

function database_init(){
	echo("<h1>Databáze</h1>");

	// Tabs with register form
	?>
	    <form method="POST">
            ID:<br />
            <input type="text" name="user_id" /><br />
            Jméno:<br />
            <input type="text" name="name" /><br />
            Příjmení:<br />
            <input type="text" name="lastname" /><br />
            Tel:<br />
            <input type="text" name="tel" /><br />
            Email:<br />
            <input type="text" name="email" /><br />
            <input type="submit" value="Registrovat" />
        </form>
    <?php
echo('<h2>Členové Klubu</h2><table border="1">');

$result = mysql_query("SELECT * FROM users") 
or die(mysql_error());


echo "<table border='1'>";
echo "<tr> <th>ID</th> <th>Name</th> <th>Lastname</th> <th>Tel</th> <th>Email</th> </tr>";

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
	// Print out the contents of each row into a table
	echo "<tr><td>"; 
	echo $row['user_id'];
	echo "</td><td>"; 
	echo $row['name'];
	echo "</td><td>"; 
	echo $row['lastname'];
		echo "</td><td>"; 
	echo $row['tel'];
		echo "</td><td>"; 
	echo $row['email'];
	echo "</td></tr>"; 
} 

echo "</table>";
}

Neformátovaný

Přidáno: 28.2.2015
Expirace: Neuvedeno

Autor: kElops