simple ( insert and get ) php example .

[egturnkey]

Hello Friends,

I've learn get.update.delete but faild in insert command


when i make input of
x1
x2
x3
x4

it stored in database but when i get it
i only get
x1

why


here is the example and let me know wt is the wrong



<?php
require_once('config.inc.php');

if(isset($_POST[s1]))
{
$q1 = "insert into name_table set

MainPage = '$_POST[MainPage]',
AboutUs = '$_POST[AboutUs]' ";

mysql_query($q1) or die(mysql_error());
echo "<br><center>News added successfully!</center><br>";
?>


<form method=post>
<textarea name=MainPage rows=6 cols=35>enter here words</textarea>
<br />
<input type=submit name=s1 value="submit">
</form>




and the index which should have the error need to be fixed is as follow





<?php
require_once('config.inc.php');

//get the current settings
$q1 = "select * from $table_name order by id desc";
$r1 = mysql_query($q1) or die(mysql_error());
$a1 = mysql_fetch_array($r1);

?>


<br /><br /><hr />

<?=$a1[MainPage]?>

[Schmoopy]

Ok, you should put SQL statements in all CAPITALS. Like so:

SELECT... FROM... WHERE.

Field names should have ticks : `column_1`

So let's edit your code... :

First we have to fix the INSERT INTO statement. You've written it as an UPDATE statement, so that's why it won't work. Here's how it should be:



<?php
require_once('config.inc.php');

if(isset($_POST[s1]))
{
$main = $_POST['MainPage'];
$about = $_POST['AboutUs'];
$q1 = "INSERT INTO name_table (MainPage, AboutUs)
VALUES('$main','$about')";

mysql_query($q1) or die(mysql_error());
echo "<br><center>News added successfully!</center><br>";
?>


I assumed you have two fields called MainPage and AboutUs and we don't really need the ticks here.

$_POST[] variables should also have single quotes around them:


$_POST['variable'];

Now for the other code:



<?php
require_once('config.inc.php');

//get the current settings
$q1 = "SELECT * FROM $table_name ORDER BY `id` DESC";
$r1 = mysql_query($q1) or die(mysql_error());
$a1 = mysql_fetch_array($r1);

while($a1 = mysql_fetch_array($r1)) {
echo $a1['MainPage'] . '<br />';
}
?>


Once you've got the array you want to echo the MainPage for each row.

This should sort it out. Just say if you have any more problems.

[egturnkey]

thanks so much

but can you please give me example how to write the following code



echo $a1['MainPage'] . '<br />';


within the HTML content like the following



<textarea name=privacy rows=4 cols=40><?=$a1[MainPage]?></textarea>


I've tried but didn't worked so can you please re-coded it so that



<?php
require_once('config.inc.php');

//get the current settings
$q1 = "SELECT * FROM $table_name ORDER BY `id` DESC";
$r1 = mysql_query($q1) or die(mysql_error());
$a1 = mysql_fetch_array($r1);

while($a1 = mysql_fetch_array($r1)) {
echo $a1['MainPage'] . '<br />';
}
?>


separated the data get values than tables connection

thanks in advance really, it helps me so much to understand many things
cause i found the best way to learn anything is to watch an example and compare it with the rules .

[forum_amnesiac]

Try this


<textarea name=privacy rows=4 cols=40><?echo $a1[MainPage]?></textarea>

[Schmoopy]

When accessing array items you should use single quotes.

For example if we have this array:



$a1 = array('MainPage'=>'Heres some test text');


To access this data item we should use:



$a1['MainPage'];


If you try to access the array item without quotes it will treat it as a constant and throw an error.

Another thing to note that this way of writing php:



<?=$variable?>


Although acceptable on some servers, won't work on others. To be sure this will work whatever the situation you should use:



<?php echo $variable; ?>


Also when you write attributes for HTML you should put double quotes around values:


<textarea name="privacy" rows="4" cols="40">

Ok and now the whole thing, fixed:



<?php
$a1 = array('MainPage'=>'Hello here\'s some test text');
?>

<textarea name="privacy" rows="4" cols="40"><?php echo $a1['MainPage']; ?></textarea>


Just to note... You can use "\n" within a textarea element to break a line.