Ad:

PHP Discussion Thread
Unsolved
Views: 924

Oct 30th, 2007

Super newbie needs help

Expand Post »

I have written lots of php dealing with html strings, but it's my first time trying to get a very simple page to function. It has a textarea, and I guess that all I need to do is get the text into the database on the server. I really have no idea how to go about this, and I'm so frustrated that I can't find what I'm looking for. It's simple (again, guessing) as all there is, for now, is the text area. The client (user) types in some text, sends it, after previewing it through my nifty string work :-) and it goes to the database. It would be very nice of someone to walk me through this. I'm the type of learner who needs guidance over "solutions". Sorry if I seem dumb, but I just need help. I'm only a hobbyist programmer.

Similar Threads

As a newbie, where i should start from in linux? in Getting Started and Choosing a Distro
downloading from the net is incomplete! in Web Browsers
How to network two Win98 machines in Networking
What super power would you most likely want? in Geeks' Lounge

tefflox

Reputation Points: 12

Solved Threads: 1

Junior Poster

Offline

174 posts
since Jul 2006

Permalink

Oct 30th, 2007

Re: Super newbie needs help

My html:

PHP Syntax (Toggle Plain Text)
<form action="insert.php" method="post" name="form"> <br/><span style="position:relative: left: -20%; font-size: small;"></span><br/>
<textarea name="text" id="DynamicText" style="font-family: arial, helvetica, sans-serif; font-size: large;" cols="100" rows="5" wrap="soft" onclick="document.form.text.value='';">
Lorem ipsum . . .
  </textarea>
  <br/>
  <br/>
<input type="button" value="Preview" onclick="reloadTextDiv();" />
  </form>
<form action="insert.php" method="post" name="form"> <br/><span style="position:relative: left: -20%; font-size: small;"></span><br/>
<textarea name="text" id="DynamicText" style="font-family: arial, helvetica, sans-serif; font-size: large;" cols="100" rows="5" wrap="soft" onclick="document.form.text.value='';">
Lorem ipsum . . .
  </textarea>
  <br/>
  <br/>
<input type="button" value="Preview" onclick="reloadTextDiv();" />
  </form>

PHP:

PHP Syntax (Toggle Plain Text)
  $username = "-------";
  $password = "-------";
  $database = "----";
 
  $text = $_POST['text']; 
 
  mysql_connect("mysql.gravityway.com", $username, $password); 
 
  @mysql_select_db($database) or die("Unable to select database"); 
 
  $query = "INSERT INTO ---- VALUES ('','$first')";
 
  mysql_query($query);
 
  mysql_close();
  $username = "-------";
  $password = "-------";
  $database = "----";
  
  $text = $_POST['text']; 
  
  mysql_connect("mysql.gravityway.com", $username, $password); 
  
  @mysql_select_db($database) or die("Unable to select database"); 
  
  $query = "INSERT INTO ---- VALUES ('','$first')";
  
  mysql_query($query);

  mysql_close();

Last edited by tefflox; Oct 30th, 2007 at 5:14 am.

tefflox

Reputation Points: 12

Solved Threads: 1

Junior Poster

Offline

174 posts
since Jul 2006

Permalink

Oct 30th, 2007

Re: Super newbie needs help

Here is my progress. I have connected to the localhost database and inserted text.

Insertion code:

PHP Syntax (Toggle Plain Text)
<?php
 
  $username = "root";
  $password = "-------";
  $database = "grav";
  $host     = "localhost";
 
  $text = $_POST['text']; 
 
  $cid  = mysql_connect($host, $username, $password); 
 
  if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }
 
  if ($_SERVER['REQUEST_METHOD'] == "POST") {
/*
  // the following 4 lines are needed if your server has register_globals set to Off
  $category = $_POST['category'];
  $sitename = $_POST['sitename'];
  $siteurl = $_POST['siteurl'];
  $description = $_POST['description'];
*/
  $SQL = " INSERT INTO posts VALUES ('', '$text')";
 
  $result = mysql_db_query($database, $SQL, $cid);
 
  if (!$result) {
      echo("ERROR: " . mysql_error() . "\n".$SQL."\n"); }
  else
      echo ("New Post Added\n");
 
  }
 
  mysql_close($cid);  
 
 
?>
<?php

  $username = "root";
  $password = "-------";
  $database = "grav";
  $host     = "localhost";
  
  $text = $_POST['text']; 
  
  $cid  = mysql_connect($host, $username, $password); 
  
  if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }
  
  if ($_SERVER['REQUEST_METHOD'] == "POST") {
/*
  // the following 4 lines are needed if your server has register_globals set to Off
  $category = $_POST['category'];
  $sitename = $_POST['sitename'];
  $siteurl = $_POST['siteurl'];
  $description = $_POST['description'];
*/
  $SQL = " INSERT INTO posts VALUES ('', '$text')";
  
  $result = mysql_db_query($database, $SQL, $cid);

  if (!$result) {
      echo("ERROR: " . mysql_error() . "\n".$SQL."\n"); }
  else
      echo ("New Post Added\n");

  }

  mysql_close($cid);  
  
     
?>

I need help with retrieving the data. This is mainly copynpaste code, but it's a start. I get an unknown category error. The table has two columns, the int key and a text field.

PHP Syntax (Toggle Plain Text)
<?php
 
  $username = "root";
  $password = "-------";
  $database = "grav";
  $host     = "localhost";
 
    # connect to database
    $cid = mysql_connect($host,$username,$password);
    if (!$cid) { echo("ERROR: " . mysql_error() . "\n");    }
?>
<html>
 <head>
  <title>Display Posts</title>
 </head>
 <body>
 
<?php
    $category = "Posts";
 
    # setup SQL statement
    $SQL = " SELECT * FROM posts WHERE category = '$category' ";
 
    # execute SQL statement
    $retid = mysql_db_query($database, $SQL, $cid);
 
    # check for errors
    if (!$retid) { echo( mysql_error()); }
      else {
 
          # display results
          echo ("<h3><b>$category</b></h3>\n");
           while ($row = mysql_fetch_array($retid)) {
              $post = $row["post"];
              echo ($post."<br/>\n");
          }
    }
?>
 
</body>
</html>
<?php

  $username = "root";
  $password = "-------";
  $database = "grav";
  $host     = "localhost";

    # connect to database
    $cid = mysql_connect($host,$username,$password);
    if (!$cid) { echo("ERROR: " . mysql_error() . "\n");    }
?>
<html>
 <head>
  <title>Display Posts</title>
 </head>
 <body>
 
<?php
    $category = "Posts";

    # setup SQL statement
    $SQL = " SELECT * FROM posts WHERE category = '$category' ";

    # execute SQL statement
    $retid = mysql_db_query($database, $SQL, $cid);

    # check for errors
    if (!$retid) { echo( mysql_error()); }
      else {

          # display results
          echo ("<h3><b>$category</b></h3>\n");
           while ($row = mysql_fetch_array($retid)) {
              $post = $row["post"];
              echo ($post."<br/>\n");
          }
    }
?>

</body>
</html>

tefflox

Reputation Points: 12

Solved Threads: 1

Junior Poster

Offline

174 posts
since Jul 2006

Permalink

Oct 30th, 2007

Re: Super newbie needs help

Quote ...

I need help with retrieving the data. This is mainly copynpaste code, but it's a start. I get an unknown category error. The table has two columns, the int key and a text field.
PHP Syntax (Toggle Plain Text)
<?php
 
  $username = "root";
  $password = "-------";
  $database = "grav";
  $host     = "localhost";
 
    # connect to database
    $cid = mysql_connect($host,$username,$password);
    if (!$cid) { echo("ERROR: " . mysql_error() . "\n");    }
?>
<html>
 <head>
  <title>Display Posts</title>
 </head>
 <body>
 
<?php
    $category = "Posts";
 
    # setup SQL statement
    $SQL = " SELECT * FROM posts WHERE category = '$category' ";
 
    # execute SQL statement
    $retid = mysql_db_query($database, $SQL, $cid);
 
    # check for errors
    if (!$retid) { echo( mysql_error()); }
      else {
 
          # display results
          echo ("<h3><b>$category</b></h3>\n");
           while ($row = mysql_fetch_array($retid)) {
              $post = $row["post"];
              echo ($post."<br/>\n");
          }
    }
?>
 
</body>
</html>
<?php $username = "root"; $password = "-------"; $database = "grav"; $host = "localhost"; # connect to database $cid = mysql_connect($host,$username,$password); if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); } ?> <html> <head> <title>Display Posts</title> </head> <body> <?php $category = "Posts"; # setup SQL statement $SQL = " SELECT * FROM posts WHERE category = '$category' "; # execute SQL statement $retid = mysql_db_query($database, $SQL, $cid); # check for errors if (!$retid) { echo( mysql_error()); } else { # display results echo ("<h3><b>$category</b></h3>\n"); while ($row = mysql_fetch_array($retid)) { $post = $row["post"]; echo ($post."<br/>\n"); } } ?> </body> </html>

please replace this part of your code:

php Syntax (Toggle Plain Text)
<?php
    $category = "Posts";
 
    # setup SQL statement
    $SQL = " SELECT * FROM posts WHERE category = '$category' ";
 
    # execute SQL statement
    $retid = mysql_db_query($database, $SQL, $cid);
 
    # check for errors
    if (!$retid) { echo( mysql_error()); }
      else {
 
          # display results
          echo ("<h3><b>$category</b></h3>\n");
           while ($row = mysql_fetch_array($retid)) {
              $post = $row["post"];
              echo ($post."<br/>\n");
          }
    }
?>
<?php
    $category = "Posts";

    # setup SQL statement
    $SQL = " SELECT * FROM posts WHERE category = '$category' ";

    # execute SQL statement
    $retid = mysql_db_query($database, $SQL, $cid);

    # check for errors
    if (!$retid) { echo( mysql_error()); }
      else {

          # display results
          echo ("<h3><b>$category</b></h3>\n");
           while ($row = mysql_fetch_array($retid)) {
              $post = $row["post"];
              echo ($post."<br/>\n");
          }
    }
?>

with this one:

php Syntax (Toggle Plain Text)
$category = "Posts";
 
    # setup SQL statement
    $SQL = " SELECT * FROM posts WHERE category = '$category' ";
 
    # execute SQL statement
    $retid = mysql_query($query);
  $result=mysql_query($retid) or die (mysql_error());
   $num=mysql_num_rows($result);
 
# display results
while ($i<$num)
{
  $post=mysql_result($result,$i,"post");
echo "<h3><b>'.$category.'</b></h3>\n";
echo $post;          
$i++;
}
$category = "Posts";

    # setup SQL statement
    $SQL = " SELECT * FROM posts WHERE category = '$category' ";

    # execute SQL statement
    $retid = mysql_query($query);
  $result=mysql_query($retid) or die (mysql_error());
   $num=mysql_num_rows($result);
 
# display results
while ($i<$num)
{
  $post=mysql_result($result,$i,"post");
echo "<h3><b>'.$category.'</b></h3>\n";
echo $post;          
$i++;
}

I think that you are getting an unknown column because the field "post" is not the column name of what you are trying to display.
Look at your database, look what field do you want to display and replace "post" in

php Syntax (Toggle Plain Text)
  $post=mysql_result($result,$i,"post");
  $post=mysql_result($result,$i,"post");

with that field.
Or better yet please display here all your table fields so I can guide you.

ryan_vietnow

Reputation Points: 28

Solved Threads: 71

Posting Pro

Offline

578 posts
since Aug 2007

Permalink

Oct 31st, 2007

Re: Super newbie needs help

Hi, thanks. Your code works with the following change: $SQl = " SELECT post FROM posts ";

tefflox

Reputation Points: 12

Solved Threads: 1

Junior Poster

Offline

174 posts
since Jul 2006

Permalink

Oct 31st, 2007

Re: Super newbie needs help

Actually, there are problems with the code provided. I had mistakenly copied my own back in. This works ---

PHP Syntax (Toggle Plain Text)
  # setup SQL statement
  $SQL = " SELECT post FROM posts ";
 
  # execute SQL statement
  $retid = mysql_db_query($database, $SQL, $cid);
 
  # check for errors
  if (!$retid) { echo( mysql_error()); }
 
  else {
 
    # display results
    echo ("<h3><b>Posts</b></h3>\n");
 
    while ($row = mysql_fetch_array($retid)) {
      $post = $row["post"];
      echo ($post."<br/>\n");
    }
  }
  # setup SQL statement
  $SQL = " SELECT post FROM posts ";

  # execute SQL statement
  $retid = mysql_db_query($database, $SQL, $cid);
 
  # check for errors
  if (!$retid) { echo( mysql_error()); }

  else {

    # display results
    echo ("<h3><b>Posts</b></h3>\n");

    while ($row = mysql_fetch_array($retid)) {
      $post = $row["post"];
      echo ($post."<br/>\n");
    }
  }

tefflox

Reputation Points: 12

Solved Threads: 1

Junior Poster

Offline

174 posts
since Jul 2006

Permalink

Oct 31st, 2007

Re: Super newbie needs help

so,that's why I am wondering on where did you get that SQL statement.Actually mysql_fetch_array is another way of displaying data but for me my way of displaying data is what I have shown.But anyway,it's still the same!

ryan_vietnow

Reputation Points: 28

Solved Threads: 71

Posting Pro

Offline

578 posts
since Aug 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: PHP Prerequisite?

Next Thread in PHP Forum Timeline: Export RSS 1.0 or 2.0 feeds to an array

DaniWeb Message

Cancel Changes

User Name
Password