|
|
Hi,
I am trying to OUTPUT using PDO and MySQL but getting this error:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1414 OUT or INOUT argument 7 for routine bizcards.sp_subscribe is not a variable or NEW pseudo-variable in BEFORE trigger' in /home/meskholdings/aromaexpress/web/send_subscription.php:27 Stack trace: #0 /home/meskholdings/aromaexpress/web/send_subscription.php(27): PDOStatement->execute() #1 {main} thrown in /home/meskholdings/aromaexpress/web/send_subscription.php on line 27
this is my code:
$mysql_query = $mysql_connection->prepare('CALL sp_subscribe(:param_first_name, :param_last_name, :param_birthday, :param_mobile, :param_email, :param_created_ip, :param_promotion_code)');
$mysql_query->bindParam(':param_first_name', $first_name, PDO::PARAM_STR);
$mysql_query->bindParam(':param_last_name', $last_name, PDO::PARAM_STR);
$mysql_query->bindParam(':param_birthday', $borthday, PDO::PARAM_STR);
$mysql_query->bindParam(':param_mobile', $mobile_number, PDO::PARAM_STR);
$mysql_query->bindParam(':param_email', $email_address, PDO::PARAM_STR);
$mysql_query->bindParam(':param_created_ip', $_SERVER['REMOTE_ADDR'], PDO::PARAM_STR);
$mysql_query->bindParam(':param_promotion_code', $promotion_code, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT);
$mysql_query->execute();
$data = $promotion_code;
Thanks,
Jassim[^]
Technology News @ www.JassimRahma.com
|
|
|
|
|
I have a 50 Websites and these websites have one common page named enquiry.html these are static websites. i want to add a single line of code on these 50 websites simultaneously via js, jquery or php is there any way?
I want to add a code on these website so that it will take a few minutes .
PLz reply with example or demo.
|
|
|
|
|
Message Closed
modified 9-Apr-15 11:24am.
|
|
|
|
|
Imagine you have a bunch of photos and you want to share them. Its a just random photos taken from mobile phone (Landscape and normal ). You want to upload all that photos on one page. That page will just have the photos of you nothing else. (No links, text anything ).
Something like this
( no matter i can go through ftp and upload photos but i want them to looks like this ) this is example for few photos
Picture[^]
|
|
|
|
|
What is your question?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
How to make something like this ?
|
|
|
|
|
t3cho wrote: How to make something like this ? That depends on where the information is stored and how it is displayed: Web page, Windows Form, Mobile/Tablet etc.
|
|
|
|
|
I will add those photos once. I can go through code or ftp or any other way.
Its something like portolio. Those pictures will be added just once.
|
|
|
|
|
But the issue is how you display them. Is this to be on a Web page or something else?
|
|
|
|
|
|
|
Please...Is there any way that I can find web host on free??...
|
|
|
|
|
Yes: google!
Geek code v 3.12
GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- r++>+++ y+++*
Weapons extension: ma- k++ F+2 X
I use 1TBS
|
|
|
|
|
A lot of services are out there, which provide free service for you to host, it is their choice to allow source code upload or provide you with some ready made templates.
Go and simply ask Google[^] about it and you will get the result.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
|
I’m currently working on a PHP application and want to know if I can Yii framework for speed and flexibility. Anybody please help me with its features. Is Yii development framework secure?
|
|
|
|
|
|
YII, for no doubt is the fastest, secure and one of the best php frameworks currently in the industry. It has lot of features, I would like to mention some main features here,
- YII is very much known for its speed, and it's CRUD feature saves your time and makes the process much easier.
- There are lot of widgets, which support jquery and ajax,
- It's inbuilt theme directory helps to set the theme for any applications.
- It provides great support for error handling.
- Unit testing feature helps to test and improve your coding.
- It has the excellent documentation systems compared to all other frameworks.
|
|
|
|
|
how to use validation with login in code view
shyam kumar
|
|
|
|
|
Where are you stuck?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
I have two classic asp pages on my local machine that I would like to test them by bring each up in a browser from Visual Studio just to test a few links. How can I do this?
|
|
|
|
|
You need Visual InterDev which comes with Visual Studio 6 As asp is interpreted you can use any text editor to amend the pages; sublime, notepad++ etc. They might not recognize classic asp syntax features but it's no big deal. Then to test you just navigate to the pages directly in your browser
|
|
|
|
|
I have run across this problem many times and Have FINALLY found out what is going on and how to solve it.
In VS 2012 (and probably 2010 and 2013), after you load your web site, right click on the site name (usually something like C:\..\<SITENAME>\) and a large menu appears. Look for "Use IIS Express..." and click on this. Two pop-ups will appear click Yes on the first and OK on the second.
Give it a few seconds and you will then see the site name has changed and the C:\..\ is no longer there. (i.e. C:\..\MySite\ becomes MySite).
If you don't already have a specific page set up to be the default page to run when you run the site from VS, click on the start page, (i.e. index.asp, Default.asp, etc...) and then hit F5 to run the site. It should come right up.
If you try to run the above procedure but you don't see the option "Use IIS Express..." what you might see instead is "Use Visual Studio Development Server". This means you are already set up to run classic asp and your problem is probably your pages.
Things you can try:
Hit Shift-F4 to open the properties page and select Start Options. Click on Use Current Page and then click Okay. Select the simplest/do nothing ASP page you have (or create one), one that doesn't require logging in or getting data from a database but maybe just prints something to the screen using a Response.Write. Once selected, hit F5. If this page works then VS is set up correctly but the problem is with your code.
|
|
|
|
|
I am changing some markup and need to make another classic asp page as the start up page from with in IIS. How do I change the classic asp start page from IIS directly?
|
|
|
|