[PHP] How to take results from search into a html form?

**Sarcoptes** · 06-30-2011

Hey,
I have a fully functional search for a database. When you search for "rör" (yes, swedish..) you get this:

Now, I want a form just below each of the count.)'s so it would look kind of like this:

The "ok" button takes you to another php file that puts the values into the database.
As whole it should work like, you search for a "Vara" like "rör", and get the results, with text boxes beneat heach one of them, with the values presented that you can modify, i.e modify the quantity etc.

I tried everything I could, but I't simply won't work. Heres a part of the code:
[PHP] php code - Pastebin.com

and the php file after that:
[PHP] otherphpthingy - Pastebin.com

I imagine the form would be something like this, but how do I implement it so that it shows up on the page?
[PHP] htmlthingy - Pastebin.com

I would be very grateful for an answer that solves this.

Thanks.

**~~ev1~~** · 06-30-2011

on your [PHP] php code - Pastebin.com

put the form inside the mysql_fetch_array - that way it will show up as a form for each of those array items. Just echo it

**Sarcoptes** · 06-30-2011

Thanks for the reply.

Do you mean it like this?
[PHP] while ($row = mysql_fetch_array($result echo"<br><form method="post" action= - Pastebin.com
Still, that doesn't work :/

I'm still a newb in php :s

**~~ev1~~** · 06-30-2011

Code:

echo "$count.) &nbsp; 
		<b>E-Nummer</b>:&nbsp; $title&nbsp;&nbsp;  
		<b>Vara</b>: $title2&nbsp;&nbsp;  
		<b>Typ</b>: $title3&nbsp;&nbsp;  
		<b>Antal i Lager</b>: $title4&nbsp;&nbsp;  
		<b>Antal i Bil 1</b>: $title5&nbsp;&nbsp;  
		<b>Antal i Bil 2</b>: $title6&nbsp;&nbsp;<br>
//throw some <form> code in here, you can add unique value the same way by doing like <form id=\"$title1\"> or whatever you want
		";

kinda like that, modify it how you want

**Sarcoptes** · 06-30-2011

I've tried this (I only put one row in the form to make it smaller, just to see if it actually works.):

Code:

        echo "$count.) &nbsp; 
        <b>E-Nummer</b>:&nbsp; $title&nbsp;&nbsp;  
        <b>Vara</b>: $title2&nbsp;&nbsp;  
        <b>Typ</b>: $title3&nbsp;&nbsp;  
        <b>Antal i Lager</b>: $title4&nbsp;&nbsp;  
        <b>Antal i Bil 1</b>: $title5&nbsp;&nbsp;  
        <b>Antal i Bil 2</b>: $title6&nbsp;&nbsp;<br>
        <br>
        <form method="post" action="elgsdatabas_uppdatera_lager3.php">
        E-Nummer: <input type="text" name="enummer" value="$title" />
        <input  type="submit" name="submit" value="Ok">
        </form>
        "

and

Code:

echo "$count.) &nbsp; 
        <b>E-Nummer</b>:&nbsp; $title&nbsp;&nbsp;  
        <b>Vara</b>: $title2&nbsp;&nbsp;  
        <b>Typ</b>: $title3&nbsp;&nbsp;  
        <b>Antal i Lager</b>: $title4&nbsp;&nbsp;  
        <b>Antal i Bil 1</b>: $title5&nbsp;&nbsp;  
        <b>Antal i Bil 2</b>: $title6&nbsp;&nbsp;<br>
        <br>
        <form method="post" action="elgsdatabas_uppdatera_lager3.php" id="$title">
        E-Nummer: <input type="text" name="enummer" value="$title" />
        <input  type="submit" name="submit" value="Ok">
        </form>
        "

And a few others, whatever I do, they wont appear on screen.

Sorry if im bothering you too much D:

**~~ev1~~** · 06-30-2011

You have syntax errors make sure to put a \ before any quote marks in the echo, or else php thinks you're talking about a new variable

like for exampe:

Code:

 
<?
echo "<form id="test">";
// this is bad ^^
echo "<form id=\"test\">";
// this is good! ^^ 
?>

**Sarcoptes** · 06-30-2011

Wont show up, still >_< argh!

Code:

        <br>
        "
        echo "<form method=\"post\" action=\"elgsdatabas_uppdatera_lager3.php\" id=\"$title\">
        E-Nummer: <input type=\"text\" name=\"enummer\" value=\"$title\" />
        <input  type=\"submit\" name=\"submit\" value=\"Ok\">
        </form>
        ";

**~~ev1~~** · 06-30-2011

Do you have the page available to show me? i'd like to take a look at the full code if you don't mind....by the way brb like 25 minutes - i'm moving across the country tomorrow, still packing haha

**Sarcoptes** · 06-30-2011

Alright, sure, I edited out the connecting info ofcourse, since thats yknow, stuff.. :P

[PHP] <html> <head> <title>Lager Sökning</title> </head> <body> <?php $va - Pastebin.com is the file for search & display
[PHP] Meh 2 - Pastebin.com is the php file after that, and it works fine.

I'll be brb a few tens of minutes aswell, as I'm not at home right now, heading home now.
Also, im not sure if $results should still be neccessary, as i tried using "if over 10 results, do a next arrow and display next 10 results there, etc" - but I thought it was better to just simply display every result in one page for what its going to be used for.

Also2, the original searchcode was a template from teh interwebz, It's the only thing I needed a template for, since as I said, im a php newb :P

Cheers for the help sofar.

**~~ev1~~** · 06-30-2011

Try this code for the first page: http://pastebin.com/8ygbGnqh

and i'm not 100% sure what you need done for the 2nd page :X sorry i'm like all over the place today with packing and stuff. if it's urgent that you figure this out you can always hire someone locally quickly or PHP Freaks - PHP Help Index <-- those forums are normally great help when i'm confused on a function

you did great with showing screenshots with what you wanted, do that again there.

**Sarcoptes** · 06-30-2011

Thanks, I'll try it when I get time, the other file, dunno why I linked it here, I was supposed to save it so I wouldnt forget it :P

**Sarcoptes** · 07-01-2011

Thanks alot. This worked perfectly.. silly that the problem was basically just a ; and \ before quotes. D:
\o

**~~ev1~~** · 07-03-2011

it's amazing how syntax hates new people for those silly mistakes, if you have any questions - let me know. php is my life

Shout-Out

User Tag List

Thread: [PHP] How to take results from search into a html form?

Thread Tools

Search Thread

[PHP] How to take results from search into a html form?

Similar Threads

How do I get a file from Maya into WoW?

[Guild Master] How to be Guild Master that can take gold from Guild Bank

How to take off rideing skill and level from mounts

[Guide] How to take away arena points costs from arena vendors PICS

[GUIDE][PICS]How To Take Off The Riding Skill And Level From Mounts !

OwnedCore Forums

casino

CoreCoins

My OwnedCore

About Us

Casino