BLARGLE !! submit button

sebastienp

hey guys.

i have this textarea , i wanna create a submit button beneath it.

what i would like the action to do is:

when u press the submit button, it'll update my database, to whatever is located inside the textarea.

<?php mysql_query("UPDATE seb SET name=' alalalal' WHERE id=3", $db); ?>

the attribute i want to update is called name, and id like to replace "alalala" to whatever is in the textarea after i press the submit button.

merci
-sebastien

Weedpacket

What you're describing is covered here. What precisely is the bit you're having trouble with?

You just want the submit button? Isn't that just
<input type="submit">
??

Pyroguy

i'm doing something pretty similar to what your doing, and this is the way i did it.

I had a form on one page, and the form "action" was called signup.php. What the signup page does is writes all the information from my forms into my database.

//This is the form
<html>
<form action="submit.php" method="post">
<textarea name="input" rows="6" cols="40"></textarea><br>
<input type="submit">
</form>
</html>

//This is the what happens when you press submit
<?php
$content = mysql_escape_string($_POST['input']);
$link = mysql_connect($YourIP, username, pass)
or die("Could not connect: ".mysql_error());
//Note: Don't enter a username or password when using the mysql_connect, i just put it there for the sake of syntax.
//It isn't really needed unless your user was going to administer the mysql server
$database = mysql_select_db($dbName, $link)
or die("Could not select database: ".mysql_error());
$query = mysql_query("INSERT INTO table (column) VALUES('$content')")
or die("Invalid Query: ".mysql_error());
mysql_close ($link)
?>

You might have a problem with database authorization. If you do, just go into mysql as username root and then type at shell: GRANT ALL ON dbName.* TO ''@"%"

Note: What looks like a double quote before the @ symbol is really just two single quotes

That should do it for ya

sebastienp

<html>

<select name="dropdown">
	<option value="">default</option>
	<option value="11">1- main page</option>
	<option value="12">2- misc page</option>
                            <option value="13">3- photos</option>
</select>
<input type="Submit" value="Take A Look" align="MIDDLE">

</form>

<?php

if($_GET['dropdown']==11)
{
$id=1;

};
if($_GET['dropdown']==12)
{
$id=2;

};

if($_GET['dropdown']==13)
{
$id=3;

};

$db = mysql_connect("x","x", "x");
mysql_select_db("x",$db);

$requete = "SELECT * FROM seb WHERE id=$id";
$result = mysql_query ($requete,$db);
$seb = mysql_fetch_object($result);
mysql_free_result($result);

<textarea name="txtArea" cols="50" rows="30">

     <?php Print($seb->name); ?>

</textarea> 

         <input type="submit" name="submit" value="save"> 
         <input type="int" name="pageid">

</form>

<br>

<?php

mysql_query("UPDATE seb SET name='$txtArea' WHERE id=$pageid", $db);

print($txtArea);

</html>

this is how i finally did it.
heres how it works

1- u select what page u wanna see from the drop down menu.
2- after that , the content of the database where the ID is equal to the variable in the drop menu will appear in the textarea.
3- the content of the text area is now editable to whatever u want it.
4- once ur done editing, u put what ID you want the new content to be updated to in the INT box next to the save button
5- click save, and the database is updated.

things im gonna add, say u were to put a number in the INT box but theres no ID number that is the same in the database, then it will insert into and create it <-- ima do that later tonight....
not bad i suppose from someone(me) who dindt know a clue about php 2 days ago