Web Development

<form>

    <subtitle>Task Order - File Attachments</subtitle>

    <fields>
        <_count header="No" suffix="." width="30" align="center" />
        <tofiles_title header="Title" align="left" />
        <tofiles_post_date header="Date" type="date" params="M j, Y" align="center" width="100" />
    </fields>

    <header>
        <titles>true</titles>
        <buttons>
            <delete onclick="" button="addnew" >
                <location>index.php?sub=tofiles&action=add&tofiles_relation={RELATION}&tofiles_type={TYPE}&returnurl={CURRENT_PAGE}</location>
            </delete>
        </buttons>
    </header>

    <vars>
        <relation import="$_GET['sup_id'] ? $_GET['sup_id'] : $_GET['product_id']" type="eval" />
        <type import="$_GET['sup_id'] ? '1' : '2'" type="eval" />
    </vars>


    <buttons>
        <delete onclick="" button="delete" >
            <location>javascript:if(confirm('Are you sure you want to delete this record ?')) window.location='index.php?sub=tofiles&action=delete&tofiles_id={NOTE_ID}&returnURL={CURRENT_PAGE}'</location>
        </delete>

        <details onclick="" button="details" >
            <location>index.php?sub=tofiles&action=det&tofiles_id={TOFILES_ID}&returnurl={CURRENT_PAGE}</location>
        </details>

    </buttons>

    <SQL>
        <vars>
            <sql_table import="$this->tables['tofiles']" type="eval"/>
            <relation import="$_GET['sup_id'] ? $_GET['sup_id'] : $_GET['product_id']" type="eval" />
            <type import="$_GET['sup_id'] ? '1' : '2'" type="eval" />
            <sql_condition import="WHERE tofiles_type='{TYPE}' AND tofiles_relation='{RELATION}' " type="var"/>
        </vars>

        <query>SELECT * FROM `{SQL_TABLE}` {SQL_CONDITION} ORDER BY tofiles_post_date DESC</query>
    </SQL>

    <items>100</items>

</form>

<form>
    <title>T/O Attachment Details</title>
    <action>#</action>
    <name>edit</name>
    <width>580</width>

    <formtag>true</formtag>
    <border>true</border>

    <buttons>
        <set>
            <footer>true</footer>
            <header>true</header>
        </set>

        <return onclick="" button="return" >
            <location>{PRIVATE.FORM_PREVIOUS_PAGE}</location>
        </return>

        <save onclick="" button="edit">
            <location>index.php?sub=tofiles&action=edit&tofiles_id={TOFILES_ID}&returnurl={CURRENT_PAGE}</location>
        </save>

    </buttons>

    <redirect>index.php?sub=users</redirect>

    <vars>
        <returnurl import="urldecode($_GET[returnURL])" type="eval" />
    </vars>

    <fields>


        <user_id type="hidden" hidden="true"/>

        <tofiles_title type="text">
            <title>Title</title>
        </tofiles_title>

        <tofiles_body type="text" valign="top" font="normal">
            <title>Description</title>
        </tofiles_body>

        <subtitle_log type="subtitle" title="Log Data" />

        <tofiles_post_date type="text" action="date" params="F j, Y, g:i a">
            <title>Post Date</title>
        </tofiles_post_date>

        <tofiles_post_ip type="text">
            <title>Post Ip</title>
        </tofiles_post_ip>

        <tofiles_post_user type="relation">
            <title>Post User</title>
            <relation table="users" id="user_id" text="user_login" />
        </tofiles_post_user>

    </fields>
</form>

<form>
    <title>{PRIVATE.FORM_ACTION_TITLE} T/O - FFFile Attachments</title>
    <action>index.php?sub=tofiles&action=store</action>
    <name>edit</name>
    <width>580</width>

    <formtag>true</formtag>
    <border>true</border>

    <buttons>
        <set>
            <footer>true</footer>
            <header>true</header>
        </set>

        <return onclick="" button="return">
            <location>{PRIVATE.FORM_PREVIOUS_PAGE}</location>
        </return>

        <save onclick="" button="saveall">
            <location>javascript:document.forms[0].submit();</location>
        </save>

    </buttons>

    <redirect>index.php?sub=accounts</redirect>

    <fields>
        <tofiles_id type="hidden" hidden="true"/>
        <tofiles_post_date type="hidden" default="time()" action="eval"/>
        <tofiles_post_user type="hidden" default="$_SESSION[minibase][raw][user_id]" action="eval"/>
        <tofiles_post_ip type="hidden" default="$_SERVER[REMOTE_ADDR]" action="eval"/>
        <tofiles_relation type="hidden" default="$_GET[tofiles_relation]" action="eval"/>
        <tofiles_type type="hidden" default="$_GET[tofiles_type]" action="eval"/>

        <tofiles_title type="textbox" size="35" required="true" validate="A:2:200">
            <title>Title</title>
        </tofiles_title>

        <tofiles_body type="textarea" size="60:5" required="true" validate="A:1:100000">
            <title>Body</title>
        </tofiles_body>

    </fields>



</form>

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

$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;