[RESOLVED] Text Field Into a MySQL Database...

Paris_Holley

i know how to load the information from a colum into a text area, but i want it so that i can also edit and save it also.

Ex:

Text Here Text Here Text Here Text Here Text Here Text Here Text Here Text Here Text Here Text Here Text Here Text Here Text Here Text Here Text Here Text Here Text Here Text Here

Edit it then save it so it says something like this

Welcome to blah blahb lah, enjoy ur stay blah blah blah, im glad that you blah blah blah...

so when it loads it loads the one i edited......

Paris_Holley

im making a script in which a site loads its content from the mysql. The admin cp will be able to edit the content ( in this case the rows )...The default when someone gets the script will say "Text Here" I then want it so that I can edit it and put what i want there so the site will load the content. So i want to know how to submit the new information that was entered into the textarea

Paris_Holley

sort of like when you edit ur sig in your profile, it updates the info...well thats what im talkin bout

drag0n

ummm... so:
You want to grab the info from DB
Put it in a editable TextBox?
They are able to edit it, they click a button named "Update" and it updates the db with that info?

drag0n

see, when you said about the Sig thing.. thats what I thought of but all that default stuff, I have no idea what you were talking about..

Paris_Holley

Originally posted by drag0n
ummm... so:
You want to grab the info from DB
Put it in a editable TextBox?
They are able to edit it, they click a button named "Update" and it updates the db with that info?

exactly

drag0n

Fairly simple, letme draft one up real quik

Paris_Holley

thanks alot

drag0n

Well dont get me wrong but Im a bit rusty with PHP, just got back after 3 month of not touching it, so this code hasnt been tested yet and dont blame me if its not right...
This is the page which will get the data from the mysql and siplay it in a editable text area with buttons:

<?php 
//Connect and select database 

   $mysqlconn = mysql_connect("","",""); //your info host,user,pass 
             mysql_select_db("dbname",$mysqlconn); //add your dbname 
   $sql_select ="SELECT *FROM profiles WHERE id = " . $_GET['id'] . ""; 
   $sql_results = mysql_query( $sql_select ) or die( mysql_error() ); 
//mysql_fetch_array it
$sql_array = mysql_fetch_array( $sql_results );
?> 
<html>
<head>
<title>Update Your Infomation</title>
</head>
<body>
<form name="form1" method="post" action="actionpage.php">
  <textarea name="textarea" cols="50" rows="8"> <?php echo $sql_array[ "profile" ]; ?> </textarea>
  <input type="submit" name="Submit" value="Update">
  <input type="reset" name="Submit2" value="Reset">
  <input name="id" type="hidden" id="id" value="<?php echo $sql_array[ "id" ]; ?>">
</form>
</body>
</html>

This is actionpage.php which will process the UPDATE DB


<?php 
//Connect and select database 

   $mysqlconn = mysql_connect("","",""); //your info host,user,pass 
             mysql_select_db("dbname",$mysqlconn); //add your dbname 
   $sql_update = "UPDATE profiles SET profile = " . $_POST[ 'textarea' ] . " AND id = " . $_POST['id'] . "  WHERE id = '" . $_GET[ 'id' ] . "'";
   $result_update = mysql_query( $sql_update ) or die( mysql_error() );
   echo "You profile has been updated, thankyou for using our system";

?>

I hope they work, ask any questions you may have...

Paris_Holley

i changed

$sql_select ="SELECT *FROM profiles WHERE id = " . $_GET['id'] . "";

   $sql_select ="SELECT * FROM `update` WHERE 1" . $_GET['id'] . "";

so would do i do to actionpage?

drag0n

By:

$sql_select ="SELECT * FROM `update` WHERE 1" . $_GET['id'] . "";

did you mean:

$sql_select ="SELECT * FROM `update` WHERE 1 = " . $_GET['id'] . "";

If so then just change:

$sql_update = "UPDATE profiles SET profile = " . $_POST[ 'textarea' ] . " AND id = " . $_POST['id'] . "  WHERE id = '" . $_GET[ 'id' ] . "'";

$sql_update = "UPDATE update SET profile = " . $_POST[ 'textarea' ] . " WHERE id = '" . $_POST[ 'id' ] . "'";

That should be it, tell me if it works out

drag0n

I edited the above thread, so maybe you should recheck it
And also for the first one with HTML, youd have to send a URL to it like:
http://www.mydomain.com/edit.php?id=5
And then it would get the profile info for id number 5
Know what I mean?

Paris_Holley

I get this error when i hit submit

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'update SET site = paris2 WHERE id = ''' at line 1

This is waht i have

<?
$mysqlconn = mysql_connect(-,-,-); //your info host,user,pass 
mysql_select_db(-); 
$sql_select ="SELECT * FROM `update` WHERE 1 = " . $_GET['id'] . "";
   $sql_results = mysql_query( $sql_select ) or die( mysql_error() );  

//mysql_fetch_array it 
$sql_array = mysql_fetch_array( $sql_results ); 
?>  

<html> 
<head> 
<title>Update Your Infomation</title> 
</head> 
<body> 
<form name="form1" method="post" action="actionpage.php"> 
  <textarea name="textarea" cols="50" rows="8"> <?php echo $sql_array[ "site" ]; ?> </textarea> 
  <input type="submit" name="Submit" value="Update"> 
  <input type="reset" name="Submit2" value="Reset"> 
  <input name="id" type="hidden" id="id" value="<?php echo $sql_array[ "id" ]; ?>"> 
</form> 
</body> 
</html> 
<?php  

//Connect and select database 

$mysqlconn = mysql_connect(-,-,-); //your info host,user,pass 
mysql_select_db(-); 
$sql_update = "UPDATE update SET site = " . $_POST[ 'textarea' ] . " WHERE id = '" . $_POST[ 'id' ] . "'";
   $result_update = mysql_query( $sql_update ) or die( mysql_error() ); 
   echo "You profile has been updated, thankyou for using our system"; 

?>

drag0n

try this for actionpage.php

<?php   

//Connect and select database 

$mysqlconn = mysql_connect(-,-,-); //your info host,user,pass 
mysql_select_db(-);
//Declare Variables
$textarea = $_POST[ 'textarea' ];
$id = $_POST[ 'id' ];
//Update stuff
$sql_update = "UPDATE update SET site = " . $textarea . " WHERE 1 = '" . $id . "'"; 
   $result_update = mysql_query( $sql_update ) or die( mysql_error() );  

   echo "You profile has been updated, thankyou for using our system";  

?>

drag0n

and on the first one
From

  <input name="id" type="hidden" id="id" value="<?php echo $sql_array[ "id" ]; ?>">

  <input name="id" type="hidden" id="id" value="<?php echo $_GET[ "id" ]; ?>">

Paris_Holley

nope

drag0n

Try this
From:
//Update stuff
$sql_update = "UPDATE update SET site = " . $textarea . " WHERE 1 = '" . $id . "'";
to
//Update stuff
$sql_update = "UPDATE update SET site = '" . $textarea . "' WHERE 1 = '" . $id . "'";
That should definitely work, missing '
and edit the first one according to my previous post

Paris_Holley

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'update SET site = 'paris' WHERE 1 = ''' at line 1

drag0n

$id is not getting passed through.. did you go to the first page using a url like: www.mydomain.com/edit.php?id=5 or watever?
Did you change everthing on the first page from:
<input name="id" type="hidden" id="id" value="<?php echo $sql_array[ "id" ]; ?>">
to
<input name="id" type="hidden" id="id" value="<?php echo $_GET[ "id" ]; ?>">
??? Did you change everything on the actionpage.php acording to my posts?

Paris_Holley

www.pixel-lab.net/connect.php?id=1

yes i did change everything on the first one

try the thing urself and change paris to whatever you want...it wont work