PCTuning fórum

Kód: Vybrat vše

$zaznamy = mysql_query("SELECT * FROM zensky WHERE nick=".$_POST["nick"]);

Kód: Vybrat vše

<form method="post" action="<?php echo $_SERVER["PHP_SELF"]?>"> 
Nick: <input name="nick"> 
<input type="Submit" name="odesli"> 
</form> 

<?php 

$sql_server = ("");
$sql_user = ("");
$sql_password = ("");
$sql_database = ("");

if($_POST['odesli']) 
	{ 
		@mysql_pconnect($sql_server, $sql_user, $sql_password) or die("Nelze se připojit k databázi.");
		@mysql_select_db($sql_database) or die("Nelze se připojit k databázi.");
		$sql_dotaz = "SELECT * FROM test WHERE nick = '".$_POST['nick']."'";
		$dotaz = mysql_query($sql_dotaz) or exit (mysql_error());																					  
		$zaznam = @mysql_fetch_array($dotaz); 
		echo $zaznam['heslo']; 	
	} 
?>

Kód: Vybrat vše

-- 
-- Struktura tabulky `test`
-- 

CREATE TABLE `test` (
  `id` int(11) NOT NULL auto_increment,
  `nick` varchar(20) NOT NULL default '',
  `heslo` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

-- 
-- Vypisuji data pro tabulku `test`
-- 

INSERT INTO `test` VALUES (1, 'pct', 'pct');

Kód: Vybrat vše

<?
if ($_SERVER["SERVER_ADDR"]=="127.0.0.1")
{
  define("SQL_HOST","localhost");
  define("SQL_DBNAME","new_db");
  define("SQL_USERNAME","root");
  define("SQL_PASSWORD","tady mam heslo");
}
else

{
  define("SQL_HOST","mysql.nekde.cz");
  define("SQL_DBNAME","databaze_u_providera");
  define("SQL_USERNAME","user2");
  define("SQL_PASSWORD","password2");
}
?>

Kód: Vybrat vše

<?
If (!empty($_POST))
{
	include ("config.php");
	mysql_connect(SQL_HOST, SQL_USERNAME, SQL_PASSWORD) or die("Nelze se připojit k MySQL: " . mysql_error());
	mysql_select_db(SQL_DBNAME) or die("Nelze vybrat databázi: ". mysql_error());
	$sql_dotaz = "SELECT * FROM zensky WHERE nick = '".$_POST['nick']."'";
        $dotaz = mysql_query($sql_dotaz) or exit (mysql_error());                                                           
        $zaznam = @mysql_fetch_array($dotaz);
        echo $zaznam['heslo'];     
}
?>

Kód: Vybrat vše

CREATE TABLE `zensky` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`nick` VARCHAR( 20 ) NOT NULL ,
`heslo` VARCHAR( 32 ) NOT NULL ,
PRIMARY KEY ( `id` ) 
) TYPE = MYISAM ;

Kód: Vybrat vše

INSERT INTO `zensky` ( `id` , `nick` , `heslo` ) 
VALUES (
'', 'pct', 'pct'
);

Kód: Vybrat vše

<?php

  define("SQL_HOST","xxx"); 
  define("SQL_DBNAME","xxx"); 
  define("SQL_USERNAME","xxx"); 
  define("SQL_PASSWORD","xxx");
  
?>

Kód: Vybrat vše

<form method="post" action="<?php echo $_SERVER["PHP_SELF"]?>"> 
Nick: <input name="nick"> 
<input type="Submit" name="odesli"> 
</form>
<?php 
if($_POST['odesli']) 
{ 
   include ("./config.php"); 
   mysql_connect(SQL_HOST, SQL_USERNAME, SQL_PASSWORD) or die("Nelze se pøipojit k MySQL: " . mysql_error()); 
   mysql_select_db(SQL_DBNAME) or die("Nelze vybrat databázi: ". mysql_error()); 
   $sql_dotaz = "SELECT * FROM zensky WHERE nick = '".$_POST['nick']."'"; 
   $dotaz = mysql_query($sql_dotaz) or exit (mysql_error());                                                            
   $zaznam = @mysql_fetch_array($dotaz); 
   echo $zaznam['heslo'];      
} 
?>

Kód: Vybrat vše

if(isset($_POST['odesli']))

Kód: Vybrat vše

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; Error handling and logging ;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

; error_reporting is a bit-field.  Or each number up to get desired error
; reporting level
; E_ALL             - All errors and warnings (doesn't include E_STRICT)
; E_ERROR           - fatal run-time errors
; E_WARNING         - run-time warnings (non-fatal errors)
; E_PARSE           - compile-time parse errors
; E_NOTICE          - run-time notices (these are warnings which often result
;                     from a bug in your code, but it's possible that it was
;                     intentional (e.g., using an uninitialized variable and
;                     relying on the fact it's automatically initialized to an
;                     empty string)
; E_STRICT          - run-time notices, enable to have PHP suggest changes
;                     to your code which will ensure the best interoperability
;                     and forward compatibility of your code
; E_CORE_ERROR      - fatal errors that occur during PHP's initial startup
; E_CORE_WARNING    - warnings (non-fatal errors) that occur during PHP's
;                     initial startup
; E_COMPILE_ERROR   - fatal compile-time errors
; E_COMPILE_WARNING - compile-time warnings (non-fatal errors)
; E_USER_ERROR      - user-generated error message
; E_USER_WARNING    - user-generated warning message
; E_USER_NOTICE     - user-generated notice message
;
; Examples:
;
;   - Show all errors, except for notices and coding standards warnings
;
;error_reporting = E_ALL & ~E_NOTICE
;
;   - Show all errors, except for notices
;
;error_reporting = E_ALL & ~E_NOTICE | E_STRICT
;
;   - Show only errors
;
;error_reporting = E_COMPILE_ERROR|E_ERROR|E_CORE_ERROR
;
;   - Show all errors, except coding standards warnings
;
error_reporting  =  E_ALL