Jump to content

Archived

This topic is now archived and is closed to further replies.

techker

mysql sharing?

Recommended Posts


hey guys i have a login script that records emails when you register.there is a fonction in the admin panel to send emails.but it does not work.(sever does not support it)

so i installed a newsletter script.is it possible to link the msql file that saves the emails to my newsletter sql?

so when the register the email goes to both scripts.

thx
Edit/Delete Message

Share this post


Link to post
Share on other sites
I don't know what you mean by "goes to both scripts".  Why not simply have a single script that does both?

Share this post


Link to post
Share on other sites
well i have one but the sever is to slow to process the newsletter sit give me  a proxy error all the time .so i have a very good newsletter script that i use .but i would like to take the info from my login script for the newsletter script.

Share this post


Link to post
Share on other sites
It's going to be cumbersome to pass data via scripts... if it makes it's way into a DB, you'd be much better off.

Share this post


Link to post
Share on other sites
Well, you said your login script "records" e-mails... I assumed this was to a DB.  If so, your second script can simply pull from there.

Share this post


Link to post
Share on other sites
here is the list email page from the newsletter

  [code]<?php
    session_start();
    include "connect.php";
    ?>
    <link rel="stylesheet" href="style.css" type="text/css">
    <center><table border='0'><tr><td valign='top' width=30%>
    <?php
    if(isset($_SESSION['mailadmin']))
    {
      $numentries=20;
      include "left.php";
      print "</td>";
      print "<td valign='top' width=70%>";
      print "<table class='maintable'><tr class='headline'><td><center>List email addresses in ABC order</center></td></tr>";
      print "<tr class='mainrow'><td>";
      if(!isset($_GET['start']))
      {
        $start=0;
      }
      else
      {
        $start=$_GET['start'];
      } 
      $order="SELECT * from m_list where validated=1 order by address ASC";
      $order2=mysql_query($order) or die(mysql_error());
      $d=0;
      $f=0;
      $g=1+$d/$numentries;
      $num=mysql_num_rows($order2);
      print "<font color='#$fontcolor'>Page:</font> ";
      $prev=$start-$numentries;
      $next=$start+$numentries;
      if($start>=$numentries)
      {
        print "<A href='list.php?start=$prev'><<</a> ";
      }
      while($order3=mysql_fetch_array($order2))
      {
        if($f>=$start-3*$numentries&&$f<=$start+7*$numentries)
        {
          if($f%$numentries==0)
          {
            print "<A href='list.php?start=$d'>$g</a> ";
          }
        }
        $d=$d+1;
        $g=1+$d/$numentries;
        $f++;
      } 
      if($start<=$num-$numentries)
      {
        print "<A href='list.php?start=$next'>>></a> ";
      }
      print "<center><table class='maintable'><tr class='headline'><td>Address</td><td>Delete</td></tr>";
      $getaddress="SELECT * from m_list where validated='1' order by address ASC limit $start, 20";
      $getaddress2=mysql_query($getaddress) or die("Could not get address");
        while($getaddress3=mysql_fetch_array($getaddress2)
    )
      {
          print "<tr class='mainrow'><td>$getaddress3[address]</td><td><A href='deleteadd.php?ID=$getaddress3[mailid]'>Delete</a></td></tr>";
      }
      print "</table>";
      print "</td></tr></table>";
    }
    ?>

[/code]

and here is the page of members email

[code]
<?php
include 'config.php';


list($cookie, $tmpname) =
split("!", $_COOKIE[auth], 2);

if($cookie == "fook"){

$connection = mysql_connect($hostname, $user, $pass)
or die(mysql_error());
$db = mysql_select_db($database, $connection)
or die(mysql_error());

$sqlcheckaccount = "SELECT username FROM $userstable
WHERE username = '$tmpname'";

$resultcheckaccount = mysql_query($sqlcheckaccount)
or die ("Couldn't execute query.");
$numcheckaccount = mysql_num_rows($resultcheckaccount);
if($numcheckaccount == 0){
echo "Error, Username doesnt exist.";
die;
}

$sql = "SELECT * FROM $userstable ORDER BY username";

$result = mysql_query($sql)
or die ("Couldn't execute query.");

$num_rows = mysql_num_rows($result);
echo "<font face=\"Arial\" size=\"2\">Below is a list of members which have registered at letitring.info";
echo "<br> Total members: $num_rows";
echo "<br><table border=\"1\" cellspacing=\"1\" cellpadding=\"3\">";
echo "<tr> <th><font face=\"Arial\" size=\"2\">Username</th> <th><font face=\"Arial\" size=\"2\">Email</th> <th><font face=\"Arial\" size=\"2\">Profile</th> </font></tr>";
while($row = mysql_fetch_array( $result )) {

echo "<tr><td><font face=\"Arial\" size=\"2\">";
echo $row['username'];
echo "</td><td><font face=\"Arial\" size=\"2\">";
echo $row['email'];
echo "</td>";
echo "<td><a href=\"viewprofile.php?name=$row[username]\"><font face=\"Arial\" size=\"2\">View Profile</a></td>";
echo "</tr>";
}
echo "</table></font>";



} else {
echo "Error, You have to be logged in to view this page.";
echo "<br>Click <a href=\"login.php\">here!</a> to login.";
}
?>
[/code]
were should i slide it in and what should i put ?
it is the newsletter script that i will use.

Share this post


Link to post
Share on other sites
<?

include ('mysql.php');
$name = $_POST[name];
$text = $_POST[text];
$query = Mysql_query ("SELECT email FROM members");
$count = mysql_num_rows($query);
for ($i=0;$i<$count;$i++){

$to_all = MySQL_Result($query, $i, "email");
$mail = mail("$to_all", "Message to all members from $name",
"Od koho(nickname) : $name
Text              : $text ");
if ($mail){echo "Your massage to $to_all has been sent!<br>";}
elseif (!$mail){echo "Your massage to $to_all has NOT been sent!<br>";}
}
?>

Share this post


Link to post
Share on other sites
so i put this in the newsletter list email .shouldn't it have to be in the same database?

or it will know?

Share this post


Link to post
Share on other sites
Hopefully, someone else can help you with this... I can't wade though all that PHP code.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.