Tuesday, May 20, 2008

i have to do a project on php and mysql?

Does this look right? Read the edit below for more information.

<?php
$database = "private";

mysql_connect ("private"- "private"- "private");
mysql_select_db($database) or die( "mysql_error()");

if (isset($_POST[ post ])){
$link= htmlspecialchars(addslashes($_POST[ link ]));
$text= htmlspecialchars(addslashes($_POST[ text ]));
mysql_query("INSERT INTO leftnav (link-text) VALUES ( $link - $text )");
}

?>

<?php

if($_SERVER[ REMOTE_ADDR ] == private )
{
echo "
<div id= lheading >private</div>
<form method= post >
<center>
<font family= helvetica size= 1 >
Link: <input type= text name= link style= width:70px; font-family:helvetica; font-size:10px; ><br>
Text: <input type= text name= text style= width:70px; font-family:helvetica; font-size:10px; ><br>
<input type= submit value= submit style= width:100px; font-family:helvetica; font-size:10px; >
</font>
</center>
</form>
";
}
else {
print "";
}
?>
I get NO error messages at all- and it just won t insert the information into the table. What s wrong? Whenever I import information on pmA it works just fine.

i need it to be linux- to have Mysql Databases- to have installer of free apps (like limesurvey-xoops-etc)- TO BE ABLE TO HOLD AT LEAST 3 DIFFERENT DOMAINS- to be trustable- and to have other standard functionalities of course.

in the $4 a month price range- any suggestions?

hi please read til the end :

i want to setup a server using windows xp prof .. i know that we need to install IIS ..but i need to install IIS with php and mysql database....and i need the server to be reachable publically (not only local)...

i feel confused so i need advice what to do :

1.is the info in this page enough to setup php with IIS and mysql (and make the website public).

http://news.softpedia.com/news/How-to-install-PHP-on-IIS-63075.shtml

2.as iam going to buy the server soon..do i need to apply those steps as a test on my laptop..or its ok to wait for the server and do the work on there..

this is very important...thank you very much..

I m working on a newsletter script that might have to send mails to several email addresses stored in a database.

I am making a loop like this:

do {
if($result = mail( // [...]
} while ($addresses = mysql_fetch_assoc($addrQuery));

The problem is that the table might contain like hundred addresses. So here are my questions:

- How do I keep my script from running out of the execution time limit?
- Or is there a way to setup a process that will send a mail each 10 second so that the SMTP server won t be overloaded? This would be better than what I m trying to do now.

No comments: