submit in html on sql query

Question

I need to run this sql query, which give me a list of Id and Dates I want to click each result and take with me the Id value to the next form I wrote this query above but i see in the debager that the hidden ID get his value but not pass to the next form I think i have a problem with the submit() . where should I put him ?

function ShowAllCarts($user_email) {

    $connB = new ProductDAO();
    $connB->Connect();
    $pro_query = "SELECT * FROM Cart WHERE `Email`='$user_email';";
    $db_result = $connB->ExecSQL($pro_query);

    $html_result = '<div data-role="content"> <ul data-role="listview" data-theme="b"> ';
    $html_result .= '<form action="PreviouscartProduct.php" method="POST"/>';

    while($row_array = $db_result->fetch_array(MYSQLI_ASSOC))
    {
        $Id= $row_array['Id'];
        $Date= $row_array['Date'];

        //$html_result //
        $html_result .="<li><a href='PreviouscartProduct.php'>Cart number: $Id from Date: $Date><input type='hidden' name='Id' value'<?=$Id?>'</input></a></li>'";
        $html_result .= '<a onclick="this.form.submit();" </a>;
    }

        $html_result .= '</form>';  
        $html_result .= ' </ul> </div>';

    $connB->Disconnect();
    return $html_result;
}

//display all carts
$func_result = ShowAllCarts($Email);

Please, use punctuation in your text, it is hard to read.

Jocelyn
– Jocelyn

2012-09-03 21:41:42 +00:00
Commented Sep 3, 2012 at 21:41 — Jocelyn
– Jocelyn, Commented Sep 3, 2012 at 21:41

SteAp · Accepted Answer · 2012-09-03 21:51:21Z

1

You need to use a checkbox element:

$html_result .="<li>"
              ."<checkbox name='cartItem[$Id]' value='$Date'>"
              . "Cart number: $Id from Date: $Date"
              . "</li>'"
              ;

Then, in PreviouscartProduct.php, you'd itera over cartItem:

$cartItems = $_POST[ 'cartItem' ];
foreach( $cartItems as $id => $date ) {
 ... do something ...
}

In case you'd like to take exactly one item, why not use this:

$html_result .="<li>"
              . "<a href='PreviouscartProduct.php?cartID=$Id&date=$Date'>"
              . "Cart number: $Id from Date: $Date"
              . "</a>"
              . "</li>'"
              ;

edited Sep 3, 2012 at 21:51

answered Sep 3, 2012 at 21:45

SteAp

12k12 gold badges56 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1644661 Over a year ago

thank you for your answer when i tried the checkbox like you write here it doesn't take the result line as a link or as a box to be checked , just a simple line with charctares

Mark · Accepted Answer · 2012-09-04 10:31:09Z

0

There's a bunch of HTML syntax errors in this, check the output in a validator

For a start, your opening a tag doesn't close after this.form.submit();, it should read

$html_result .= '<a onclick="this.form.submit();">Anchor Text Here</a>';

Edit : the anchor element needs to reference the form. Give the form element a name attribute and use something like

onclick="document.nameattributehere.submit();return false"

on the link.

End edit.

Also, in the line above, you're already using the PHP parser when you get to the value attribute of your input, so there is no need for the

<?= and ?>

Finally, in the same tag, you don't need a closing input tag

</input>

Just close the opening tag with

/>

That's just glancing, run the validator for other errors and I'm sure the problem will be clearer.

edited Sep 4, 2012 at 10:31

answered Sep 3, 2012 at 21:44

Mark

3,0651 gold badge23 silver badges30 bronze badges

3 Comments

Mark Over a year ago

Also, the the nesting of the <ul> and <form> tags are incorrect

user1644661 Over a year ago

thank you for your answare i treied it , the post of the Id still doesn't happen

Mark Over a year ago

I would go with SteAp's answer of just using the links with a querystring. Just tidy up your HTML, it's hard to help when it's such a mess.

Collectives™ on Stack Overflow

submit in html on sql query

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related