Jump to content

blmv

New Members
 View Profile  See their activity

  • Posts

    9

  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

blmv's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. blmv
    It made the table : Table 'felhasznalo' already exists
  2. blmv
    I need something like that, don't I ??? ... or require_once("Install.php"); $ab = new Install(); $ab->connect(); $ab->choose_database("adatok"); <?php class Install{ private $nev; private $jelszo; private $host; public $kapcsolat; public function Install($nev="root",$jelszo="",$host="localhost"){ $this->nev = $nev; $this->jelszo = $jelszo; $this->host = $host; } public function connect(){ $this->kapcsolat = mysql_connect($this->host,$this->nev,$this->jelszo) or die("Error: ".mysql_error()); } public function choose_database($abnev){ if(!(mysql_select_db($abnev,$this->kapcsolat))){ mysql_query("CREATE DATABASE `adatok` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;"); $this->tablakat_letrehoz(); mysql_select_db($abnev,$this->kapcsolat); } } private function tablakat_letrehoz(){ mysql_query("CREATE TABLE `adatok`.`felhasznalo`( `id` INT( 10 ) NOT NULL AUTO_INCREMENT , `nev` VARCHAR( 10 ) NOT NULL , `jelszo` VARCHAR( 10 ) NOT NULL , `szulev` YEAR NOT NULL , `nem` CHAR( 1 ) NOT NULL , `hobbi` VARCHAR( 100 ) NOT NULL , `szam` INT( 2 ) NOT NULL , `szoveg` VARCHAR( 100 ) NOT NULL , PRIMARY KEY ( `id` ))"); } } ?>
  3. blmv
    Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\install.php on line 5 Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in C:\xampp\htdocs\install.php on line 5 Nincs lĂŠtrehozva az adatbĂĄzis!
  4. blmv
    It didn't give back any table names.
  5. blmv
    It is still the same: Could not run query: Table 'adatok.felhasznalo' doesn't exist Something is wrong with the table and with the references..
  6. blmv
    I would like to login with a name(=nev) and a password(=jelszo). I need to check: that the two passwords are equal.
  7. blmv
    Yes, it looks like this: <?php mysql_query(" CREATE DATABASE `adatok` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; "); mysql_select_db("adatok") or die ("<p>Nincs letrehozva az adatbazis!</p>"); mysql_query(" CREATE TABLE `felhasznalo` ( `id` INT( 10 ) NOT NULL AUTO_INCREMENT , `nev` VARCHAR( 10 ) NOT NULL , `jelszo` VARCHAR( 10 ) NOT NULL , `szulev` YEAR NOT NULL , `nem` CHAR( 1 ) NOT NULL , `hobbi` VARCHAR( 100 ) NOT NULL , `szam` INT( 2 ) NOT NULL , `szoveg` VARCHAR( 100 ) NOT NULL , PRIMARY KEY ( `id` ) )ENGINE=MyISAM DEFAULT CHARSET=utf8; "); ?>
  8. blmv
    You were right: Could not run query: Table 'adatok.felhasznalo' doesn't exist Now the question is: where did it go wrong?? <body> <?php if(isset($_POST['send']) && trim($_POST['user1']) != "" && trim($_POST['pwd1']) != "" && trim($_POST['pwd2']) != ""){ $kapcsolat = mysql_connect("localhost", "root", ""); if (!$kapcsolat) { die ("<p>Nem lehet csatlakozni a MySQL kiszolgalohoz!</p>"); } mysql_select_db("adatok") or require_once("install.php"); $felh=mysql_fetch_row(mysql_query("select nev from felhasznalo where nev='".$_POST['user1']."'", $kapcsolat)); if (!$felh) { echo 'Could not run query: ' . mysql_error(); exit;} if($felh[0] == $_POST['user1']){ print "<div id=\"hibau\">Van ilyen felhasznalo!</div>"; $_POST['default']=true; }else if(trim($_POST['pwd1']) != trim($_POST['pwd2'])){ print "<div id=\"hibau\">Jelszo kulonbozo!</div>"; $_POST['default']=true; }else if(!is_numeric ($_POST['egyszam'])){ print "<div id=\"hibau\">Csak szamot irj!</div>"; $_POST['default']=true; }else{ if($_POST['hobbi']!=NULL){ $i=0; foreach($_POST['hobbi'] as $elem){ if ($i == 0 ) { $_POST['hobbik']=" $elem"; } else { $_POST['hobbik']=$_POST['hobbik'].", $elem"; } $i++; } }else{ $_POST['hobbik']=""; } if ($kapcsolat) { mysql_query("insert into felhasznalo(nev,jelszo,szulev,nem,hobbi,szam,szoveg) values('".$_POST['user1']."','".$_POST['pwd1']."','".$_POST['szulev']."','".$_POST['neme']."','".$_POST['hobbik']."','".$_POST['egyszam']."','".$_POST['bszoveg']."')", $kapcsolat); print "<div id=\"elfogadu\">Sikeres regisztracio!</div>"; }else{ die ("<p>Nem lehet csatlakozni a MySQL kiszolgalohoz!</p>"); } } mysql_close($kapcsolat); }else if(isset($_POST['send'])){ $_POST['default']=true; } if(isset($_POST['delete'])){ $kapcsolat = mysql_connect("localhost", "root", ""); if (!$kapcsolat) { die ("<p>Nem lehet csatlakozni a MySQL kiszolgalohoz!</p>"); } mysql_select_db("adatok") or require_once("install.php"); if ($kapcsolat) { mysql_query("delete from felhasznalo where nev='".$_POST['tazonosito']."'", $kapcsolat); print "<div id=\"elfogadu\">Torolve a(z) ".$_POST['tazonosito']." felhasznalo!</div>"; }else{ die ("<p>Nem lehet csatlakozni a MySQL kiszolgalohoz!</p>"); } mysql_close($kapcsolat); } if(isset($_POST['default']) || isset($_POST['add']) && (trim($_POST['user']) == "" || trim($_POST['pwd']) == "")){ print " <h1>Regisztracio</h1> <div id=\"figyu\">A csillagozottak kotelezok!</div> <form action=\"".$_SERVER["PHP_SELF"]."\" method=\"post\" id=\"reg\"> <p><label for=\"user1\">Azonosito *:<br /> <input type=\"text\" id=\"user1\" name=\"user1\" maxlength=\"10\" size=\"20\"/></label> </p> <p><label for=\"pwd1\">Jelszo *:<br /> <input type=\"password\" id=\"pwd1\" name=\"pwd1\" maxlength=\"10\" size=\"20\"/></label> </p> <p><label for=\"pwd2\">Jelszo ujra *:<br /> <input type=\"password\" id=\"pwd2\" name=\"pwd2\" maxlength=\"10\" size=\"20\"/></label> </p> <p><label for=\"szulev\">Szuletesi ev: <select id=\"szulev\" name=\"szulev\">"; for ($evszam = 1900; $evszam <= 2003; $evszam++){ print "<option value=\"$evszam\">$evszam</option>"; } print " </select></label> </p> <p> Nem: <label for=\"ferfi\">Ferfi <input type = \"radio\" name = \"neme\" id = \"ferfi\" checked = \"checked\" value = \"f\" /></label> <label for=\"no\">No <input type = \"radio\" name = \"neme\" id = \"no\" value = \"n\" /></label><br /> </p> <p> Hobbi: <br /><label for=\"vitorl\">Vitorlazas<input type=\"checkbox\" value=\"vitorlazas\" id=\"vitorl\" name=\"hobbi[]\"/></label> <br /><label for=\"sieles\">Sieles<input type=\"checkbox\" value=\"sieles\" id=\"sieles\" name=\"hobbi[]\"/></label> <br /><label for=\"ejtoerny\">Ejtoernyozes<input type=\"checkbox\" value=\"ejtoernyozes\" id=\"ejtoerny\" name=\"hobbi[]\"/></label> <br /><label for=\"salsa\">Salsa<input type=\"checkbox\" value=\"salsa\" id=\"salsa\" name=\"hobbi[]\"/></label> <br /><label for=\"gorkori\">Gorkorizas<input type=\"checkbox\" value=\"gorkorizas\" id=\"gorkori\" name=\"hobbi[]\"/></label> </p> <p><label for=\"egyszam\">Hany oraja netezik? <input type=\"text\" id=\"egyszam\" name=\"egyszam\" maxlength=\"2\" size=\"2\"/> </label></p> <p> <label for=\"bszoveg\"> Bemutatkozas: <br /> <textarea name=\"bszoveg\" id = \"bszoveg\" rows = \"4\" cols = \"20\"></textarea> </label> </p> <p> <input type=\"submit\" name=\"default\" value=\"Alapallapot\"/> <input type=\"submit\" name=\"send\" id=\"send\" value=\"Kuldes\"/> <input type=\"submit\" name=\"logout\" id=\"logout\" value=\"Vissza\" /></p> </form> "; }else if(isset($_POST['add'])){ $kapcsolat = mysql_connect("localhost", "root", ""); if (!$kapcsolat) { die ("<p>Nem lehet csatlakozni a MySQL kiszolgalohoz!</p>"); } mysql_select_db("adatok") or require_once("install.php"); $felh=mysql_fetch_row(mysql_query("select nev from felhasznalo where nev='".$_POST['user']."'", $kapcsolat)); $jels=mysql_fetch_row(mysql_query("select jelszo from felhasznalo where jelszo='".$_POST['pwd']."'", $kapcsolat)); $ev=mysql_fetch_row(mysql_query("select szulev from felhasznalo where nev='".$_POST['user']."'", $kapcsolat)); $neme=mysql_fetch_row(mysql_query("select nem from felhasznalo where nev='".$_POST['user']."'", $kapcsolat)); $szorak=mysql_fetch_row(mysql_query("select hobbi from felhasznalo where nev='".$_POST['user']."'", $kapcsolat)); $tipp=mysql_fetch_row(mysql_query("select szam from felhasznalo where nev='".$_POST['user']."'", $kapcsolat)); $bemut=mysql_fetch_row(mysql_query("select szoveg from felhasznalo where nev='".$_POST['user']."'", $kapcsolat)); if($felh[0] == $_POST['user'] && $jels[0] == $_POST['pwd']){ print " <h1>Szia </h1> <div id=\"leiras\"> Felhasznalonev: \"$felh[0]\".<br /> Jelszo: \"$jels[0]\".<br /> Szuletesi ev:"; if($ev[0]=="0000") print " 1900.<br />"; else print " $ev[0].<br />"; print " Nem: "; if($neme[0]=="f") print " ferfi.<br />"; else print " no.<br />"; print " Hobbi: "; if($szorak[0]=="") print " nincs.<br />"; else print " $szorak[0].<br />"; print " $tipp[0]-t irtad.<br /> A kovetkezot toltotted fel:<br /> $bemut[0] <br /> </div> <form action=\"".$_SERVER["PHP_SELF"]."\" method=\"post\" id=\"kilep\"> <p><input type=\"submit\" name=\"delete\" value=\"Felhasznalo torlese\" /> <input type=\"hidden\" name=\"tazonosito\" value=\"".$_POST['user']."\" /> <input type=\"submit\" name=\"logout\" value=\"Kilepes\" /></p> </form> "; }else{ print " <div id=\"hibau\">Nem sikerult belepni!<br /> </div> <h1>Bejelentkezes</h1> <form action=\"".$_SERVER["PHP_SELF"]."\" method=\"post\" id=\"bevitel\"> <p><label for=\"user\">Azonosito:<br /> <input type=\"text\" id=\"user\" name=\"user\" maxlength=\"10\" size=\"20\"/> </label></p> <p><label for=\"pwd\">Jelszo:<br /> <input type=\"password\" id=\"pwd\" name=\"pwd\" maxlength=\"15\" size=\"20\"/> </label></p> <p> <input type=\"submit\" name=\"add\" id=\"add\" value=\"Bejelentkezes/Regisztracio\"/> </p> </form> <form action=\"Fooldal.html\" method=\"post\" id=\"visszagomb\"> <p> <input type=\"submit\" name=\"back\" id=\"back\" value=\"Vissza a fooldalra\" /> </p> </form> "; } mysql_close($kapcsolat); }else{ print " <h1>Bejelentkezes</h1> <form action=\"".$_SERVER["PHP_SELF"]."\" method=\"post\" id=\"bevitel\"> <p><label for=\"user\">Azonosito:<br /> <input type=\"text\" id=\"user\" name=\"user\" maxlength=\"10\" size=\"20\"/> </label></p> <p><label for=\"pwd\">Jelszo:<br /> <input type=\"password\" id=\"pwd\" name=\"pwd\" maxlength=\"15\" size=\"20\"/> </label></p> <p> <input type=\"submit\" name=\"add\" id=\"add\" value=\"Bejelentkezes/Regisztracio\"/> </p> </form> <form action=\"Fooldal.html\" method=\"post\" id=\"visszagomb\"> <p> <input type=\"submit\" name=\"back\" id=\"back\" value=\"Vissza a fooldalra\" /> </p> </form> "; } ?>
  9. blmv
    Hi! I always got that warning: Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\regiszturlap.php on line 24 <?php mysql_query(" CREATE DATABASE `adatok` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; "); mysql_select_db("adatok") or die ("<p>Nincs letrehozva az adatbazis!</p>"); mysql_query(" CREATE TABLE `felhasznalo` ( `id` INT( 10 ) NOT NULL AUTO_INCREMENT , `nev` VARCHAR( 10 ) NOT NULL , `jelszo` VARCHAR( 10 ) NOT NULL , `szulev` YEAR NOT NULL , `nem` CHAR( 1 ) NOT NULL , `hobbi` VARCHAR( 100 ) NOT NULL , `szam` INT( 2 ) NOT NULL , `szoveg` VARCHAR( 100 ) NOT NULL , PRIMARY KEY ( `id` ) )ENGINE=MyISAM DEFAULT CHARSET=utf8; "); ?> $kapcsolat = mysql_connect("localhost", "root", ""); mysql_select_db("adatok") or require_once("install.php"); $felh=mysql_fetch_row(mysql_query("select nev from felhasznalo where nev='".$_POST['user1']."'", $kapcsolat)); // line 24 If I guess well, the problem is with the syntax , how should I fix it??? I would be really grateful for the help!
×
×
  • 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.