crazy edit thingy - Codewalkers

Codewalkers Forums Sponsor:

Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here!

September 3rd, 2002, 08:11 PM

russ

Join Date: Apr 2007

Location: London, UK

Posts: 129

Time spent in forums: < 1 sec
Reputation Power: 2

crazy edit thingy

my code is coming out crazy at the mo, I know the code isn't complete yet, I'm just building it up and debugging it as I go along, but on the edit tutorial, I found that when it comes to the actually editing, it formats all wrong, well you have to see what I mean here http://gmflp.l33t.ca/yepyep/news.php?action=edit&id=4 I dunno whats thats all about, please help

php Code:

Original - php Code

<?php 
$db = @mysql_connect("$dbhost", "$dbuname", "$dbpage");
if (!$db) {
  echo( "<p>Unable to connect to the " .
        "database server at this time.</p>" );
  exit();
}
mysql_select_db("$dbname", $db);
if (! @mysql_select_db("$dbname") ) {
  echo( "<p>Unable to locate the news " .
        "database at this time.</p>" );
  exit();
}
if($submit)
{
$sql = "INSERT INTO newsdb (name, email, title, news, date) VALUES ('$name', '$email', '$title','$news', now('$date'))";
$result = mysql_query($sql); 
echo( "Thank you! Information entered. Click <a href=/news.php>here</a> to view your news" );

}
elseif($_GET['action'] == 'edit')
{
 $result = mysql_query("SELECT * FROM newsdb WHERE id=$id",$db);
 $myrow = mysql_fetch_array($result);

echo "<form method=post action=".$PHP_SELF.">";
echo "<input type=hidden name=id value=".$myrow['id'].">";

echo "<b>Title</b>: <input type=Text name=title value=".$myrow['title']."><br>";

echo "<b>News:</b> <textarea name=news cols=40 rows=8 value=".$myrow['news']."><br>";

echo "<b>Name:</b><input type=Text name=name value=".$myrow['name']."><br>";

echo "<b>E-mail:</b><input type=Text name=email value=".$myrow['email']."><br>";

echo "<input type=Submit name=update value=Update information></form>";

}
elseif($searchstring)
{
$sql="SELECT * FROM newsdb WHERE title LIKE '%$searchstring%' ORDER BY title ASC";
$result = mysql_query($sql,$db);
while ($myrow = mysql_fetch_array($result))

echo("<b>Title:</b> ".$myrow['title']. "<br><b>News:</b> ".$myrow['news']. "<br><a href=?action=edit&id=".$myrow['id'].">Edit</a> | <a href=?action=delete&id=".$myrow['id'].">Delete</a><p>");

} 
else 
{ 
?> 
<form method="post" action="<?=$PHP_SELF?>"> 
Name:
<br><input type="Text" name="name"> 
<br>Email:
<br><input type="Text" name="email">
<br>Title:
<br><input type="Text" name="title">  
<br>News:
<br><textarea name="news" cols=40 rows=8></textarea> 
<br>
<input type="Submit" name="submit" value="Submit"></form>

<h3>MADE AN ERROR? EDIT IT HERE</H3>

<form method="POST" action="<?php $PHP_SELF ?>">
Enter the title of the news:<input type="text" name="searchstring" size="28">

<? 
} 
?>

 
<?php 
$db = @mysql_connect("$dbhost", "$dbuname", "$dbpage");
if (!$db) {
  echo( "<p>Unable to connect to the " .
        "database server at this time.</p>" );
  exit();
}
mysql_select_db("$dbname", $db);
if (! @mysql_select_db("$dbname") ) {
  echo( "<p>Unable to locate the news " .
        "database at this time.</p>" );
  exit();
}
if($submit)
{
$sql = "INSERT INTO newsdb (name, email, title, news, date) VALUES ('$name', '$email', '$title','$news', now('$date'))";
$result = mysql_query($sql); 
echo( "Thank you! Information entered. Click <a href=/news.php>here</a> to view your news" ); 
 
}
elseif($_GET['action'] == 'edit')
{
 $result = mysql_query("SELECT * FROM newsdb WHERE id=$id",$db);
 $myrow = mysql_fetch_array($result);
 
 
echo "<form method=post action=".$PHP_SELF.">";
echo "<input type=hidden name=id value=".$myrow['id'].">";
 
echo "<b>Title</b>: <input type=Text name=title value=".$myrow['title']."><br>";
 
echo "<b>News:</b> <textarea name=news cols=40 rows=8 value=".$myrow['news']."><br>";
 
 
echo "<b>Name:</b><input type=Text name=name value=".$myrow['name']."><br>";
 
echo "<b>E-mail:</b><input type=Text name=email value=".$myrow['email']."><br>";
 
 
echo "<input type=Submit name=update value=Update information></form>";
 
}
elseif($searchstring)
{
$sql="SELECT * FROM newsdb WHERE title LIKE '%$searchstring%' ORDER BY title ASC";
$result = mysql_query($sql,$db);
while ($myrow = mysql_fetch_array($result))
 
echo("<b>Title:</b> ".$myrow['title']. "<br><b>News:</b> ".$myrow['news']. "<br><a href=?action=edit&id=".$myrow['id'].">Edit</a> | <a href=?action=delete&id=".$myrow['id'].">Delete</a><p>");
 
 
 
 
} 
else 
{ 
?> 
<form method="post" action="<?=$PHP_SELF?>"> 
Name:
<br><input type="Text" name="name"> 
<br>Email:
<br><input type="Text" name="email">
<br>Title:
<br><input type="Text" name="title">  
<br>News:
<br><textarea name="news" cols=40 rows=8></textarea> 
<br>
<input type="Submit" name="submit" value="Submit"></form>
 
<h3>MADE AN ERROR? EDIT IT HERE</H3>
 
<form method="POST" action="<?php $PHP_SELF ?>">
Enter the title of the news:<input type="text" name="searchstring" size="28">
 
<br><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2">
</form>
 
<? 
} 
?>

September 3rd, 2002, 08:48 PM

Nimco

Join Date: Apr 2007

Posts: 132

Time spent in forums: < 1 sec
Reputation Power: 2

RE: crazy edit thingy

OK, the reason your textarea has lots of code inside is because you have got the syntax wrong. The syntax for a textarea is as follows:

php Code:

Original - php Code
<textarea name="mytextbox">Default text goes here</textarea>

 
<textarea name="mytextbox">Default text goes here</textarea>

Also, here's a little hint I find very useful. When you are writing PHP script to print HTML or plain text straight to the page, do it outside of the PHP:

php Code:

Original - php Code
echo "<b>News:</b> <textarea name=news cols=40 rows=8 value=".$myrow['news']."><br>"; becomes: <b>News:</b><textarea name="news" cols="40" rows="8"><?=$myrow['news']?></textarea>

 
echo "<b>News:</b> <textarea name=news cols=40 rows=8 value=".$myrow['news']."><br>";
 
becomes:
 
<b>News:</b><textarea name="news" cols="40" rows="8"><?=$myrow['news']?></textarea>

If you didn't already know, the "<?=" is the same as "<? echo" - just a useful shorthand.

September 7th, 2002, 03:58 PM

russ

Join Date: Apr 2007

Location: London, UK

Posts: 129

Time spent in forums: < 1 sec
Reputation Power: 2

RE: crazy edit thingy

thank you man

September 7th, 2002, 04:02 PM

Nimco

Join Date: Apr 2007

Posts: 132

Time spent in forums: < 1 sec
Reputation Power: 2

RE: crazy edit thingy

No problem

September 8th, 2002, 03:18 PM

Join Date: Apr 2007

Posts: 7

Time spent in forums: < 1 sec
Reputation Power: 0

RE: crazy edit thingy

I'll tell you one trick..

if you do your brackets always like this...

php Code:

Original - php Code
if (etc == etc) { dothis.. and this.. and this... }

 
if (etc == etc)
{
     dothis..
     and this..
     and this...
}

rather than this..

php Code:

Original - php Code
if () { do this }

 
if () {
   do this
}

it makes it text times easier to see what is going on, and where each of your code blocks are.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: