Click here to Skip to main content
15,888,286 members
Home / Discussions / Web Development
   

Web Development

 
QuestionGathering user computer information via web part/page Pin
BrentW824-Nov-13 6:15
BrentW824-Nov-13 6:15 
QuestionDisable Ajax Load On Wordpress Post Pin
Member 102891603-Nov-13 7:02
Member 102891603-Nov-13 7:02 
Questionhow to override the DC.title? Pin
Jassim Rahma3-Nov-13 0:22
Jassim Rahma3-Nov-13 0:22 
Questionbest way to save and use date Pin
Jassim Rahma2-Nov-13 1:08
Jassim Rahma2-Nov-13 1:08 
AnswerRe: best way to save and use date Pin
Richard MacCutchan2-Nov-13 6:02
mveRichard MacCutchan2-Nov-13 6:02 
GeneralRe: best way to save and use date Pin
Jassim Rahma2-Nov-13 7:28
Jassim Rahma2-Nov-13 7:28 
GeneralRe: best way to save and use date Pin
Richard MacCutchan2-Nov-13 7:40
mveRichard MacCutchan2-Nov-13 7:40 
Questionwhy getting: argument for routine is not a variable?! Pin
Jassim Rahma1-Nov-13 23:29
Jassim Rahma1-Nov-13 23:29 
Hi,

I am trying to get an INOUT parameter from MySQl using PHP and PDO but getting:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1414 OUT or INOUT argument 2 for routine xoompage.sp_send_password_reset is not a variable or NEW pseudo-variable in BEFORE trigger' in C:\xampp\htdocs\xoompage\password_reset.php:17 Stack trace: #0 C:\xampp\htdocs\xoompage\password_reset.php(17): PDOStatement->execute() #1 {main} thrown in C:\xampp\htdocs\xoompage\password_reset.php on line 17


here is MySQL sp:

SQL
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_send_password_reset`(IN param_member_guid varchar(255), INOUT param_password_reset_guid varchar(255))
BEGIN
	DECLARE param_password_reset_guid varchar(255);
	
	SET param_password_reset_guid = UUID();

	UPDATE members SET password_reset_guid = param_password_reset_guid, password_reset_date = DATE(NOW()) WHERE member_guid = param_member_guid;

END


and this is the PHP:

PHP
$mysql_query = $mysql_connection->prepare("CALL sp_send_password_reset(:param_member_guid, :param_password_reset_guid)");
$mysql_query->bindParam(':param_member_guid', $_SESSION["member_guid"], PDO::PARAM_STR);
$mysql_query->bindParam(':param_password_reset_guid', $password_reset_guid, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 4000);

$mysql_query->execute();



Technology News @ www.JassimRahma.com

QuestionMVC4 Ajax Call does not reach controller Pin
MYSHKSL1-Nov-13 10:43
MYSHKSL1-Nov-13 10:43 
SuggestionRe: MVC4 Ajax Call does not reach controller Pin
Richard Deeming1-Nov-13 10:51
mveRichard Deeming1-Nov-13 10:51 
Questionhow to header("Expires") in php Pin
Jassim Rahma1-Nov-13 8:42
Jassim Rahma1-Nov-13 8:42 
QuestionUndefined index for $_SESSION variable Pin
Jassim Rahma1-Nov-13 8:33
Jassim Rahma1-Nov-13 8:33 
AnswerRe: Undefined index for $_SESSION variable Pin
Peter Leow4-Nov-13 1:31
professionalPeter Leow4-Nov-13 1:31 
QuestionHow to rebind more three RadGrid after close the RadWindow Pin
Rahul_Pandit1-Nov-13 2:09
Rahul_Pandit1-Nov-13 2:09 
SuggestionRe: How to rebind more three RadGrid after close the RadWindow Pin
Richard Deeming1-Nov-13 3:07
mveRichard Deeming1-Nov-13 3:07 
QuestionHow to create a online service conversion of a file type to another type Pin
Moneyzz Sharma31-Oct-13 20:13
Moneyzz Sharma31-Oct-13 20:13 
AnswerRe: How to create a online service conversion of a file type to another type Pin
Richard MacCutchan31-Oct-13 23:52
mveRichard MacCutchan31-Oct-13 23:52 
GeneralRe: How to create a online service conversion of a file type to another type Pin
Moneyzz Sharma2-Nov-13 0:35
Moneyzz Sharma2-Nov-13 0:35 
SuggestionRe: How to create a online service conversion of a file type to another type Pin
Richard MacCutchan2-Nov-13 0:41
mveRichard MacCutchan2-Nov-13 0:41 
QuestionGet panel values Pin
vkEE31-Oct-13 3:45
vkEE31-Oct-13 3:45 
Questionis the $_GET exists? Pin
Jassim Rahma30-Oct-13 1:13
Jassim Rahma30-Oct-13 1:13 
AnswerRe: is the $_GET exists? Pin
Richard MacCutchan30-Oct-13 2:10
mveRichard MacCutchan30-Oct-13 2:10 
AnswerRe: is the $_GET exists? Pin
Peter Leow4-Nov-13 1:35
professionalPeter Leow4-Nov-13 1:35 
AnswerRe: is the $_GET exists? Pin
Killzone DeathMan9-Jan-14 1:08
Killzone DeathMan9-Jan-14 1:08 
QuestionSVG in IE8 Pin
ThetaClear29-Oct-13 11:12
ThetaClear29-Oct-13 11:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.