Jump to content

destined

Members
 View Profile  See their activity

  • Posts

    15

  • Joined

  • Last visited

    Never

 Content Type 

Posts posted by destined

    i don't know who to do this

    in Javascript Help

    Posted

    Thank you for viewing this post
    On this [a href=\"http://www.destinedtowin.org/audio.html\" target=\"_blank\"]Audio Page[/a] we have mp3 links
    What my pastor wants is
    When a link is clicked or right clicked to play and or save as (normal action)
    But at the same time open a new window (not a popup) Like have a new page open or redirect to the newsletter.php wile the (normal action) is taking place

    is this a simple JS or do i need to put the mp3s in a DB and use PHP

    please point me in the rite direc

    FROM WHERE

    in PHP Coding Help

    Posted

    ok ok ok ...lol

    i used the first method before comming back here and it work for what i needed to do
    But now i need to get the same emailaddress/firstname from an other database (users)
    table: tbl_users

    Thank You both for your help

    FROM WHERE

    in PHP Coding Help

    Posted

    [!--quoteo(post=381888:date=Jun 9 2006, 11:23 AM:name=Fyorl)--][div class=\'quotetop\']QUOTE(Fyorl @ Jun 9 2006, 11:23 AM) [snapback]381888[/snapback][/div][div class=\'quotemain\'][!--quotec--]
    You need:[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']INSERT[/span] [color=green]INTO[/color] [color=orange]`emails`[/color] (email, name)
    [span style=\'color:blue;font-weight:bold\']SELECT[/span] `emailaddress`, `firstname` [color=green]FROM[/color] [color=orange]`newsletter`;[/color] [!--sql2--][/div][!--sql3--]That will insert the firstname and emailaddress from each row in the newsletter table into a new row in the emails table.
    [/quote]
    Thank you for the quick reply
    God bless

    FROM WHERE

    in PHP Coding Help

    Posted

    Thanks for looking
    Iam useing phpMyAdmin and tryin to run a query
    tables: newsletter, emails

    I am getteing this
    #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' firstname)' at line 2
    I have tryed a few variations of this
    I know this is a simple thing to most but not to me Please help

    INSERT INTO emails (email, name)
    SELECT * FROM newsletter WHERE (emailaddress, firstname)

    i tryed closing it with ";

    recovery of lost password

    in PHP Coding Help

    Posted

    ok so i might not know PHP
    but the way to learn is to come here and ask
    i dont let Dreamweaver do it all

    Thank you Crayon Violent for trying to help
    i will try what you said and no this is not a Dreamweaver code
    ill be back tomorrow Thanks agian Crayon Violent

    recovery of lost password

    in PHP Coding Help

    Posted

    This was working and all i did was take Zip & Address out of the table
    i think that is when this stoped working (not sure)
    I dont know much PHP I let Deramweaver do that for me.. lol
    it keeps saying the (echo)error that the email ady is not in DB
    but it is !
    Please help

    [!--coloro:#000099--][span style=\"color:#000099\"][!--/coloro--]its the same if i use this[!--colorc--][/span][!--/colorc--]
    <?php
    $db_name = "destined_users"; //this is your database name
    $db_user = "destined_XXX"; //this is your database username for the database specified above
    $db_pass = "XXXX"; //this is your database password for the user specified above
    $db_host = "localhost"; //this is your host for the database, best to leave it as localhost

    mysql_connect("$db_host", "$db_user", "$db_pass")or die(mysql_error());
    mysql_select_db("$db_name") or die(mysql_error());
    ?>
    [!--coloro:#333399--][span style=\"color:#333399\"][!--/coloro--]Or If I Use This[!--colorc--][/span][!--/colorc--]
    <?php require_once('Connections/user_login.php'); ?>
    <?php
    mysql_select_db($database_user_login, $user_login);
    $query_rsRecover = "SELECT * FROM tbl_users";
    $rsRecover = mysql_query($query_rsRecover, $user_login) or die(mysql_error());
    $row_rsRecover = mysql_fetch_assoc($rsRecover);
    $totalRows_rsRecover = mysql_num_rows($rsRecover);
    ?>
    [!--coloro:#333399--][span style=\"color:#333399\"][!--/coloro--]here is the Code[!--colorc--][/span][!--/colorc--]

    <?php require_once('Connections/user_login.php'); ?>
    <?php
    mysql_select_db($database_user_login, $user_login);
    $query_rsRecover = "SELECT * FROM tbl_users";
    $rsRecover = mysql_query($query_rsRecover, $user_login) or die(mysql_error());
    $row_rsRecover = mysql_fetch_assoc($rsRecover);
    $totalRows_rsRecover = mysql_num_rows($rsRecover);
    ?>
    <?
    $editFormAction = $_SERVER['PHP_SELF'];
    if (isset($_SERVER['QUERY_STRING'])) {
    $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
    }
    ?>

    <?

    if (isset($_POST['submit'])){ $query="SELECT emailaddress,username,pwd FROM tbl_users WHERE [!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]emailaddress[!--colorc--][/span][!--/colorc--] = '$emailaddress'";
    $st=mysql_query($query);
    $recs=mysql_num_rows($st);
    $row=mysql_fetch_object($st);
    $em=$row->emailaddress;// email is stored to a variable
    if ($recs == 0) { echo "<center><font face='Verdana' size='2' ><b>No Password</b><br> Sorry Your email address is not there in our database. You can register and login to use our members pages. <BR><BR><a href='registration.php'> Register </a> </center>"; exit;}

    $headers4="password@destinedtowin.org"; ///// Change this address within quotes to your address ///

    $headers .= "From: $headers4\n";
    $headers .= "Errors-to: $headers4\n";
    //$headers = "Content-Type: text/html; charset=iso-8859-1\n".$headers;// for html mail un-comment this line

    if(mail("$em","password/user name recovery","This is in response to your request for your login information for \n Destined To Win Ministries at www.destinedtowin.org \n\n username: $row->username \n password: $row->pwd \n\n Thank You \n \n \n Please do not reply to this email","$headers")){echo "<center><font face='Verdana' size='2' ><b>THANK YOU</b> <br>Your password and user name have been sent to your emil address. <br>
    Please check your mail <BR><BR><a href='login.php'> Login </a><br>
    <br>
    </center>";}
    else{ echo " <center><font face='Verdana' size='2' >There is some system problem in sending login details to your address. Please contact site-admin. <br><br><input type='button' value='Retry' onClick='history.go(-1)'></center></font>";}


    }


    ?>

    lostpass word

    in Editor Help (PhpStorm, VS Code, etc)

    Posted

    solved


    Can dreamweaver make the code to send users there lost password or can someone help me with this code

    this it not working i copied it from the web
    i am new at PHP
    i need to send user name and pswd to the user If anyone has the code for that please post

    After sumitting i get this error

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in -- lost_passwordck.php on line 21

    Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /usr/home/destined/public_html/lost_passwordck.php on line 22

    <?php
    session_start();
    session_register("session");
    ?>
    <?


    if (isset($_POST['submit'])){ $query="SELECT emailaddress,username,pwd FROM tbl_users WHERE tbl_users.emailaddress = '$emailaddress'";
    $st=mysql_query($query);
    [!--coloro:#CC6600--][span style=\"color:#CC6600\"][!--/coloro--]$recs=mysql_num_rows($st);
    $row=mysql_fetch_object($st);[!--colorc--][/span][!--/colorc--]
    $em=$row->emailaddress;// email is stored to a variable
    if ($recs == 0) { echo "<center><font face='Verdana' size='2' color=red><b>No Password</b><br> Sorry Your address is not there in our database . You can signup and login to use our site. <BR><BR><a href='signup.php'> Sign UP </a> </center>"; exit;}

    $headers4="admin@destinedtowin.org"; ///// Change this address within quotes to your address ///
    $headers.="Reply-to: $headers4\n";
    $headers .= "From: $headers4\n";
    $headers .= "Errors-to: $headers4\n";
    //$headers = "Content-Type: text/html; charset=iso-8859-1\n".$headers;// for html mail un-comment this line

    if(mail("$em","Your Request for login details","This is in response to your request for login detailst at site_name \n \nLogin ID: $row->username \n Password: $row->pwd \n\n Thank You \n \n siteadmin","$headers")){echo "<center><font face='Verdana' size='2' ><b>THANK YOU</b> <br>Your password is posted to your emil address . Please check your mail after some time. </center>";}
    else{ echo " <center><font face='Verdana' size='2' color=red >There is some system problem in sending login details to your address. Please contact site-admin. <br><br><input type='button' value='Retry' onClick='history.go(-1)'></center></font>";}


    }

    else {echo "<center><font face='Verdana' size='2' color=red >$msg <br><br><input type='button' value='Retry' onClick='history.go(-1)'></center></font>";}
    ?>

    Requiered fields

    in PHP Coding Help

    Posted

    i dont know what i am doing Would soneone give me a Requiered fields script Please

    I tryed
    [code]
    if (isset($_POST["submit"]))
    {

    // Check for empty fields
    if ($_POST["email"] == "")
    {
         die("Please fill out all fields");
    }
    [/code]

    I tryed
    [code]
    if($_POST['required_field_1'] == "" || $_POST['required_field_2'] == "" || ..... || $_POST['required_field_n'] == ""){
    //put your error here
    }
    [/code]

    Do i put [!--coloro:#993300--][span style=\"color:#993300\"][!--/coloro--]echo[!--colorc--][/span][!--/colorc--] for the error

    and where do i put it
    [code]
    <?php require_once('Connections/destined_test.php'); ?>
    <?php
    function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
    {
      $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

      switch ($theType) {
        case "text":
          $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
          break;    
        case "long":
        case "int":
          $theValue = ($theValue != "") ? intval($theValue) : "NULL";
          break;
        case "double":
          $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
          break;
        case "date":
          $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
          break;
        case "defined":
          $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
          break;
      }
      return $theValue;
    }
    if ((isset($_POST['emailaddress'])) && ($_POST['emailaddress'] != "")) {
      $deleteSQL = sprintf("DELETE FROM newsletter WHERE emailaddress=%s",
                           GetSQLValueString($_POST['emailaddress'], "text"));

      mysql_select_db($database_destined_test, $destined_test);
      $Result1 = mysql_query($deleteSQL, $destined_test) or die(mysql_error());

      $deleteGoTo = "unsubscribed.php";
      if (isset($_SERVER['QUERY_STRING'])) {
        $deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
        $deleteGoTo .= $_SERVER['QUERY_STRING'];
      }
      header(sprintf("Location: %s", $deleteGoTo));
    }



    mysql_select_db($database_destined_test, $destined_test);
    $query_rsUnsubscribe = "SELECT * FROM newsletter";
    $rsUnsubscribe = mysql_query($query_rsUnsubscribe, $destined_test) or die(mysql_error());
    $row_rsUnsubscribe = mysql_fetch_assoc($rsUnsubscribe);
    $totalRows_rsUnsubscribe = mysql_num_rows($rsUnsubscribe);
    ?>
    [/code]

    [b]EDIT BY OBER: PLEASE USE CODE TAGS WHEN POSTING CODE[/b]




    thanks ober

    2 Questions

    in Editor Help (PhpStorm, VS Code, etc)

    Posted

    How do i make a new DB table in dreamweaver?
    i need to make a question and answers page.
    How do i get the right Answes to the original Question ?
    i have used dreanweaver to make this page: [a href=\"http://www.destinedtowin.org/test/page/devotional.php\" target=\"_blank\"]http://www.destinedtowin.org/test/page/devotional.php[/a]
×
×
  • Create New...

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.