İlk önce size yazdığım procedure call u veriyorum

 

MYSQL 5 Procedure Call

DROP PROCEDURE `NewMember`//
CREATE DEFINER=`root`@`localhost` PROCEDURE `NewMember`(
	IN N_m_c_id TINYINT,
	IN N_m_s_id TINYINT,
	IN N_m_email VARCHAR(55),
	IN N_m_pass CHAR(32),
	IN N_m_name VARCHAR(14),
	IN N_m_gender CHAR(1),
	IN N_m_birthdate DATETIME,
	IN N_m_message VARCHAR(255),
	IN N_m_acode CHAR(6),
	OUT N_m_err TINYINT
)
BEGIN
	DECLARE name_exist TINYINT;
	DECLARE email_exist TINYINT;
	SET name_exist = 0;
	SET email_exist = 0;

		SELECT count(m_ID) INTO name_exist FROM members WHERE m_name = N_m_name LIMIT 0,1;

		SELECT count(m_ID) INTO email_exist FROM members WHERE m_email = N_m_email LIMIT 0,1;

	IF name_exist > 0 THEN
		SET N_m_err	= 1;
	ELSEIF email_exist > 0 THEN
		SET N_m_err	= 2;
	ELSE
		INSERT INTO members (m_ID, c_id, s_id, m_email, m_pass, m_name, m_gender, m_acode, m_status, m_datetime) VALUES (NULL, N_m_c_id, N_m_s_id, N_m_email, N_m_pass, N_m_name, N_m_gender, N_m_birthdate, N_m_message, N_m_acode, 0, NOW());
		SET N_m_err	= 0;
	END IF;
END

PHP kodu

<?
			$sql	= "CALL NewMember($c_id, $s_id, '$m_email', '$m_pass', '$m_name', '$m_gender', '$birthday', '$m_message', '$m_a_code', @out_pram)";
			$link = mysqli_connnect("localhost", "root", "", "dbname");
			mysqli_query($link, $sql);
			mysqli_query($link, "SELECT @out_param");
			$result = mysql_store_result($this->link);
			$row = mysqli_fetch_row($result);
			mysqli_free_result($result);
			mysqli_close($link);
			echo $row[0];
?>

Hata mesajları için: üyelik sistemi procedure calls yazıma bakabilirsiniz.