Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $user= "root";
- $pass= "toor";
- $db= "bdeg";
- $kapcsolat = mysql_connect("localhost", $user) or die("Nem sikerült kapcsolódni az adatbázishoz!");
- mysql_select_db( $db ) or die("Nem sikerült kiválasztani az adatbázist!");
- $ok = "SELECT * FROM tanarinaptar";
- ?><?php
- $soroknakszama = 0;
- ?> <table style="border-collapse:collapse;border:1px solid black;" width="100%"><tr><td><?php echo($ok);?></td></tr></table><?php
- $eredmeny = mysql_query($ok) or $err = 1;
- echo('<table border="1" width="100%" style="border-collapse:collapse;border:1px solid black;">');
- if ($err){
- echo('<tr><td style="color:red">'.mysql_error().'</td></tr>');
- }else{
- if($eredmeny){
- $fejlec = 1;
- $soroknakszama = 0;
- while($ujtomb = @mysql_fetch_array($eredmeny, MYSQL_ASSOC)){
- $soroknakszama++;
- if ($fejlec){
- echo('<tr style="font-weight:bold;border-bottom:1px solid black">');
- foreach($ujtomb as $kulcs => $ertek){
- echo('<td>'.$kulcs.'</td>');
- }
- echo('</tr>');
- $fejlec = 0;
- }
- echo('<tr>');
- $kihagy = 1;
- foreach($ujtomb as $kulcs => $ertek){
- echo('<td>'.$ertek.'</td>');
- }
- echo('</tr>');
- }
- }else{
- echo('<tr><td>A lekérdezés nem adott vissza eredményt. </td></tr>');
- }
- }
- echo('</table>');
- ?><?php
- if($_POST['ekson']=='ujat')
- {
- $ujd = $_POST["ujdatum"];
- $ujo = $_POST["ujosztaly"];
- $ujt = $_POST["tantargyuj"];
- $end = 'INSERT INTO tanarinaptar (datum, osztaly, tantargy) VALUES "'.$ujd.'", "'.$ujo.'", "'.$ujt.'";';
- $eend = mysql_query($end);
- }
- ?>
- <form name="mail" method="post" action="<?php echo $_SERVER["PHP_SELF"];?>" target="_self">
- <input type="text" name="ujdatum" size="30" value="2010-" />
- <input type="text" name="ujosztaly" size="30" value="Class" />
- <input type="text" name="tantargyuj" size="30" value="Course" />
- <input type="hidden" name="ekson" value="ujat" />
- <input type="submit" name="ujdoga" value="Send">
- </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement