PHP php mysql / mysqli结果

function sqlResult( $query, $row=0, $field=0 )
{
  if( in_array( 'mysql', $GLOBALS[ 'loaded_extensions' ] ) )
  {
    return @mysql_result( $query, $row, $field );
  }
  elseif( in_array( 'mysqli', $GLOBALS[ 'loaded_extensions' ] ) )
  {
    if( mysqli_num_rows( $query ) )
    {
      $x = 0;

      while( $array = mysqli_fetch_array( $query, MYSQLI_NUM ) )
      {
        if( $row == $x++ )
        {
          return isset( $array[ $field ] )
            ? $array[ $field ]
            : '';
        }
      }
    }
  }
}

PHP php mysql / mysqli sql insert id

function sqlInsertID()
{
  if( in_array( 'mysql', $GLOBALS[ 'loaded_extensions' ] ) )
  {
    return @mysql_insert_id();
  }
  elseif( in_array( 'mysqli', $GLOBALS[ 'loaded_extensions' ] ) )
  {
    return @mysqli_insert_id( $GLOBALS[ 'dbHandle' ] );
  }
}

PHP php mysql / mysqli受影响的行

function sqlAffectedRows()
{
  if( in_array( 'mysql', $GLOBALS[ 'loaded_extensions' ] ) )
  {
    return @mysql_affected_rows();
  }
  elseif( in_array( 'mysqli', $GLOBALS[ 'loaded_extensions' ] ) )
  {
    return @mysqli_affected_rows( $GLOBALS[ 'dbHandle' ] );
  }
}

PHP PHP穷人的地穴

function encrypt( $string )
{
  $key = 'BXcfTYewQ';
  $result = '';
  for( $i = 1; $i <= strlen( $string ); $i++ )
  {
    $char = substr( $string, $i - 1, 1 );
    $keychar = substr( $key, ( $i % strlen( $key ) ) - 1, 1 );
    $char = chr( ord( $char ) + ord( $keychar ) );
    $result .= $char;
  }
  return $result;
}

function decrypt( $string )
{
  $key = 'BXcfTYewQ';
  $result = '';
  for( $i = 1; $i <= strlen( $string ); $i++ )
  {
    $char = substr( $string, $i - 1, 1 );
    $keychar = substr( $key, ( $i % strlen( $key ) ) - 1, 1);
    $char = chr( ord( $char ) - ord( $keychar ) );
    $result .= $char;
  }
  return $result;
}

PHP PHP年份选项

function getYearOptions( $selected, $offset, $count )
{
    $options = '';

    $start_year = date( 'Y' ) + $offset;

    $finish_year = $start_year + $count;

    for( $x = $start_year; $x <= $finish_year; $x++ )
    {
        if( strlen( $x ) == 1 ) $x = '0' . $x;

        $options .= '<option value="' . $x . '"';

        if( $x == $selected )
        {
            $options .= ' selected="selected"';
        }

        $options .= '>' . $x . '</option>';
    }

    return $options;
}

PHP 在阿帕奇改变所有者

chown root: /etc/udev/devices/nvidia8

PHP 语法heredoc

<?php
$str = <<<EOD
  Exemple de chaîne
  s'étalant sur
  plusieurs lignes
  avec la syntaxe heredoc
EOD;

/* Exemple plus complexe, avec des variables. */
class foo {
   var $foo;
   var $bar;
   function foo() {
       $this->foo = 'Foo';
       $this->bar = array('Bar1', 'Bar2', 'Bar3');
   }
}

$foo = new foo();
$name = 'MonNom';

echo <<<EOT
  Mon nom est "$name". J'affiche des $foo->foo.
  Maintenant, j'affiche un {$foo->bar[1]}.
  Ceci se traduit par un 'A' majuscule : \x41
EOT;
?>

PHP 将变量传递为隐藏

<?
/* Pass variable as hidden

Pass variable as hidden field
recursively handles array
eg usage: */

foreach ($_REQUEST as $key => $val) 
pass_hidden($key, $val);
 function pass_hidden($key, $val) {
  if (is_array($val)) {
    foreach ($val as $k => $v) 
      pass_hidden("{$key}[{$k}]", $v);
  } else {
    ?><input type="hidden" name="<?=$key?>" value="<?=htmlspecialchars($val)?>">
    <?
  }
}
?>

PHP codigo para postgresql

<?php

$dbconn = pg_connect("host=localhost dbname=test user=postgres password=laclave")
   or die('Could not connect: ' . pg_last_error());


// Performing SQL query
$query = 'SELECT * FROM person';
$result = pg_query($query) or die('Query failed: ' . pg_last_error());


// Printing results in HTML
echo "<table>\n";
while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {
   echo "\t<tr>\n";
   foreach ($line as $col_value) {
       echo "\t\t<td>$col_value</td>\n";
   }
   echo "\t</tr>\n";
}
echo "</table>\n";

// Free resultset
pg_free_result($result);

// Closing connection
pg_close($dbconn);
//echo "col_value=".$col_value."result=".$result;
?>

PHP PHPBBForumlarındaKullanıcılarıŞifresiniTopluHalde Resetlemek

<?
function md5pass($totalChar,&$password,&$clean)
{
// *******************************
// Random Password Generator-Start
// *******************************
//$totalChar = 8; // number of chars in the password
$salt = "abcdefghijklmnpqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ123456789";  // salt to select chars from
srand((double)microtime()*1000000); // start the random generator
$password=""; // set the inital variable
for ($i=0;$i<$totalChar;$i++)  // loop and create password
            $password = $password . substr ($salt, rand() % strlen($salt), 1);
$clean = $password;
$password = md5($password);
// *****************************
// Random Password Generator-End
// *****************************
}
mysql_connect("localhost","user","password") or die("mysql e bağlanamadık");
mysql_select_db("phpbb") or die("veritabanını seçilemedi");
mysql_query('CREATE TABLE IF NOT EXISTS `yedek` ( `user_id` MEDIUMINT( 8 ) NOT NULL , `user_password` VARCHAR( 32 ) NOT NULL , `user_newpassword` VARCHAR( 32 ) NOT NULL , UNIQUE ( `user_id` ) ) CHARACTER SET = utf8;'); //yedek tablosu - user id - eski sifre - yeni sifreyi icerecek
$sql = mysql_query('SELECT `user_id` , `user_password` , `username` FROM `phpbb_users`');
$id = mysql_num_rows($sql);
	echo "<table border=1><tr><td><b>User ID</b></td><td><b>Kullanıcı Adı</b></td><td><b>Eski Sifre(MD5)</b></td><td><b>Yeni Sifre(MD5)</b></td><td><b>Acik Sifre</b></td></tr>";
while($id > 0)
{
	$ulist = mysql_fetch_array($sql,MYSQL_NUM);
	$userid = $ulist[0];
	$oldpass = $ulist[1];
	$username = $ulist[2];
	md5pass("8",$password,$clean);
	if ($userid == -1)
	{
		$password = ""; //Anonim Hesap
		$clean = $password;
	}
	if ($userid == 2)
	{
		$password = "adminpass"; //Admin sifresi(her ihtimale karsi)
		$clean = $password;
		$password = md5("$password");
	}
	mysql_query("REPLACE INTO `yedek` ( `user_id` , `user_password`, `user_newpassword` ) VALUES ('".$ulist[0]."', '".$ulist[1]."', '".$password."')"); //eski sifreler her ihtimale karsi yedek
	mysql_query("UPDATE `phpbb_users` SET `user_password` = '".$password."' WHERE `user_id` = '".$ulist[0]."'");
	echo "<tr><td align='center'>".$userid."</td><td align='center'>".$username."</td><td>".$oldpass."</td><td>".$password."</td><td>".$clean."</td></tr>";
	$id--;
}
echo "</table>";
?>