Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=windows-1250">
- <title></title>
- </head>
- <body>
- <form action="" method="post">
- Jméno: <input type="text" name="jmeno" maxlength="15" value=""> <br>
- Příjmení: <input type="text" name="prijmeni" maxlength="15" value=""> <br>
- <?php
- $prac_pozice=array( "top managment"=>array("president","vice president","senior manager"),
- "middle managment"=>array("manager","representative","controller"),
- "other"=>array("office manager","ICT manager"));
- $host=array("@seznam.cz","@centrum.cz","@email.cz");
- echo '<select name="funkce">';
- foreach($prac_pozice as $pozice => $data){
- echo '<optgroup label="' . $pozice . '"> </optgroup>';
- foreach ($data as $h) echo '<option value="' . $h . '">'. $h . '</option>';
- }
- echo '</select>';
- echo '<select name="hosting">';
- foreach ($host as $h) echo '<option value="' . $h . '">'. $h . '</option>';
- echo '</select>';
- ?>
- <input type="submit" value="odeslat">
- </form>
- <?php
- function creates_email($jm,$pr) {
- global $i;
- $pr=(StrTr($pr, "ÁÄČÇĎÉĚËÍŇÓÖŘŠŤÚŮÜÝŽáäčçďéěëíňóöřšťúůüýž", "AACCDEEEINOORSTUUUYZaaccdeeeinoorstuuuyz"));
- $jm=(StrTr($jm, "ÁÄČÇĎÉĚËÍŇÓÖŘŠŤÚŮÜÝŽáäčçďéěëíňóöřšťúůüýž", "AACCDEEEINOORSTUUUYZaaccdeeeinoorstuuuyz"));
- if ($i > sizeof($_POST['jmeno'])) $texxt=strtolower (substr ($jm , 0 , $i ) ).strtolower ($pr) ;
- else $texxt=strtolower (substr ($jm , 0 , sizeof($_POST['jmeno']) ) ).strtolower ($pr) ;
- return $texxt . $_POST["hosting"];
- }
- function zapis(){
- global $i;
- if (mysql_errno()==1062){
- include "inc.php";
- $email=creates_email($_POST['jmeno'], $_POST['prijmeni']);
- $zapis=mysql_query("INSERT INTO `08ia31_kolar`.`zamestnanci` (`jmeno`, `prijmeni`, `funkce`, `email`) VALUES ('$_POST[jmeno]', '$_POST[prijmeni]', '$_POST[funkce]', '$email');", $spojeni);
- $i++;
- mysql_close($zapis);
- zapis();
- }
- }
- if ( (!empty($_POST['jmeno'])) and (!empty($_POST['prijmeni'])) and (!empty($_POST['funkce'])) and (!empty($_POST['hosting'])) )
- {
- include "inc.php";
- $email=creates_email($_POST['jmeno'], $_POST['prijmeni']);
- $dotaz=mysql_query("SET CHARACTER SET cp1250");
- $zapis=mysql_query("INSERT INTO `08ia31_kolar`.`zamestnanci` (`jmeno`, `prijmeni`, `funkce`, `email`) VALUES ('$_POST[jmeno]', '$_POST[prijmeni]', '$_POST[funkce]', '$email');", $spojeni);
- $i++;
- zapis();
- mysql_close($zapis);
- }
- ?>
- <?php
- include "inc.php";
- $dotaz=mysql_query("SET CHARACTER SET cp1250");
- $dotaz=mysql_query("SELECT * FROM `08ia31_kolar`.`zamestnanci` ;",$spojeni);
- echo "<table>";
- echo "<tr><td>" . "<u>ID</u>" . "</td><td>" . "<u>Jméno</u>" . "</td><td>" . "<u>Příjmení</u>" . "</td><td>" . "<u>Funkce</u>" . "</td><td>" . "<u>Email</u>" ."</td></tr>";
- while ($t=mysql_fetch_array($dotaz)) echo "<tr><td>" . $t["id"] . "</td><td>" . $t["jmeno"] . "</td><td>" . $t["prijmeni"] . "</td><td>" . $t["funkce"] . "</td><td>" . $t["email"] ."</td></tr>";
- echo "</table>";
- mysql_close($dotaz);
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement