Habe schon seit mehreren Tagen probleme mit dem Login meiner Hompage.
Habe nun den Hoster gewechselt von Fpic auf bplaced.
Zu meinem Problem Habe eine PHP Page mit wechselnden Header je nachdem ob der User eingeloggt ist oder nicht. Hat auch alles bis jetz super Funktioniert aber ich vermute mal der Connectet hier irgentwie nicht auf mein Msql. Natürlich wurden alle Links auf den neuen hoster aktualisiert.Der Header geht halt wenn man die login daten eigegeben hat einfach nicht weiter, wo eigentlich das Dropdown menü erscheinen müsste, hier mal der Code .
der connect to mysql script
[code]<?php
$db_host = “localhost”;
$db_username = “xxxxx”;
$db_pass = "xxxxxxx;
$db_name = “xxxxxxx”;
// Run the connection here
@mysql_connect("$db_host","$db_username","$db_pass") or die (“could not connect to mysql”);
@mysql_select_db("$db_name") or die (“no database”);
?>[/code]
Login script
[code]<?php
if ($_POST[‘email’] != “”) {
include_once “connect_to_mysql.php”;
$email = $_POST[‘email’];
$pass = $_POST[‘pass’];
$email = strip_tags($email);
$pass = strip_tags($pass);
$email = mysql_real_escape_string($email);
$pass = mysql_real_escape_string($pass);
$email = eregi_replace("", "", $email); $pass = eregi_replace("", “”, $pass);
$pass = md5($pass);
$sql = mysql_query(“SELECT * FROM myMembers WHERE email=’$email’ AND password=’$pass’ AND email_activated=‘1’”);
$login_check = mysql_num_rows($sql);
if($login_check > 0){
while($row = mysql_fetch_array($sql)){
$id = $row["id"];
session_register('id');
$_SESSION['id'] = $id;
$firstname = $row["firstname"];
session_register('firstname');
$_SESSION['firstname'] = $firstname;
$email = $row["email"];
session_register('email');
$_SESSION['email'] = $email;
mysql_query("UPDATE myMembers SET last_log_date=now() WHERE id='$id'");
$my_msg = "all_good";
print "return_msg=$my_msg&id=$id&firstname=$firstname";
} // close while
} else {
$my_msg = “no_good”;
print “return_msg=$my_msg”;
exit();
}
}// close if post
?>[/code]
Hier der Action script des headers
[code]stop();
//email_txt.tabIndex = 1;
//password_txt.tabIndex = 2;
//sumbit_btn.tabIndex = 3;
////////////
// Assign a variable name for our URLVariables object
var variables:URLVariables = new URLVariables();
// Build the varSend variable
var varSend:URLRequest = new URLRequest(“http://koschy.bplaced.net/scripts/login.php”);
varSend.method = URLRequestMethod.POST;
varSend.data = variables;
// Build the varLoader variable
var varLoader:URLLoader = new URLLoader;
varLoader.dataFormat = URLLoaderDataFormat.VARIABLES;
varLoader.addEventListener(Event.COMPLETE, completeHandler);
// Handler for PHP script completion and return
function completeHandler(event:Event):void{
status_txt.text ="";
if (event.target.data.return_msg == "no_good") {
status_txt.text = "No match in our records, please try again";
} else if (event.target.data.return_msg == "all_good") {
var reloadPage:URLRequest = new URLRequest("javascript:NewWindow=window.location.reload(); NewWindow.focus(); void(0);");
navigateToURL(reloadPage, "_self");
}
}
// Add an event listener for the submit button and what function to run
submit_btn.addEventListener(MouseEvent.CLICK, ValidateAndSend);
// Validate form fields and send the variables when submit button is clicked
function ValidateAndSend(event:MouseEvent):void{
status_txt.text ="";
//validate form fields
if(!email_txt.length) {
status_txt.text = "Please enter your email address.";
} else if(!password_txt.length) {
status_txt.text = "Please enter your password.";
} else {
// Ready the variables for sending
variables.email = email_txt.text;
variables.pass = password_txt.text;
// Send the data to the php file
varLoader.load(varSend);
status_txt.text = "Processing...";
} // close else after form validation
} // Close ValidateAndSend function //////////////////////////////////////////////////////////////
[/code]
