PHP user add script werkt niet!!

Status
Niet open voor verdere reacties.
M

msyuser

Gebruiker
Lid geworden
22 jan 2014
Berichten
53
Hallo allemaal.

Ik heb Volgens een reeks tutorials over hoe je een forum maakt via PHP & mySQl alle stappen gevolgd en de broncode en alle files gecontroleerd maar zodra ik een username en password en email adres intyp in de login script dan krijg ik de melding "OK!!" ipv succes of failed. Ook als ik terug ga naarde DB om te kijken of tie heeft opgeslagen zit ik niets terug van wat ik heb ingevuld. kan iemand me helpen miss??

Code: 
<?php

	if(!isset($_POST['username']) || (!isset($_POST['password'])) || (!isset($_POST['email'])))
		die('No Access!!');
	

	require_once('db.php');
	require_once('userAPI.php');


	$result = mf_users_add($_POST['username'],$_POST['password'],$_POST['email'],0);
	mfconn_close();

	if($result)
		die('succes!!');
	else 
		die('Failed!!');

?>
 
Zoek even in je code naar de plek waar "OK!!" voortkomt. Waarschijnlijk direct gevolgd door een "exit();". Verwijder die regel(s) en je komt weer een stukje verder schat ik.
 
Krijg je geen foutmeldingen ?
Zijn foutmeldingen ingeschakeld ?
Wordt er wel verbinding gemaakt met de database ?

Wanneer ik het zo inschat komt het probleem uit de functie "mf_users_add()", hoe ziet de sourcecode van deze functie er uit ?
 
Dit zijn alle codes tot nu toe.
PHP: 
<!DOCTYPE html>
	<html>

		<head>
				<title>ITedu | Login Forum</title>

				<style type="text/css">
				*
				{
					font-family: "Georgia";
					font-size: 14px;
				}

				form
				{
					margin: 250px 0px 0px 400px;
					position: absolute;			
				}

				.inputusr
				{
					width: 150px;
					height: 25px;
					padding: 2px;
					opacity: 0.7;
					transition:0.4s;
					left: 20px;
					box-shadow: inset 0 0 0px 1px #eee;
				}

				.inputusr:hover
				{
					opacity: 1;
					box-shadow: inset 0 0 1px 1px #ccc;
					color: #000;
					border:1px solid #ccc;
				}

				.button
				{
					height: 33px;
					padding: 0px;
					position: relative;
					line-height: 33px;
					background: #000;
					border: transparent;
					color: #fff;
					width: 50px;
					opacity: 0.7;
					transition:1s;
				}

				.button:hover
				{
					opacity: 1;
				}

				.inputusr, .button
				{
					border-radius: 4px;
					border: 1px solid #ccc;
				}
				footer
				{
					width: 100%;
					height:40px;
					line-height: 40px;
					position: fixed;
					bottom: 0px;
					margin: 0px auto;
					background: #000;
					left: 0;
					color: #fff;
					text-align: center;
				}
				

				</style>

		</head>

		<body>
		
			<form action="login_.php" method="post" >
				<input type="text" name="username" placeholder="Your username" class="inputusr" />
				<input type="password" name="password" placeholder="Your Password" class="inputusr" />
				<input type="email" name="email" placeholder="Your Email" class="inputusr" />
				<button type="login" name="submit" class="button">Login</button>

			</form>

			<footer>All rights are saved</footer>
		</body>



	</html>

PHP: 
<?php

//info host and dbserver

$mf_host = 'localhost';
$mf_user = '[user]';
$mf_password = '[password]';
$mf_dbname = '[dbname]';

//connect with the db/dbserver

$mf_handle = mysql_connect($mf_host,$mf_user,$mf_password);
	if (!$mf_handle) {
		die('connection failed!');
	}

	else
		die('It works!!');
	/*
	else
	{
		echo 'connection with DB is succesfull!!';
		break;
	}
	*/
	//if connection with db is not succesfulld close the conection
$mf_db_result = mysql_select_db($mf_dbname);
	if(!$mf_db_result)
	{
		@mysql_close($mf_handle);
		die('selection problem');
	}
	//this is possible or the fun on line 16
	/*
die('OK!!');
@mysql_close($mf_handle);
*/

@mysql_query("SET NAMES 'UTF8'");
//this  allows php understand arabic letters

function mfconn_close()
	{
		global $mf_handle;
		//global be used to import a function outside the current function
		//or glabals['tf_handle'];
		@mysql_close($mf_handle);
	}
mfconn_close();

?>

PHP: 
<?php

	if(!isset($_POST['username']) || (!isset($_POST['password'])) || (!isset($_POST['email'])))
		die('No Access!!');
	

	require_once('db.php');
	require_once('userAPI.php');


$result = mf_users_add($_POST['username'],$_POST['password'],$_POST['email'],0);
mfconn_close();

if($result)
	die('succes!!');
else 
	die('Failed!!');

?>

PHP: 
<?php
//users API

	
	function mf_users_get($extra = '')
	{
		global $mf_handle;
		$ex = strip_tags($extra); //to remove extra and unused HTML tags
		$mf_query = sprintf("SELECT * FROM `users` %s", $extra);
		$mf_query_result = @mysql_query($mf_query);

		if(!$mf_query_result)
			return null;

		$rcount = @mysql_num_rows($mf_query_result);
		if($rcount == 0)
			return null;

		//this function to import a row of users from the db
		$users = array();
		for ($i=0; $i < $rcount; $i++) 
		{ 

			/*$users = @mysql_fetch_object(@mf_query_result);	
			$users[@count($users)] = @mysql_fetch_object(@mf_query_result);	
			*/
			$users[@count($users)] = @mysql_fetch_object($mf_query_result);
		}

		@mysql_free_result($mf_query_result);
		return $users;
	}

	function mf_get_users_byID($uid)
	{
		$id = (int)$uid;
		if($id == 0)
			return NULL;


		$result = my_forum_users_get("WHERE `id` =".$id);
		if ($result == NULL) 
			return NULL;

		$user = $result[0];
		return $user;
	}

	function mf_users_add($name, $password, $email, $isadmin)
	{
		global $mf_handle;
		if((empty($name)) || (empty($password)) || (empty($email)) || empty($isadmin))
			return false;

		$new_name       = @mysql_real_escape_string(strip_tags($name), $mf_handle);
		$new_email      = @mysql_real_escape_string(strip_tags($email), $mf_handle);
		$new_isadmin    = (int)$isadmin; 
		$new_pass   = @md5(mysql_real_escape_string(strip_tags($password), $mf_handle));
		//md5 be used to encrypt the password when the user want to login in the system

		$mf_query       = sprintf("INSERT INTO `users` VALUE(NULL,'%s','%s','%s', %d)", $new_name, $new_pass, $new_email, $new_isadmin);

		$mf_query_result      = @mysql_query($mysql_query);
		if(!$mf_query_result)
		
			return false;
				
		else
		
			return true;
		
				
	}

	function mf_users_delete($uid)
	{
			$id = (int)$uid;
			if($id == 0)
				return false;

			$mf_query = sprintf("DELETE FROM `users` WHERE `id` = %d, $id");

			$mf_query   = @mysql_query($mysql_query);
			if (!$mf_query_result)
			return false;

		return true;	
	}

	function mf_users_update($uid, $name = NULL, $password = NULL, $email = NULL, $isadmin = 0)
	{

			global $mf_handle;
			$id = (int)$uid;
			if($id == 0)
				return false;

			$new_isadmin = (int)isadmin;
			$user = mf_get_users_byID($id);
			if(!$user)
			{
				return false;
			}
			if((empty($name)) && (empty($password)) && (empty($email)) && ($user->isadmin == $new_isadmin))
			
				return false;

			$fields = array();
			$mf_query = 'UPDATE `users` SET';
			if (!empty($name))
			{
				$new_name = @mysql_real_escape_string(strip_tags($name), $mf_handle);
				$fields[@count($fields)] = "`name` = '$new_name'";
			}

			if (!empty($password))
			{
				$new_pass = @md5(mysql_real_escape_string(strip_tags($name), $mf_handle));
				$fields[@count($fields)] = "`password` = $new_pass";
			}

			if (!empty($email))
			{
				$new_name = @mysql_real_escape_string(strip_tags($email), $mf_handle);
				$fields[@count($fields)] = "`name` = '$new_email'";
			}


			$fields[@count($fields)] = "`isadmin` = $new_isadmin";

			$fcounf = @count($fields);
			if ($fcounf == 1)
			{
				$mf_query .= $fields[0].'WHERE `id` = '.$id;
				$mf_query_result = @mysql_query($mf_query);
					if (!$mf_query)
							return false; 
					else
							return true;				
			}

			for ($i=0; $i < fcount; $i++)
			{ 
				$mf_query .=$fields[$i];
				if ($i == ($fcount - 1)) 	
					$mf_query .=' , ';
							
			}

			$mf_query .= 'WHERE `id` ='.$id;
			$mf_query_result = @mysql_query(@mf_query);
			if(!mf_query_result)
				return false;
			else
				return true;


	}
/*
$mf_query_result = mf_users_add('Aboubakr', 'user1234', 'abb@live.nl', 1);
*/

		function mf_users_get_byName($name);
?>

De bedoeling nu is dat ik succes te zien zou krijgen ipv ok!! en dat ik de ingevoerde gegevens in de DB te zien zou krijgen??
 
Laatst bewerkt door een moderator:
Status
Niet open voor verdere reacties.
                    Steun ons                    

Nieuwste berichten

Terug
Bovenaan Onderaan