Visualizza post
Questa sezione ti permette di visualizzare tutti i post inviati da questo utente. N.B: puoi vedere solo i post relativi alle aree dove hai l'accesso.
<?php
$host="localhost"; // Host name
$username="username"; // Mysql username
$password="password"; // Mysql password
$db_name="name"; // Database name
$tbl_name="table"; // Table name
// Connect to server and select the databse.
mysql_connect("$host", "$jsusername", "$jspassword")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// jsusername and jspassword sent from form in main_login
$jsusername=$_POST['jsusername'];
$password=$_POST['jspassword'];
// protect MySQL injection
$jsusername = stripslashes($jsusername);
$jspassword = stripslashes($jspassword);
$jusername = mysql_real_escape_string($jusername);
$jspassword = mysql_real_escape_string($jspassword);
// encrypt password
$parts = explode( ':', $jspassword );
$salt = $parts[1];
$encrypted_password=md5($jspassword.$salt);
//echo $encrypted_password;
// To protect MySQL injection (more detail about MySQL injection)
$jsusername = stripslashes($jsusername);
$jspassword = stripslashes($jspassword);
$jsusername = mysql_real_escape_string($jsusername);
$jspassword = mysql_real_escape_string($jspassword);
$sql="SELECT * FROM $tbl_name WHERE login='$jsusername' and password='$jspassword'";
$result = mysql_query($sql) or die(mysql_error());
// Mysql_num_row counting table row now
if ($result)
$count = mysql_num_rows($result);
else
$count = 0;
{
// Register $jsusername, $mypassword and redirect to file "login_success.php"
session_register("jsusername");
session_register("jspassword");
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?><?php
$db = JFactory::getDBO();
?>Come va modificato? Così:<?php
$username = JFactory::getDBO();oppure in un altro modo?Fatal error: Out of memory (allocated 0) (tried to allocate 416936608 bytes) in Unknown on line 0Ho provato ad inserire nel file index.php di Joomla la seguente stringa di codice:
ini_set('memory_limit', '512M');Il problema sembra essere risolto in Firefox e Internet Explorer, mentre su Chrome e Safari continuo a vedere quell'errore, come posso risolverlo??
<?php
$host="localhost"; // Host name
$username="*****"; // Mysql username
$password="****"; // Mysql password
$db_name="******"; // Database name
$tbl_name="jos_users"; // Table name ( Jomsocial mi da questa tabella)
// Connect to server and select the databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// username and password sent from form in main_login
$username=$_POST['username'];
$password=$_POST['password'];
// protect MySQL injection
$username = stripslashes($username);
$password = stripslashes($password);
$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);
// encrypt password
$parts = explode( ':', $password );
$salt = $parts[1];
$encrypted_password=md5($password.$salt);
//echo $encrypted_password;
// To protect MySQL injection (more detail about MySQL injection)
$username = stripslashes($username);
$password = stripslashes($password);
$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);
$sql="SELECT * FROM $tbl_name WHERE login='$username' and password='$password'";
$result = mysql_query($sql) or die(mysql_error());
// Mysql_num_row counting table row now
if ($result)
$count = mysql_num_rows($result);
else
$count = 0;
{
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("username");
session_register("password");
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>
|
|