Jump to content

Why save database ownly one field.

faces3

By faces3
in PHP Coding Help

Recommended Posts

faces3 Member

faces3

Posted
Posted 
<html>
<head>
<title>Uue firma loomine</title>
<meta name="description" content="Uue firma loomine">
<meta name="author" content="uus">

</head>
<body>
	 <form action= "" method="post">
<H2>Firma:</h2>
Firma nimi: 
 <input type="text" name = "fnimi" size="30" /></br>
Firma registrikood:  
<input type="text" name = "reg" size="30" /></br>
Telefoni number:  
<input type="text" name = "ftel" size="30" /></br>
Emaili aadress:  
<input type="text" name = "femail" size="30" /></br>
Koduleht:  
<input type="text" name = "www" size="30" /></br>
<H2>Admin:</H2>
Ees- ja perekonnanimi:  
<input type="text" name = "animi" size="30" /></br>
Telefoni numer:  
<input type="text" name = "atel" size="30" /></br>
Emaili aadress:  
<input type="text" name = "aemail" size="30" /></br>
Kasutajanimi:  
<input type="text" name = "akas" size="30" /></br>
Parool:  
<input type="text" name = "apwd" size="30" /></br>
<H2>Raamatupidaja:</H2>
Ees- ja perekonnanimi:  
<input type="text" name = "rnimi" size="30" /></br>
Telefoni numer:  
<input type="text" name = "rtel" size="30" /></br>
Emaili aadress: 
 <input type="text" name = "remail" size="30" /></br>
Kasutajanimi:  
<input type="text" name = "rkas" size="30" /></br>
Parool:  
<input type="text" name = "rpwd" size="30" /></br>
<h2>Töödejuhataja</h2>
Ees- ja perekonnanimi:  
<input type="text" name = "jnimi" size="30" /></br>
Telefoni numer: 
 <input type="text" name = "jtel" size="30" /></br>
Emaili aadress:  
<input type="text" name = "jemail" size="30" /></br>
Kasutajanimi: 
 <input type="text" name = "jkas" size="30" /></br>
Parool:  
<input type="text" name = "jpwd" size="30" /></br>
<h2>Tööline</h2>
Ees- ja perekonnanimi: 
 <input type="text" name = "jnimi" size="30" /></br>
Telefoni numer: 
 <input type="text" name = "jtel" size="30" /></br>
Emaili aadress:  
<input type="text" name = "jemail" size="30" /></br>
Kasutajanimi:  
<input type="text" name = "jkas" size="30" /></br>
Parool:  
<input type="text" name = "jpwd" size="30" /></br>
<h2>Uldine</h2>
Sisselogimis aadress:
 <input type="text" name = "sub" size="30" /></br>
     <input type="submit" value="Add" />
     </form>
</body>
</html>

<?php

// Firma andmed
$fnimi = $_REQUEST['fnimi'];
$reg = $_REQUEST['reg'];
$ftel = $_REQUEST['ftel'];
$femail = $_REQUEST['femail'];
$www = $_REQUEST['www'];
// Aladomeen/andmebaas/kaust
$sub = $_REQUEST['sub'];
// MySQL uhendus
$user="root";
$password="";
$database="firma";
$con="localhost";
mysql_connect($con,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
mysql_query("CREATE TABLE $sub(id int(6) NOT NULL auto_increment,firma_nimi varchar(50) NOT NULL,firma_reg varchar(50) NOT NULL,firma_telefon varchar(50) NOT NULL,firma_email varchar(50) NOT NULL,firma_www varchar(50) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))"); 
mysql_query("INSERT INTO $sub(firma_nimi, firma_reg, firma_telefon, firma_email, firma_www) VALUES ('$fnimi', 'reg', '$ftel', '$femail', '$fwww')");
mysql_close();
?>

<?php
	 $folder = $_REQUEST['sub'];
if(is_dir($folder))
echo "See kataloog on juba olemas!";
else
{
$zip = new ZipArchive;
     $res = $zip->open('w.zip');
     if ($res === TRUE) {
         $zip->extractTo($folder);
         $zip->close();
       
     }
     }
?>

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

 // Create database   
 if(isset($_POST['sub'])){ 
$andmebaas = $_POST['sub'];  
 $sql="CREATE DATABASE $andmebaas";   
 if (mysqli_query($con,$sql))   
  {   
  echo "Database my_db created successfully";   
  }   
else   
  {   
  echo "Error creating database: " . mysqli_error($con);   
  }   
  } 	 
?>
<?php
ini_set('error_reporting', E_ALL);
// Firma andmed
$fnimi = $_REQUEST['fnimi']; 
$reg = $_REQUEST['reg']; 
$ftel = $_REQUEST['ftel']; 
$femail = $_REQUEST['femail'];
$www = $_REQUEST['www'];

// MySQL uhendus
$user="root";
$password="";
if ( isset($_REQUEST['sub']) ) {
$database = $_REQUEST['sub']; }
$con="localhost";
mysql_connect($con,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
// Firma tabeli tegemine
mysql_query("CREATE TABLE firma(id int(6) NOT NULL auto_increment,firma_nimi varchar(50) NOT NULL,firma_reg varchar(50) NOT NULL,firma_telefon varchar(50) NOT NULL,firma_email varchar(50) NOT NULL,firma_www varchar(50) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))"); 

// Firma andmete sisestamine
mysql_query("INSERT INTO firma(firma_nimi, firma_reg, firma_telefon, firma_email, firma_www) VALUES ('$fnimi', '$reg', '$ftel', '$femail', '$fwww')");
mysql_close();
?>
<?php
ini_set('error_reporting', E_ALL);
// Admini andmed
$animi = $_REQUEST['animi'];
$atel = $_REQUEST['atel'];
$aemail = $_REQUEST['aemail'];
$akas = $_REQUEST['akas'];
$apwd = $_REQUEST['apwd'];

// MySQL uhendus
$user="root";
$password="";
if ( isset($_REQUEST['sub']) ) {
$database = $_REQUEST['sub']; }
$con="localhost";
mysql_connect($con,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");

// Admin tabeli tegemine
mysql_query("CREATE TABLE admin(id int(6) NOT NULL auto_increment,nimi varchar(50) NOT NULL,telefon varchar(50) NOT NULL,email varchar(50) NOT NULL,kasutaja varchar(50) NOT NULL,parool varchar(50) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))"); 
// Admin andmete sisestamine
mysql_query("INSERT INTO admin(admin_nimi, admin_telefon, admin_email, admin_kasutaja, admin_parool) VALUES ('$animi', '$atel', '$aemail', '$akas', '$apwd')");
mysql_close();
?>
<?php
ini_set('error_reporting', E_ALL);
// Raamatupidaja andmed
$animi = $_REQUEST['rnimi'];
$atel = $_REQUEST['rtel'];
$aemail = $_REQUEST['remail'];
$akas = $_REQUEST['rkas'];
$apwd = $_REQUEST['rpwd'];
// MySQL uhendus
$user="root";
$password="";
if ( isset($_REQUEST['sub']) ) {
$database = $_REQUEST['sub']; }
$con="localhost";
mysql_connect($con,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");

// Raamatupidaja andmete sisestamine
mysql_query("INSERT INTO admin(raamatupidaja_nimi, raamatupidaja_telefon, raamatupidaja_email, raamatupidaja_kasutaja, raamatupidaja_parool) VALUES ('$rnimi', '$rtel', '$remail', '$rkas', '$rpwd')");
mysql_close();
?>
<?php
ini_set('error_reporting', E_ALL);
// Töödejuhataja andmed
$animi = $_REQUEST['jnimi'];
$atel = $_REQUEST['jtel'];
$aemail = $_REQUEST['jemail'];
$akas = $_REQUEST['jkas'];
$apwd = $_REQUEST['jpwd'];
// MySQL uhendus
$user="root";
$password="";
if ( isset($_REQUEST['sub']) ) {
$database = $_REQUEST['sub']; }
$con="localhost";
mysql_connect($con,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");

// Juhataja tabeli tegemine
mysql_query("CREATE TABLE juhataja(id int(6) NOT NULL auto_increment,nimi varchar(50) NOT NULL,telefon varchar(50) NOT NULL,email varchar(50) NOT NULL,kasutaja varchar(50) NOT NULL,parool varchar(50) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))"); 
// Juhataja andmete sisestamine
mysql_query("INSERT INTO juhataja(juhataja_nimi, juhataja_telefon, juhataja_email, juhataja_kasutaja, juhataja_parool) VALUES ('$jnimi', '$jtel', '$jemail', '$jkas', '$jpwd')");
mysql_close();
?>
<?php
ini_set('error_reporting', E_ALL);
// Töölise andmed
$animi = $_REQUEST['tnimi'];
$atel = $_REQUEST['ttel'];
$aemail = $_REQUEST['temail'];
$akas = $_REQUEST['tkas'];
$apwd = $_REQUEST['tpwd'];
// MySQL uhendus
$user="root";
$password="";
if ( isset($_REQUEST['sub']) ) {
$database = $_REQUEST['sub']; }
$con="localhost";
mysql_connect($con,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");

// Töölise tabeli tegemine
mysql_query("CREATE TABLE tooline(id int(6) NOT NULL auto_increment,nimi varchar(50) NOT NULL,telefon varchar(50) NOT NULL,email varchar(50) NOT NULL,kasutaja varchar(50) NOT NULL,parool varchar(50) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))"); 
// Töölise andmete sisestamine
mysql_query("INSERT INTO tooline(toolise_nimi, toolise_telefon, toolise_email, toolise_kasutaja, toolise_parool) VALUES ('$tnimi', '$ttel', '$temail', '$tkas', '$tpwd')");
mysql_close();
?>

In that script add only database:

// Firma andmete sisestamine
mysql_query("INSERT INTO firma(firma_nimi, firma_reg, firma_telefon, firma_email, firma_www) VALUES ('$fnimi', '$reg', '$ftel', '$femail', '$fwww')");
mysql_close();
?>

How fix it?

Link to comment
https://forums.phpfreaks.com/topic/277304-why-save-database-ownly-one-field/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.