Php für einsteiger

von **Admin** Mi Mai 20, 2015 7:23 pm

<html>
<head>
<title>Buchhandel</title>
<link rel="stylesheet" type="text/css" href="style.css">
<script src="java.js"></script>
</head>
<body>

<nav>
<h3>Mitarbeiter</h3>
<ul>
<li><a href='Mitarbeiter_TOP.php'>Top Mitarbeiter</a></li>
<li><a href='Mitarbeiter_NEW.html'>Neuer Mitarbeiter</a></li>
<li><a href='Mitarbeiter_OVERVIEW.php'>Uebersicht</a></li>
</ul>

<h3>Kunden</h3>
<ul>
<li><a href='Kunden_TOP.php'>Top Kunden</a></li>
<li><a href='Kunden_NEW.html'>Kunden Anlegen</a></li>
<li><a href='Kunden_OVERVIEW.php'>Kunden Uebersicht</a></li>
</ul>

<h3>Buecher</h3>
<ul>
<li><a href='Buch_Bestseller.php'>Bestseller</a></li>
<li><a href='Buch_NEW.html'>Neues Buch</a></li>
<li><a href='Buch_OVERVIEW.php'>Uebersicht</a></li>
</ul>

<h3>Transaktionen</h3>
<ul>
<li><a href='Trans_OVERVIEW.php'>Transaktionen</a></li>
</ul>
</nav>

<h2 align="center"> Buch Anlegen </h2>

<form action="Buch_NEW.php" method="post">
<table align='center'>
<tr>
<td>Name: </td><td><input type="text" name="m_name" maxlength="16" required
onkeydown="return alphaOnly(event);"/></td></td>
</tr>
<tr>
<td>Author: </td><td><input type="text" name="m_author"maxlength="16" required
onkeydown="return alphaOnly(event);"/></td></td>
</tr>
<tr>
<td>Jahr: </td><td><input type="tel" name="m_jahr"maxlength="16" required/></td></td>
</tr>
<tr>
<td>Preis: </td><td><input type="text" name="m_preis"maxlength="16" required/></td></td>
</tr>
<tr align="right">
<td><input type="submit" value="OK" align="right"></td>
</tr>
</table>
</form>

</body>
</html>

von **Admin** Mi Mai 20, 2015 7:23 pm

<?php
$con=mysqli_connect("127.0.0.1","root","root","buchhandel");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$query = "INSERT INTO buch(Name, Author, Jahr, Preis)
VALUES ('" . $_POST['m_name'] . "',
'" . $_POST['m_author'] . "',
'" . $_POST['m_jahr'] . "',
" . $_POST['m_preis'] . ")";

$result = mysqli_query($con, $query);
?>

<html>
<head>
<title>Buchhandel</title>
<link rel='stylesheet' type='text/css' href='style.css'>
<script src="java.js"></script>
</head>
<body>

<nav>
<h3>Mitarbeiter</h3>
<ul>
<li><a href='Mitarbeiter_TOP.php'>Top Mitarbeiter</a></li>
<li><a href='Mitarbeiter_NEW.html'>Neuer Mitarbeiter</a></li>
<li><a href='Mitarbeiter_OVERVIEW.php'>Uebersicht</a></li>
</ul>

<h3>Kunden</h3>
<ul>
<li><a href='Kunden_TOP.php'>Top Kunden</a></li>
<li><a href='Kunden_NEW.html'>Kunden Anlegen</a></li>
<li><a href='Kunden_OVERVIEW.php'>Kunden Uebersicht</a></li>
</ul>

<h3>Buecher</h3>
<ul>
<li><a href='Buch_Bestseller.php'>Bestseller</a></li>
<li><a href='Buch_NEW.html'>Neues Buch</a></li>
<li><a href='Buch_OVERVIEW.php'>Uebersicht</a></li>
</ul>

<h3>Transaktionen</h3>
<ul>
<li><a href='Trans_OVERVIEW.php'>Transaktionen</a></li>
</ul>
</nav>

<h2 align='center'> Buch Anlegen </h2>

<form action='Buch_NEW.php' method='post'>
<table align='center'>
<tr>
<td>Name: </td><td><input type='text' name='m_name' maxlength='16' required
onkeydown="return alphaOnly(event);"/></td>
</tr>
<tr>
<td>Author: </td><td><input type='text' name='m_author' maxlength='16' required
onkeydown='return alphaOnly(event);'/></td>
</tr>
<tr>
<td>Jahr: </td><td><input type='tel' name='m_jahr' maxlength='16' required/></td>
</tr>
<tr>
<td>Preis: </td><td><input type='text' name='m_preis' maxlength='16' required/></td>
</tr>

<tr align='right'>
<td><input type='submit' value='OK' ></td>
</tr>
</table>
</form>

</body>

<script type="text/javascript">
function alphaOnly(event) {
var key = event.keyCode;
return ((key >= 65 && key <= 90) || key == Cool

;
};
</script>
</html>

<?php
mysqli_close($con);
?>

von **Admin** Mi Mai 20, 2015 7:25 pm

nav {
display: block;
float: left;
margin-bottom: 4px;
overflow: hidden;
box-shadow: 0 0 2px #888;
margin-left: 0.5%;
margin-right: 0.5%;
width: 200px
}

h3{
float: center;
}

.asd {
width: 300px;
margin: 0 auto;
float: center
}

von **Admin** Mi Mai 20, 2015 7:25 pm

<?php
$con=mysqli_connect("127.0.0.1","root","root","buchhandel");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$result = mysqli_query($con, "SELECT *
FROM buch
WHERE Aktiv = 1
ORDER BY Jahr DESC");

echo "
<html>
<head>
<title>Buchhandel</title>
<link rel='stylesheet' type='text/css' href='style.css'>
<script src='java.js'></script>
</head>
<body>

<nav>
<h3>Mitarbeiter</h3>
<ul>
<li><a href='Mitarbeiter_TOP.php'>Top Mitarbeiter</a></li>
<li><a href='Mitarbeiter_NEW.html'>Neuer Mitarbeiter</a></li>
<li><a href='Mitarbeiter_OVERVIEW.php'>Uebersicht</a></li>
</ul>

<h3>Kunden</h3>
<ul>
<li><a href='Kunden_TOP.php'>Top Kunden</a></li>
<li><a href='Kunden_NEW.html'>Kunden Anlegen</a></li>
<li><a href='Kunden_OVERVIEW.php'>Kunden Uebersicht</a></li>
</ul>

<h3>Buecher</h3>
<ul>
<li><a href='Buch_Bestseller.php'>Bestseller</a></li>
<li><a href='Buch_NEW.html'>Neues Buch</a></li>
<li><a href='Buch_OVERVIEW.php'>Uebersicht</a></li>
</ul>

<h3>Transaktionen</h3>
<ul>
<li><a href='Trans_OVERVIEW.php'>Transaktionen</a></li>
</ul>
</nav>

<h2 align='center'> Buch Uebersicht </h2>

<table align='center' border='1'>
<tr>
<th>Name</th>
<th>Author</th>
<th>Jahr</th>
<th>Preis</th>
<th>Aktion</th>
</tr>";

while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['Name'] . "</td>";
echo "<td>" . $row['Author'] . "</td>";
echo "<td align='right'>" . date('d-m-Y', strtotime($row['Jahr'])) . "</td>";
echo "<td>" . (int)$row['Preis'] . "</td>";
echo "<form action='Buch_DEL.php'>";
echo "<td><input type='submit' value='löschen' >";
echo "<input type='text' style='visibility:hidden; height:0px; width:0px' name='delId' value='". $row['BuchId'] ."'/></td>";
echo "</form>";
echo "</tr>";
}

echo "
</table>
</body>
</html>";

mysqli_close($con);
?>

von **Admin** Mi Mai 20, 2015 7:26 pm

<?php
$con=mysqli_connect("127.0.0.1","root","root","buchhandel");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$test = mysqli_query($con, "Update buch
SET Aktiv = 0
WHERE BuchId = " . (int)$_GET['delId'] . "");

$result = mysqli_query($con, "SELECT *
FROM buch
WHERE Aktiv = 1
ORDER BY Jahr DESC");

echo "
<html>
<head>
<title>Buchhandel</title>
<link rel='stylesheet' type='text/css' href='style.css'>
</head>
<body>

<nav>
<h3>Mitarbeiter</h3>
<ul>
<li><a href='Mitarbeiter_TOP.php'>Top Mitarbeiter</a></li>
<li><a href='Mitarbeiter_NEW.html'>Neuer Mitarbeiter</a></li>
<li><a href='Mitarbeiter_OVERVIEW.php'>Uebersicht</a></li>
</ul>

<h3>Kunden</h3>
<ul>
<li><a href='Kunden_TOP.php'>Top Kunden</a></li>
<li><a href='Kunden_NEW.html'>Kunden Anlegen</a></li>
<li><a href='Kunden_OVERVIEW.php'>Kunden Uebersicht</a></li>
</ul>

<h3>Buecher</h3>
<ul>
<li><a href='Buch_Bestseller.php'>Bestseller</a></li>
<li><a href='Buch_NEW.html'>Neues Buch</a></li>
<li><a href='Buch_OVERVIEW.php'>Uebersicht</a></li>
</ul>

<h3>Transaktionen</h3>
<ul>
<li><a href='Trans_OVERVIEW.php'>Transaktionen</a></li>
</ul>
</nav>

<h2 align='center'> Mitarbeiter Uebersicht </h2>

<table align='center' border='1'>
<tr>
<th>Name</th>
<th>Author</th>
<th>Jahr</th>
<th>Preis</th>
<th>Aktion</th>
</tr>";

while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['Name'] . "</td>";
echo "<td>" . $row['Author'] . "</td>";
echo "<td align='right'>" . date('d-m-Y', strtotime($row['Jahr'])) . "</td>";
echo "<td>" . (int)$row['Preis'] . "</td>";
echo "<form action='Buch_DEL.php'>";
echo "<td><input type='submit' value='löschen' >";
echo "<input type='text' style='visibility:hidden; height:0px; width:0px' name='delId' value='". $row['BuchId'] ."'/></td>";
echo "</form>";
echo "</tr>";
}

echo "
</table>
</body>
</html>";

mysqli_close($con);
?>

von Gesponserte Inhalte

Php für einsteiger

Php für einsteiger

Re: Php für einsteiger

Re: Php für einsteiger

Re: Php für einsteiger

Re: Php für einsteiger

Re: Php für einsteiger