Free PHP scripts

Why dont you offer THIS Comment-system to download?

Hi Linuxfan,

I've just started putting some more or less simple scripts online. This comment system is more complex as it contains PHP, JavaScript, a JavaScript library, CSS and some images. That shouldn't prevent me from creating a downloadable version, but first I want to fill the other sections on this page (HTML, CSS, JavaScript, MySQL) with some content, although they are not as large as the PHP section.

Anyway, check back soon!
lgp

Hello
I have problems to install "NEWS MANAGER"
i put all the mysql informations in the config file but wenn i write a news there is standing: Inserting entry failed: Table 'massive-base_nes.news_manager' doesn't exist"

What is do to?

greetz
RB

Hi RB,

you need to call the "install.php" in your webbrowser first. This will install the MySQL table.

lgp

Thank you very much!
greetz
RB

Will you help me, I set up all the Easy Newsletter files to my website and when I try to send email with it , it then says Email sent..
I go check my inbox and email never sent please help

Hi SLEEPAH,

this problem might have two reasons:

1. The email cannot be sent.
Check your PHP configuration on your server and the SMTP gateway which is used. Are you able to send any emails from other PHP files on your server? If you can, this is not the problem.

2. The email was sent but did not arrive.
Are you able to send emails from any other PHP file on your server to your email-address? If so, check your spam folder. Otherwise, there might be a problem with your email-provider.

lgp

Dude,
are you crazy?
You can't just give you readers these crappy codes!
Most of them are highly insecure and apparently you never even heard about SQL-Injections before. All your codes lack even basic security features.
Try out the following request-parameter on "MySQL shoutbox v1":
'), ('INFO', CONCAT(CHAR(60), 'script type="text', '/javascript"' ,CHAR(62), 'alert("Do NOT use this script on your site! It is not save!");', CHAR(60), '/script', CHAR(62))), ('INFO2', '-.-

I think somebody like you should not write tutorials.

Thanks for nice scripts! :)

@Hellllloooo???

A bit harsh, and while I understand the necessity for security (been hacked once or twice myself, so I know the pain), that "bastard operator from hell" attitude just makes you look like a grinchy prick. Instead of going the negativity route, why don't you sit down in front of your box, and craft up "superior" versions of what the code is supposed to be like (IYCO) and distribute that all over the net and bring some sort of value to that stank wind blowin' outta yer piehole. You remind of that buncha squacks over @ Digitalpoint Forums - all talkin' shite, but no coding skills to back it up (in 70% of the sadness brigade over there)

probando

Hi,

Is there anyway that I can include a validation email in the easy newsletter, so that when people fill in the form they have to validate it with a link?

Michael

Hi Michael Anderson,

of course there is, but you will have to add some code and alter the database:

- add a column "validated" with CHAR(1) to the database table
- in the subscription form, modify the INSERT-statement and add the validated-column with value "f" (like "false")
- after inserting the new row into the database, send an email to the newly subscribed email-address using the mail() function
- in this email, include a link to a new page called validate.php and add the email-address as parameter, e.g. justsubscribed@anydomain.com" target="_blank">http://youdomain.com/newsletter/validate.php?email=justsubscribed@anydomain.com
- create the page validate.php; in this page you need to update the correct row in the database table and set the validated-column to "t" (like "true"); use the parameter "email" as key
- when inserting a new address using the admin-interface, you can set the validated-column to "t" as default
- finally, when sending a new newsletter, add the validated-column to the query (&& validated='t') to send the newsletter only to validated addresses

That's it!
lgp

Hi lgp

Thanks for the info!! Much appreciated.

So I've got everything working apart from the actual validation link. and cant get my head round where to add the query (&& validated=\'t\')

I have added this to the script to send the email

@mysql_query("INSERT INTO $db_table (email,name,validated) VALUES ('$email','$name','No');");

//send confirmation email

$to = $_POST["email"];
$subject = "Reef Zone Aquatics Newsletter";

$message = "

TEST MESSAGE HERE

";

// Always set content-type when sending HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";

// More headers
$headers .= 'From: <newsletter@reefzoneaquatics.co.uk>' . "\r\n";

mail($to,$subject,$message,$headers);


//error occurred
if(@mysql_error()){
?>

I was trying to make the part that says TEST MESSAGE HERE to be a href link that says click here to verify your email address but i cant get the variable into the href.

I tried the following :

<?php
echo "<a href='http://domain.com/validate.php?email=" . $email . "'>TEXT</a>";
?>

but I keep getting an error. Is there a better way to do this?

Michael

Also sorry Im having trouble making the validate page code.

How do I update the table to make validate to yes instead of no?

Sorry for the hassle. Everything working now apart from when sending a newsletter. Having issues curbing it just to confirmed address'

Michael

Last question..... All is working A ok now, just took me some time to get it there....

LAst thing..... When I go to the admin section, ive got a footer setup with html code. but when the email is recieved all you can see is code. The formatting isnt working. Any ideas?

If you use HTML-tags in the newsletter, you need to send the email in text/html instead of text/plain. Otherwise the tags won't be interpreted and will be displayed incorrectly.

Hi again,

I have successfully added text links that allow a user to be removed from the database. I would like to add check boxes so that I can delete multiple entries on a button click. How would I go about this.

I have this as my code on the check box <input type="checkbox" name="checkdel" value="&del=<?php echo $row["id"]; ?>">
and this on my form code <form name="form2" method="post" action="<?php echo $_SERVER["PHP_SELF"]; ?>?pwd=<?php echo $pwd; ?>">

then when I try to add the mysql statements I get errors saying unexpected T_Else. I dont know where to put my sql query in the script.

Michael

To delete multiple rows, the name of the checkbox must be "checkdel[]". This way, you'll get an array of values server side.

The T_Else error normally comes from an open brace - check your code.

lgp

OK Thanks for info, Gave it a go but nothing happens. Heres what I have.

<form name="form2" method="post" action="<?php echo $_SERVER["PHP_SELF"]; ?>?pwd=<?php echo $pwd; ?>">
<input type="submit" name="checkdelsub" value="Submit">

<input type="checkbox" name="checkdel[]" value="&checkdel=<?php echo $row["id"]; ?>"> this is in the form

Then the script I have wrote is this...

}
//delete multiple entry
}else if(isset($checkdelsub)){

$deleteemail = @mysql_query("SELECT email FROM $db_table WHERE id=$checkdel;");
$row = @mysql_fetch_array($deleteemail);
$email2 = $row["email"];
@mysql_query("DELETE FROM $db_table WHERE id=$checkdel;");

//error occurred
if(@mysql_error()){
?><p>Deleting multiple entries failed: <?php echo @mysql_error(); ?></p>
<p><a href="javascript:history.back();">Click here to go back.</a></p><?php
//successful
}else{
?><p>Multiple entry delete successfully.

<?php

Getting no errors showing sorted out the T_Else. Just not getting anything deleting.....

Hi Michael,

you need to delete the rows using a loop, because you get an array, for example:

foreach($_POST["checkdel"] as $id){
@mysql_query("DELETE FROM $db_table WHERE id=$id;");
}

Of course you can add some echo-statements to print what happened (e.g. "deleting row $id failed" and "deleting row $id succeeded").

lgp

Just cant get the hang of it atall. Heres what I have, when I press the delete button it asks me for password.....

Form
<form name="checkdel" action="<?php echo $_SERVER["PHP_SELF"]; ?>?pwd=<?php echo $pwd; ?>">
Delete Button
<input type="submit" name="checkdel" value="Submit">
Checkbox
<input name="checkdel[]" type="checkbox" id="checkdel[]" value="<? echo $rows['id']; ?>">

Script
// Check if delete button active, start this

}foreach($_POST["checkdel"] as $id){
@mysql_query("DELETE FROM $db_table WHERE id=$id;");

You need to set the method of the form to post or put the parameters into input fields. First option is easier:

<form method="post" ... >

Hi
I'm building a website and I want to have a newsletter. Can you please tell me how I can get started? I've downloaded your PHP script, so now what do I do with it?
Thanks for the help.

LM

Hello,

Thanks for the scripts.
I'm using them for my thesis website on school.

I just saw in the newsletter that the mails are sent in spam box.
How can I fix that please?

Thanks ;-)