Chief Delphi

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)
-   Programming (http://www.chiefdelphi.com/forums/forumdisplay.php?f=51)
-   -   php/forms/posting/I NEED HELP!!!!!!!!! (http://www.chiefdelphi.com/forums/showthread.php?t=45184)

general 08-03-2006 21:12
php/forms/posting/I NEED HELP!!!!!!!!!
 
I want to put a comment/quotes page on my teams site, and let people submit their own, but I don't know anything about php or any other database. Can some one help me?

chris31 09-03-2006 07:51
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
There are a few options. One is to use a free shoutbox type program. Another is to use php and log all of the comments to a text file. The last option is to use php and save it all to a database. The last will be the hardest to code but could allow for more features to be added. If i have any free tome today i will write you some sample code.

chris31 09-03-2006 11:14
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
CHeck out these links. http://www.project-angel.com/index.p...&cat=PHP&id=13 and http://www.project-angel.com/index.p...&cat=PHP&id=14 . Hopefully that will get you started. If you need any help just ask.

MattD 11-03-2006 23:59
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by chris31
There are a few options. One is to use a free shoutbox type program. Another is to use php and log all of the comments to a text file. The last option is to use php and save it all to a database. The last will be the hardest to code but could allow for more features to be added. If i have any free tome today i will write you some sample code.
I actually think that writing it to use a database (MySQL for example) would be easier than using the text file. That's just what I'd do, though. Either that or use XML..

chris31 12-03-2006 16:22
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by MattD
I actually think that writing it to use a database (MySQL for example) would be easier than using the text file. That's just what I'd do, though. Either that or use XML..
With a text file there would be no need for a MySQL database (not sure if he has one). Plus, he wouldnt need to know SQL or and knowledge of XML. WIth XML you have to parse all of it. With a text file he could just log everything as a line of text.

general 12-03-2006 17:32
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Could some one give me the code for the text file option.

chris31 12-03-2006 18:49
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Just to confirm what you want, you want a box that holds the posts of the shoutbox, under that you want a spot for people to input a nickname and message. Will that work for you? Also, do you know what version of php your webserver is running?

general 14-03-2006 14:43
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Here is the server info:

general 14-03-2006 15:02
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
And I would want it to look like this
http://www.khsfirst.com/insert.html for the submiting page, and http://www.khsfirst.com/Quotes.html for the pageit would show up on.

Uberbots 14-03-2006 15:45
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
ya know, it would be a ton easier to just use a database.
if you have PHPmyAdmin, then use it.

PHP Code:
mysqlServer = mysql_pconnect("server","username","password") //server is typically "127.0.0.1"
mysql_select_db("siteData", mysqlServer);

$getNews = mysql_query("SELECT * FROM `news` ORDER BY `id` DESC");
$rowGetNews = mysql_fetch_assoc($getNews);
$numRowsGetNews = mysql_num_rows($getNews);

do {
echo $rowGetNews['body'];
} while($rowGetNews = mysql_fetch_assoc($getNews)); 
im assuming that you have a database, schema name "siteData", with a table called "news".
columns should be AT LEAST:
id INTEGER AUTO_INCREMENT, title VARCHAR(35), body TEXT


adding news to the DB is a different story.

general 14-03-2006 17:54
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Ya what is PHPmyAdmin? And how do I Use it?

chris31 15-03-2006 08:01
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by general
Ya what is PHPmyAdmin? And how do I Use it?
phpMyAdmin is a php based MySQL admin tool. If you have CPanel then it is included, else you have to set it up.

The databases can be created without phpMyAdmin. I can write up some code for inputing data and createing the tables if you want me to. Also, can you find out if your webserver supports PHP and if so what version. If you cant find it, please post a link to the people who provide your hosting.

EDIT: I wrote this up quickly so its not that great but it will work.


PHP Code:
Database Layout

Database --> "siteData"
Table --> "news"
columns --> id INTEGER AUTO_INCREMENT, title VARCHAR(35), body TEXT


=================================

// Code for printing out all of the news

// Connecting, selecting database
$link = mysql_connect ("server","username","password") or die ('I cannot connect to the database because: ' . mysql_error());//Open up the specific database
mysql_select_db ("siteData");


$query = ""SELECT * FROM `news` ORDER BY `id` DESC"";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());


echo "<table>\n";
echo "\t<tr>\n";
echo "\t\t<td>Name</td>\n";
echo "\t\t<td>Post</td>\n";
echo "\t</tr>\n";


while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) 
{
   echo "\t<tr>\n";
   foreach ($line as $col_value) 
   {
       echo "\t\t<td>$col_value</td>\n";
   }
   echo "\t</tr>\n";
}
echo "</table>\n";


=================================

// Code for adding news to the db

Add Post

<FORM ACTION="<?=$PHP_SELF?>" METHOD="POST" NAME="newsentry" type="text">

Name:

<BR>

<INPUT TYPE="text" SIZE="50" NAME="name" type="text">

<BR>

Post:

<BR>

<INPUT TYPE="text" SIZE="50" NAME="post" type="text">

<BR>


<INPUT TYPE="submit" NAME="submit" VALUE="Submit">
<BR>


</FORM>

<?

if($HTTP_POST_VARS['submit'])
{

        if(!$HTTP_POST_VARS['name'])
        {
            echo "You must enter a name";
            exit;
        }
        if(!$HTTP_POST_VARS['post'])
        {
            echo "You must enter a post";
            exit;
        }


    $query = "INSERT INTO news VALUES ('', '$HTTP_POST_VARS['name']', '$HTTP_POST_VARS['post']')";
     $result = mysql_query($query);
}

?>

MattD 15-03-2006 15:57
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by chris31
phpMyAdmin is a php based MySQL admin tool. If you have CPanel then it is included, else you have to set it up.

The databases can be created without phpMyAdmin. I can write up some code for inputing data and createing the tables if you want me to. Also, can you find out if your webserver supports PHP and if so what version. If you cant find it, please post a link to the people who provide your hosting.

EDIT: I wrote this up quickly so its not that great but it will work.


PHP Code:
Database Layout

Database --> "siteData"
Table --> "news"
columns --> id INTEGER AUTO_INCREMENT, title VARCHAR(35), body TEXT


=================================

// Code for printing out all of the news

// Connecting, selecting database
$link = mysql_connect ("server","username","password") or die ('I cannot connect to the database because: ' . mysql_error());//Open up the specific database
mysql_select_db ("siteData");


$query = ""SELECT * FROM `news` ORDER BY `id` DESC"";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());


echo "<table>\n";
echo "\t<tr>\n";
echo "\t\t<td>Name</td>\n";
echo "\t\t<td>Post</td>\n";
echo "\t</tr>\n";


while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) 
{
   echo "\t<tr>\n";
   foreach ($line as $col_value) 
   {
       echo "\t\t<td>$col_value</td>\n";
   }
   echo "\t</tr>\n";
}
echo "</table>\n";


=================================

// Code for adding news to the db

Add Post

<FORM ACTION="<?=$PHP_SELF?>" METHOD="POST" NAME="newsentry" type="text">

Name:

<BR>

<INPUT TYPE="text" SIZE="50" NAME="name" type="text">

<BR>

Post:

<BR>

<INPUT TYPE="text" SIZE="50" NAME="post" type="text">

<BR>


<INPUT TYPE="submit" NAME="submit" VALUE="Submit">
<BR>


</FORM>

<?

if($HTTP_POST_VARS['submit'])
{

        if(!$HTTP_POST_VARS['name'])
        {
            echo "You must enter a name";
            exit;
        }
        if(!$HTTP_POST_VARS['post'])
        {
            echo "You must enter a post";
            exit;
        }


    $query = "INSERT INTO news VALUES ('', '$HTTP_POST_VARS['name']', '$HTTP_POST_VARS['post']')";
     $result = mysql_query($query);
}

?>
Ah, so you are going to go with the MySQL option. Honestly, to me that seems much more easier than using a text file..

Oh by the way (correct me if I am wrong), I see a SQL injection vulnerability in your code. It's not as if it'll probably ever cause any real problems, it's just that it exists.

PHP Code:
$query = "INSERT INTO news VALUES ('', '$HTTP_POST_VARS['name']', '$HTTP_POST_VARS['post']')"; 
Plain text posted is being inserted into the query. So, in theory, someone could submit something that could potentially alter the query. My advice would be to look into using the mysql_escape_string() or the mysql_real_escape_string() function.

Uberbots 15-03-2006 16:19
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by MattD
Plain text posted is being inserted into the query. So, in theory, someone could submit something that could potentially alter the query. My advice would be to look into using the mysql_escape_string() or the mysql_real_escape_string() function.
Or, he could just make sure that no one but an administrator can get to that page. Dont execute the query if you arent logged in!


PHP Code:
if ($_SESSION['UserClass'] == 'Admin') { } 
or something like that. but if you do that, you would need to setup a login system.
I used to have a bunch of tutorials that i made about how to do this stuff.

MattD 15-03-2006 16:26
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by Uberbots
Or, he could just make sure that no one but an administrator can get to that page. Dont execute the query if you arent logged in!
Well, sure.. but that still doesn't solve the SQL injection vulnerability. I think he wants just anyone to be able to submit, anyway.

Uberbots 15-03-2006 16:38
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by MattD
Well, sure.. but that still doesn't solve the SQL injection vulnerability. I think he wants just anyone to be able to submit, anyway.
oh yeah, i didnt think of that.


PHP Code:
$postName = get_magic_quotes_gpc() ? addslashes($_POST['name']) : $_POST['name'];
$postPost = get_magic_quotes_gpc() ? addslashes($_POST['post']) : $_POST['post'];
sprintf("INSERT INTO `news` VALUES ('', '%s', '%s')"); 

chris31 15-03-2006 20:28
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Yea, definatly fix that. I didnt really thing about security as i dont even know if he has PHP or if he is even going to use the code. If he is then with all SQL statements YOU MUST CHECK FOR INJECTION VULNERABILITIES. Its not cool. There are lots of features and fixes the code could use, i mean i wrote it quickly during class.

MattD 15-03-2006 20:43
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by chris31
Yea, definatly fix that. I didnt really thing about security as i dont even know if he has PHP or if he is even going to use the code. If he is then with all SQL statements YOU MUST CHECK FOR INJECTION VULNERABILITIES. Its not cool. There are lots of features and fixes the code could use, i mean i wrote it quickly during class.
Yes, that is very important. There's always going to be that one person who wastes their time trying to find an exploit like that, and then use it to do real damage.

By the way.. you're not the only one who likes to write things quickly during class. In history class I once wrote a simple math game (I was bored, don't ask).. although it didn't turn out all that great.

general 15-03-2006 23:48
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 

chris31 16-03-2006 07:08
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
I looked at your webhost and they have PHP. Make a file called "junk.php" and in it write
PHP Code:
<?
phpinfo();
?>
and then see what version of PHP you are running. Also, if you post the code to the pages you want this added to we can added the code to the page for you.

general 16-03-2006 14:17
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
its version 4.3.4 heres the link

chris31 16-03-2006 14:27
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Ok, thank you. If you have any questions setting it up just ask.

MattD 16-03-2006 14:42
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Databases: 0/0
Well, it looks like the MySQL option is out then, so it's back to using some sort of text file (could be plain text, XML, INI, whatever).

I'll see if maybe I can write some code up for this later today.

chris31 16-03-2006 14:59
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
On the WebRyders website is shows that all hosting plans come with a database. I wonder why you dont have any.

general 16-03-2006 15:01
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Maybe because its old and we probably got it for free.

chris31 16-03-2006 17:54
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Ok, if i were you i would see if you could get databases becuase they can be used for so much. If not, then use a text file.

general 16-03-2006 19:18
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
When it comes to this (text file) I have no clue what to do.

chris31 16-03-2006 20:36
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Basicly i would say this. Write each post to a line in the file. Use a "|" between the users name, email, post, post number, etc (whatever info you need saved). Then just read in each line, expode the string by "|". And then echo is out. Ill post some code shortly.

MattD 17-03-2006 16:06
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Well here's a simplistic example (I have tested it for about 45 seconds, it seems to work). It takes the quote submitted and writes HTML to a text file, and then on the quote view page all it does is read that text file and output all of the HTML in it.

I would also like to add that I haven't really put in any error handling yet for the most part (I've only been working on this for about 10 minutes).

Anyway, here it is.

insert.php - This allows the user to enter their quote.
PHP Code:
<?php
//*************************************************
// insert.php - Allows a user to insert a quote.
//*************************************************

@$name = $_POST["name"];            // Get Name posted
@$team = $_POST["team"];            // Get Team Number posted
@$quote = $_POST["quote"];            // Get quote posted
@$submit = $_POST["submit"];        // Used to check if form is being submitted
/* NOTE: 
    The @ characters are here to supress undefined error messages,
    just in case the server has those turned on, like my dev/testing
    server does..
*/

if ($submit == "Submit")        // If the form is being submitted..
{
    if (empty($name) || empty($team) || empty($quote))        // Make sure all fields are filled in
    {
        echo "<span style=\"color: red\">Error: Please fill in all of the fields.</span><br />";
        showForm();
    }
    else
    {
        $hfile = fopen("quotes.dat", "r+") or die("Could not open file");    // Open data file
        
        // Compile text to be written
        $write = "<p>Quote- \"" . $quote . "<br />" . 
                   "</p><div align=\"right\">" . $name . "<br />" . 
                 $team . "</div></p><hr />";                    
                 
        fwrite($hfile, $write);            // Write the text
        fclose($hfile);                    // Close the file    
        
        // Notify the user that thier quote has been submitted
        echo "Thanks, your quote has been submitted.";            
    
    }
}
else
    showForm();
    
/***************************
Shows the input form
****************************/
function showForm()
{
?>
<blockquote>
    <form name="form1" method="post" action="insert.php">
          <p align="left">
            Name/Screen Name:<br />
            <input name="name" type="text" />    
            <br />
            Team Number: <br />
            <input name="team" type="text" />
            <br />
            <br />
            Quote:<br />
            <textarea name="quote" rows="4" cols="75"></textarea>
            <br />
            <br />
            <input type="submit" name="submit" value="Submit">
        </p>
    </form>
</blockquote>
<?php
}
?>
quotes.php - This displays all of the quotes that are saved.
PHP Code:
<?php
//*************************************************
// quotes.php - Displays user submitted quotes.
//*************************************************

$hfile = fopen("quotes.dat", "r") or die("Could not open file");    // Open the data file for reading
$contents = fread($hfile, filesize("quotes.dat"));    // Read the entire contents of the file
fclose($hfile);            // Close the file

echo $contents;            // Output file contents;
?>
Save this in files called insert.php and quotes.php. Then outside everything within the <?php and ?> tags, enter in all of the HTML for your site's header and footer. You must then create a file called quotes.dat in the same directory as insert.php and quotes.php. Make sure to CHMOD it to allow writing to it.

If you need any more help with this, don't hesitate to ask.

chris31 17-03-2006 17:43
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
This code isnt very portable. Say they do a site resign all the posts would have to be manually redone becuase you saved all html and not just the pure data. I think that my way is more portable. Ill scrap together some code soon.

Adam Richards 17-03-2006 17:57
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by chris31
This code isnt very portable. Say they do a site resign all the posts would have to be manually redone becuase you saved all html and not just the pure data. I think that my way is more portable. Ill scrap together some code soon.
Then you edit the page so it uses a really basic syntax, and calls some classes from a seperate CSS file.

chris31 17-03-2006 18:04
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by Adam Richards
Then you edit the page so it uses a really basic syntax, and calls some classes from a seperate CSS file.
He asked for a php driven shoutbox and i think he (and any who feels like using the code) should be able to do whatever with it. Not be forced to use CSS. Anyways, heres some quick code.

PHP Code:
<html>
<head>
</head>
<body>
<?
if($HTTP_POST_VARS['submit'])
{

        if(!$HTTP_POST_VARS['name'])
        {
            echo "You must enter a name";
            exit;
        }
        if(!$HTTP_POST_VARS['post'])
        {
            echo "You must enter a post";
            exit;
        }
        if(!$HTTP_POST_VARS['team'])
        {
            echo "You must enter a team";
            exit;
        }
        if(strstr($HTTP_POST_VARS['name'],"|"))
        {
            echo "Name cannot contain the pipe symbol - |";
            exit;
        }
        if(strstr($HTTP_POST_VARS['team'],"|"))
        {
            echo "Team cannot contain the pipe symbol - |";
            exit;
        }
        if(strstr($HTTP_POST_VARS['post'],"|"))
        {
            echo "Post cannot contain the pipe symbol - |";
            exit;
        }


        $fp = fopen('data.txt','a');
        if(!$fp)
        {
            echo "Error opening file!";
            exit;
        }
        $line = $HTTP_POST_VARS['name'] . "|" . $HTTP_POST_VARS['team'] . "|" . $HTTP_POST_VARS['post'];
        $line = str_replace("\r\n","<BR>",$line);
        $line .= "\r\n";
        fwrite($fp, $line);
        if(!fclose($fp))
        {
            echo "Error closing file!";
            exit;
        }
}
?>


<FORM ACTION="<?=$PHP_SELF?>" METHOD="POST" NAME="register" type="text">

<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#859FA7" width="500" 
align="center" height="200" bgcolor="#F2F2F2">
<td width="100%" align="center">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
Register
<br>
<br>
<tr>
<table border="0" cellpadding="0" cellspacing="2" width="95%">
<tr><td bgcolor="#FFFFFF">Name:</td><td bgcolor="#FFFFFF"><input type="text" name="name"></td></tr>
<tr><td bgcolor="#FFFFFF">Team:</td><td bgcolor="#FFFFFF"><input type="text" name="team"></td></tr>
<tr><td bgcolor="#FFFFFF">Post:</td><td bgcolor="#FFFFFF"><input type="text" name="post"></td></tr>
<tr><td></td><td><input type="submit" name="submit" value="Post"></td></tr>
</table>
</td>
</tr>
</table>
</form>

</body>
</html>
PHP Code:
<?
$data = file('data.txt');
foreach($data as $stuff) 
{
    $parts = explode("|", $stuff);
    echo "Name: " . $parts[0] . "<br>\n";
    echo "Team: " . $parts[1] . "<br>\n";
    echo "Post: " . $parts[2] . "<br>\n" . "<br>\n";
}
?>

MattD 17-03-2006 18:08
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by chris31
This code isnt very portable. Say they do a site resign all the posts would have to be manually redone becuase you saved all html and not just the pure data. I think that my way is more portable. Ill scrap together some code soon.
I agree with you (for the most part, because the posts could actually be redone by writing a program to modify the file, or just change them to be CSS dependent as Adam recommended). However I have been having a hard time trying to come up with a good way to store the data in a text file. Using a character like "|" as a delimiter could work, but what if the user wants to enter a "|" into their message?

I think XML would be a good storage method.

Example:
Code:
<quotes>
    <entry>
          <name>Matt</name>
          <team>228</team>
          <quote>Some random quote..</quote>
    </entry>
</quotes>
The problem with this of course is that it would be a pain to parse out, at least as far as I know, because I have no experience with using PHP and XML together. I should go and check my books and see if they have anything about it. If not, there's always Google)

Another option, I suppose, would be to use an INI-style storage method... though that could become problematic when new line characters are entered.
This reminds me that in my previous code I failed to handle those by replacing them with <br /> .. along with doing a bunch of other cleaning that I would normally do, like check for JavaScript and deal with HTML entities. And that's where this whole thing can get much more complicated than it would normally need to be - security, user formatting features, ensuring HTML validation, etc..

This is what happens after using a database server like MySQL all the time. I'm having such a hard time trying to figure out a good, reliable storage method besides just dumping HTML into a file.

chris31 17-03-2006 18:14
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Using XML would definatly open up more options but it means the data has to be parsed and i have only ever done a little XML and PHP together. As for the problem with using the "|" charcter there is a simple solution. The PHP explode function uses a string, just pick something nobody will ever uses suck as "a2ufjf94u". It might not look pretty in you data file but it will do the trick.

MattD 17-03-2006 18:32
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by chris31
Using XML would definatly open up more options but it means the data has to be parsed and i have only ever done a little XML and PHP together. As for the problem with using the "|" charcter there is a simple solution. The PHP explode function uses a string, just pick something nobody will ever uses suck as "a2ufjf94u". It might not look pretty in you data file but it will do the trick.
http://keithdevens.com/software/phpxml

Looks like using XML could actually work, but I haven't tried using this yet. If I'm not doing anything tommorow (and possibly later tonight) I think I may want to play around with that.

Yay for learning (kind of) how to do new things.

general 17-03-2006 20:08
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
The code from the last page works at http://www.khsfirst.com/insert.php , but it only records one message.

general 17-03-2006 20:16
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
and theres some extra stuufffffff at the bottom

MattD 17-03-2006 20:20
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by general
The code from the last page works at http://www.khsfirst.com/insert.php , but it only records one message.
Oops..

On this line in insert.php:
PHP Code:
$hfile = fopen("quotes.dat", "r+") 
Change the "r+" to be "a"

I also noticed that there looks to be some RTF stuff in there.. did you create this file with Wordpad? You can probably just delete it, the script will recreate the file when a quote is submitted.

As much as I don't want to admit it.. I actually did a pretty sloppy job on this. I will work on improving it sometime during this weekend.

chris31 17-03-2006 20:49
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Might want to fix this http://www.khsfirst.com/quotes.php. Its looks like a mess. Also, the .dat is still being overwritten.

general 17-03-2006 21:35
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
where do i put quotes(" ") in the code so that they will show up around the quote on quotes.php?

general 17-03-2006 21:50
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
and can i have a href in the part where it says "thanks, your quote has been submited", or have it automaticly rediect to the quotes.php page?

MattD 18-03-2006 00:00
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by general
where do i put quotes(" ") in the code so that they will show up around the quote on quotes.php?
In input.php before it writes the quote to the file, add in &quot; before and after $quote like this:
PHP Code:
$write = "the HTML that is already there &quot;" . $quote . "&quot; the other HTML that is already there"; 
Quote:
Originally Posted by general
and can i have a href in the part where it says "thanks, your quote has been submited", or have it automaticly rediect to the quotes.php page?
In input.php, replace the line that says echo "Thanks.. blah blah" with this:
PHP Code:
?>
<script type="text/javascript">
<!--
window.location = "quotes.php";
//-->
</script>
Thanks, your quote has been submitted. <br />
<a href="quotes.php">Please click here if you are not redirected.</a>
<?php

general 18-03-2006 15:12
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Every time a ( ' ) is used, like in I'm theres a slash to.

MattD 18-03-2006 20:26
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by general
Every time a ( ' ) is used, like in I'm theres a slash to.
Ah.. ok in quotes.php try changing this line
PHP Code:
echo $contents; 
to this:
PHP Code:
echo stripslashes($contents); 

general 20-03-2006 15:21
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
yup that code worked, only two questions is there any way of limiting the words, not the amount, but like not allowing "$@#$@#$@#$@#" to be posted?

And, is there any way to send me an email that says there was a post?

general 20-03-2006 15:22
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
woooooooooo, like what happened when i used a swear in the last post.

MattD 20-03-2006 15:41
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by general
yup that code worked, only two questions is there any way of limiting the words, not the amount, but like not allowing "$@#$@#$@#$@#" to be posted?

And, is there any way to send me an email that says there was a post?
The most straight forward way to censor words posted that I can think of right now is to use the str_ireplace() function before writing the text to the file.

Here's an example of that (this should be in insert.php, before the fwrite() function call, but after the initial assignment of $write):
PHP Code:
$write = str_ireplace("badword1", "[beep]", $write);
$write = str_ireplace("badword2", "[beep]", $write);
// .. etc 
What this does is replace every instance of "badword1" and "badword2" with "[beep]"

As for sending an email notification, add this in insert.php (right before the echo "Thanks.." line would be a good spot)
PHP Code:
mail("you@email.com", "New Quote", "A new quote has been posted."); 

general 20-03-2006 16:21
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
does the [beep] or whatever have to be in the brakets?

general 20-03-2006 17:21
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
PHP Code:
<blockquote><p> &quot; " . $quote . " &quot; <br />" . "</p><div align=\"right\">" . $name . "<br />" . $teamname . "<br /> Team " . $teamnumber . "</div></p><hr></blockquote>";                    
          
            //I tried to put it here and it didnt work
        
        fwrite($hfile, $write);            // Write the text
        fclose($hfile);                    // Close the file 

general 20-03-2006 17:24
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
PHP Code:
<blockquote><p> &quot; " . $quote . " &quot; <br />" . "</p><div align=\"right\">" . $name . "<br />" . $teamname . "<br /> Team " . $teamnumber . "</div></p><hr></blockquote>";                    
          

        
        fwrite($hfile, $write);            // Write the text
        fclose($hfile);                    // Close the file    
        
        ?>

// the email thing didn't work either

mail("general975@gmail.com", "New Quote", "A new quote has been posted <h ref="http://www.khsfirst.com/quotes.php">CLICK HERE TO SEE IT</a>.");


<script type="text/javascript">
<!--
window.location = "quotes.php";
//-->
</script>

Thanks, your quote has been submitted. <br />
<a href="quotes.php">Please click here if you are not redirected.</a> 

MattD 20-03-2006 17:35
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by general
PHP Code:
<blockquote><p> &quot; " . $quote . " &quot; <br />" . "</p><div align=\"right\">" . $name . "<br />" . $teamname . "<br /> Team " . $teamnumber . "</div></p><hr></blockquote>";                    
          

        
        fwrite($hfile, $write);            // Write the text
        fclose($hfile);                    // Close the file    
        
        ?>

// the email thing didn't work either

mail("general975@gmail.com", "New Quote", "A new quote has been posted <h ref="http://www.khsfirst.com/quotes.php">CLICK HERE TO SEE IT</a>.");


<script type="text/javascript">
<!--
window.location = "quotes.php";
//-->
</script>

Thanks, your quote has been submitted. <br />
<a href="quotes.php">Please click here if you are not redirected.</a> 
The call to the mail function has to be done before the closing PHP tag ?>. Put it after fclose($hfile).

general 20-03-2006 18:47
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by MattD
The call to the mail function has to be done before the closing PHP tag ?>. Put it after fclose($hfile).
ok that works, but what a bout the profanity one?

general 20-03-2006 19:06
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
jk I SOLVED THE PROBLEM HECK YES!

general 20-03-2006 19:16
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
but another question on the mailto, do i put
PHP Code:
. $quote . 
if i want to have to quote be in the eamil?

MattD 20-03-2006 19:25
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by general
but another question on the mailto, do i put
PHP Code:
. $quote . 
if i want to have to quote be in the eamil?
Yes, that works in the same way as above it with the assignment of $write.

Example:
PHP Code:
mail("you@email.com", "Quote Submission", "A new quote has been submitted:\r\n\r\n\"" . $quote . "\""); 

general 20-03-2006 19:30
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
really i just did it with
PHP Code:
mail("general975@gmail.com", "New Quote", "A new quote has been posted.  
 $quote, $name, $teamname, $teamnumber "); 

general 20-03-2006 19:31
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by MattD
Yes, that works in the same way as above it with the assignment of $write.

Example:
PHP Code:
mail("you@email.com", "Quote Submission", "A new quote has been submitted:\r\n\r\n\"" . $quote . "\""); 

whats the \r\n\r\n?

MattD 20-03-2006 19:32
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by general
whats the \r\n\r\n?
The \r\n\r\n is two line feeds, meaning it would skip a line before showing the quote.

general 20-03-2006 19:33
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
PHP Code:
mail("general975@gmail.com", "New Quote", "A new quote has been posted.  
 $quote, $name, $teamname, $teamnumber  <a href="http://www.khsfirst.com/quotes.php">click here to go to the page</a>"); 
can i do that ^^

MattD 20-03-2006 19:34
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by general
really i just did it with
PHP Code:
mail("general975@gmail.com", "New Quote", "A new quote has been posted.  
 $quote, $name, $teamname, $teamnumber "); 
Yeah, that works too. I just like to explicitly concatenate my strings. (Try saying that 3x fast..)

EDIT: Forgot to mention, the quotes inside of the string literal need to be escaped by preceding them with a \.
PHP Code:
"<a href=\"http://www.khsfirst.com/quotes.php\">click here to go to the page</a>" 

general 20-03-2006 19:35
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by MattD
Yeah, that works too. I just like to explicitly concatenate my strings. (Try saying that 3x fast..)
i don't even understand what you said

MattD 20-03-2006 19:40
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by general
i don't even understand what you said
Concatenation is the joining (or addition) or two or more strings of text. In PHP the string concatenation operator is "."

In most programming languages, when you want to add in the value of variable within a string of text, it must be concatenated with it, and not just within a string literal (everything inside the quotation marks) in order to be recognized. PHP picks up on the usage of variables inside of literals though, but I still like to use the concatenation operator. It's just a preference thing, really.

general 20-03-2006 20:05
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Thank you, all of you for all of your help!

general 21-03-2006 20:39
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
sry got another question, Will this work?( all of the second ones are the code ex. <-- &#33--> is " ! ")

$write = str_replace("!", "!", $write);
$write = str_replace("$", "$", $write);
$write = str_replace("&", "&", $write);
$write = str_replace("'", "'", $write);
$write = str_replace("(", "(", $write);
$write = str_replace(")", ")", $write);
$write = str_replace(",", ",", $write);
$write = str_replace(";", ";", $write);
$write = str_replace("?", "?", $write);
$write = str_replace("^", "^", $write);

And will two words work in a
PHP Code:
str_replac() 

Mike 21-03-2006 21:35
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by general
sry got another question, Will this work?( all of the second ones are the code ex. <-- &#33--> is " ! ")

$write = str_replace("!", "!", $write);
$write = str_replace("$", "$", $write);
$write = str_replace("&", "&", $write);
$write = str_replace("'", "'", $write);
$write = str_replace("(", "(", $write);
$write = str_replace(")", ")", $write);
$write = str_replace(",", ",", $write);
$write = str_replace(";", ";", $write);
$write = str_replace("?", "?", $write);
$write = str_replace("^", "^", $write);

And will two words work in a
PHP Code:
str_replac() 
Use arrays instead of a ton of str_replace calls.

Example:
$bad_words = array('guy', 'dog', 'cat');
$good_words = array('male', 'canine', 'feline');
$write = str_replace($good_words, $bad_words, $write);

MattD 21-03-2006 21:44
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by general
sry got another question, Will this work?( all of the second ones are the code ex. <-- &#33--> is " ! ")
If you're looking to handle HTML entities, I would just use the htmlentities() function, rather then hard-coding every entity that you want to have replaced.

PHP Code:
$write = htmlentities($write, ENT_QUOTES); 

general 21-03-2006 22:38
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
oh shoooooooooooot, all the str_replace s are case sensitive!!!!!!!!!!!!!!!!!!

Mike 21-03-2006 22:49
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by general
oh shoooooooooooot, all the str_replace s are case sensitive!!!!!!!!!!!!!!!!!!
Use str_ireplace
Same thing as str_replace, but case insensitive.

general 21-03-2006 22:51
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
Quote:
Originally Posted by Mike
Use str_ireplace
Same thing as str_replace, but case insensitive.
it dosent work in my version

general 29-03-2006 14:36
Re: php/forms/posting/I NEED HELP!!!!!!!!!
 
ok so it works great, but now theres like 25 quotes. I want to make a second page so you dont have to scroll forever to get to the bottom. Do i have to make a new database or can i use the same one?


All times are GMT -5. The time now is 22:59.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi