PHP - Mail Functionality

Hello to all out there!
this is my first post,so my question may sound a bit simple. :]
I am studying PHP and MySQL and I tried to make a mailing form based on a mysql database.

My problem occured when I tried to use the PEAR mail object.

Here is my code:

// THE INCLUDED FILES
require_once ("attach_file.php"   );
require_once ("Mail.php"        );
require_once ("Mail\mime.php"   );

//THE VARIABLES TAKEN FROM THE HTML FORM OR JUST CREATED FOR THE CONSTRUCTION OF THE EMAIL
$my_email      = "something@gmail.com";
$email_subject = mysql_real_escape_string(trim( $_POST['email_subject']),$server_connect );
$email_body    = mysql_real_escape_string(trim( $_POST['email_body']   ),$server_connect );


$attached_file = $destination ;     // the $destination variable comes from the copy() function in attach_file.php
$username      = "the_username@gmail.com";
$password      = "the_password";
$host          = "smtp.gmail.com";

$attach        = new Mail_mime();
$attach -> addAttachment($attached_file);
$email_body    = $attach->get();

$extraheaders = array('from'=>$my_email,'to'=>$email_etaireias,'subject'=>$email_subject,'Bcc'=>$email_etaireias);
$headers       = $attach -> $headers($extraheaders);   // HERE GIVES ME AN ERROR!!! -->Fatal error: Method name must be a string

$smtp_info     = array('host'=>$host,'auth'=>TRUE,'username'=>$username,'password'=>$password);
$smtp          = Mail::factory('smtp',$smtp_info);


//loop through every single line of the database until there are no more lines with data
//and store each line in 3 different variables that i can use
while ( $row = mysql_fetch_array($result) )
{ $onoma_etaireias = $row['onoma_etaireias'];
  $email_etaireias = $row['email_etaireias'];
  $website_etaireias = $row['website_etaireias'];   }

//construct the mail function .  The @ is supressing the errors created .remove it and they will be shown.
$mail = @$smtp->send($email_etaireias,$headers,$email_body);



As i searched here and there for a solution, i found that it has something to do with the way the mail-mime object creates the body of the email . I also tried to find a solution from the PEAR documentation.
do i create the headers someway wrong?????

I am a newbie trying to build a quiz system. I have all of the questions and answer choices in a mysql table. My code below selects the question and answers. They appear exactly how I want them to....but I'm stuck on the form functionality. I was trying to use something like this:

Code: [Select]
<input type='radio' name='Q1Choice'  value='$answer1' />

I need to be able to insert the choice into my table. I know how to do the insert part but not sure how to take the radio choice as the insert data.

Code: [Select]
<?

//Connect to database
mysql_connect($host, $dbusername, $password);
mysql_select_db($TxQuizdb);


//Retrieve Quiz Questions
$qquery = mysql_query("SELECT * FROM Module_1_Quiz");



while ($m1questions = mysql_fetch_array($qquery)) {
 
   echo "<table width=600 border=1><tr><td>";
   echo $m1questions['Question'];
   echo "</td></tr><br><tr><td>";
   echo $m1questions['Choice1'];
   echo "<br>";
   echo $m1questions['Choice2'];
   echo "<br>";
   echo $m1questions['Choice3'];
   echo "</td></tr></table>";
   
}

thanks for any help.

Hi gents,

This will be an easy one for you all! I have a sql select statement and everything functions fine as is, BUT I would like to give users more freedom.

Using this sql statement the results only return if the user types the Botanical Name or Common Name of a particular plant exactly as it is spelled in the database:

$sql = mysql_query("SELECT PlantID, CommonName FROM plants WHERE BotanicalName='$BotanicalName' OR CommonName='$CommonName' OR Use1='$Use' OR Use2='$Use' OR Use3='$Use' OR Use4='$Use' OR Use5='$Use' ORDER BY CommonName");

What if the user doesn't know the species of a plant and only it's genus or the user only knows Maple tree and not which particular one they are looking for:

For example:
Plant in Database = Brandywine Red Maple
User Search would have to be exactly that "Brandywine Red Maple" for a result to return
Ideally I would like the user to be able to type in "Maple" and ALL Maples return

Let me know if you need more info

Hi all,

I'm coding an automated mailer for a dentist office. They set appointment dates through a web interface, and then this appointment is mailed to the customer via PHP's mail() function.

However, some users are not receving the mail. They claim that it is not even in the junk mail folder. Is it because I'm setting or not setting certain properties in the header? Should I be setting something else?

Here is my code
Code: [Select]
ini_set("SMTP", "mail.isp-provider.net");
$headers = 'From: Schedule Manager <schedule@address.com>' . "\r\n" .
'Reply-To: Schedule Manager <schedule@address.com>' . "\r\n" .
'Bcc: internal@address.com' . "\r\n" .
'Content-type: text/html; charset=iso-8859-1' . "\r\n" .
'X-Mailer: PHP/' . phpversion();

mail($customerAddress, $subject, $body, $headers);
Note that customerAddress, subject, and body are all just regular normal strings.

As I said, it works for most customers, but some customers do not receive the emails.

Hello there,

I've come across a issue with using PHP's mail function due to the fact I've tried a assortment of different headers yet Hotmail continues to place my sent emails in the junk folder.

Here is my method of emailing my clients:


function Email($AccountID, $Subject, $Message)
{
if($this->IsValidAccount($AccountID))
{
$Account = $this->AccountKeys($AccountID);

$headers .= 'To: '.$Account['account_client'].' <'.$Account['account_email'].'>' . "\r\n";

$headers .= "From: X-Host <no-reply@X-Host.co.uk>\r\n"; 
$headers .= "Reply-To: X-Host <no-reply@X-Host.co.uk>\r\n"; 
$headers .= "Return-Path: no-reply@X-Host.co.uk\r\n"; 
$headers .= "MIME-Version: 1.0\r\n"; 
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n"; 
$headers .= "Organization: X-Host\r\n";
echo $Account['account_email']. $Subject. $Message;

return mail($Account['account_email'], $Subject, $Message, $headers);
}
else return InvalidAccount;
}


So could anybody help me out please and tell me what headers I should be using.

My code about filterable audio searching, here how can i add Add-To-Cart functionality?

code :
index.php

<?php 

//index.php

include('database_connection.php');

?>

<!DOCTYPE html>
<html lang="en">

<head>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="">
    <meta name="author" content="">

    <title>Voice Repository</title>

    <script src="js/jquery-1.10.2.min.js"></script>
    <script src="js/jquery-ui.js"></script>
    <script src="js/bootstrap.min.js"></script>
    <link rel="stylesheet" href="css/bootstrap.min.css">
    <link href = "css/jquery-ui.css" rel = "stylesheet">
    <!-- Custom CSS -->
    <link href="css/style.css" rel="stylesheet">
</head>

<body>
    <!-- Page Content -->
    <div class="container">
        <div class="row">
            <br />
            <div class="col-md-12">
        	    <h2 align="center">Voice Repository Bank</h2>
        	</div>
            <div class="col-md-3">

                <!-- Price -->
				<!-- <div class="list-group">
					<h3>Price</h3>
					<input type="hidden" id="hidden_minimum_price" value="0" />
                    <input type="hidden" id="hidden_maximum_price" value="65000" />
                    <p id="price_show">1000 - 65000</p>
                    <div id="price_range"></div>
                </div> -->

                <!-- Languages  -->
                <div class="list-group">
					<h3>Languages</h3>
					<?php
                    $query = "
                    SELECT DISTINCT(voice_languages) FROM voice_bank_data WHERE voice_status = '1' ORDER BY voice_languages DESC
                    ";
                    $statement = $connect->prepare($query);
                    $statement->execute();
                    $result = $statement->fetchAll();
                    foreach($result as $row)
                    {
                    ?>
                    <div class="list-group-item checkbox">
                        <label><input type="checkbox" class="common_selector languages" value="<?php echo $row['voice_languages']; ?>"  > <?php echo $row['voice_languages']; ?> </label>
                    </div>
                    <?php
                    }
                    ?>	
                </div>

                <!-- Genres  -->
				<div class="list-group">
					<h3>Genres</h3>
                    <?php

                    $query = "
                    SELECT DISTINCT(voice_genres) FROM voice_bank_data WHERE voice_status = '1' ORDER BY voice_genres DESC
                    ";
                    $statement = $connect->prepare($query);
                    $statement->execute();
                    $result = $statement->fetchAll();
                    foreach($result as $row)
                    {
                    ?>
                    <div class="list-group-item checkbox">
                        <label><input type="checkbox" class="common_selector genres" value="<?php echo $row['voice_genres']; ?>" > <?php echo $row['voice_genres']; ?> </label>
                    </div>
                    <?php    
                    }

                    ?>
                </div>
				
                <!-- Voice Modulation -->
				<div class="list-group">
					<h3>Voice Modulation</h3>
					<?php
                    $query = "
                    SELECT DISTINCT(voice_voice_modulation) FROM voice_bank_data WHERE voice_status = '1' ORDER BY voice_voice_modulation DESC
                    ";
                    $statement = $connect->prepare($query);
                    $statement->execute();
                    $result = $statement->fetchAll();
                    foreach($result as $row)
                    {
                    ?>
                    <div class="list-group-item checkbox">
                        <label><input type="checkbox" class="common_selector voice_modulation" value="<?php echo $row['voice_voice_modulation']; ?>"  > <?php echo $row['voice_voice_modulation']; ?> </label>
                    </div>
                    <?php
                    }
                    ?>	
                </div> 
                <!-- Gender  -->
                <div class="list-group">
					<h3>Gender</h3>
                    <div style="height: 180px; overflow-y: auto; overflow-x: hidden;">
					<?php

                    $query = "SELECT DISTINCT(voice_gender) FROM voice_bank_data WHERE voice_status = '1' ORDER BY voice_id DESC";
                    $statement = $connect->prepare($query);
                    $statement->execute();
                    $result = $statement->fetchAll();
                    foreach($result as $row)
                    {
                    ?>
                    <div class="list-group-item checkbox">
                        <label><input type="checkbox" class="common_selector gender" value="<?php echo $row['voice_gender']; ?>"  > <?php echo $row['voice_gender']; ?></label>
                    </div>
                    <?php
                    }

                    ?>
                    </div>
                </div>


                <!-- Jingle Moods -->
                <div class="list-group">
					<h3>Jingle Moods</h3>
					<?php
                    $query = "
                    SELECT DISTINCT(voice_jingle_moods) FROM voice_bank_data WHERE voice_status = '1' ORDER BY voice_jingle_moods DESC
                    ";
                    $statement = $connect->prepare($query);
                    $statement->execute();
                    $result = $statement->fetchAll();
                    foreach($result as $row)
                    {
                    ?>
                    <div class="list-group-item checkbox">
                        <label><input type="checkbox" class="common_selector jingle_moods" value="<?php echo $row['voice_jingle_moods']; ?>"  > <?php echo $row['voice_jingle_moods']; ?> </label>
                    </div>
                    <?php
                    }
                    ?>	
                </div>

                <!-- IVR -->
                <div class="list-group">
					<h3>Ivr</h3>
					<?php
                    $query = "
                    SELECT DISTINCT(voice_ivr) FROM voice_bank_data WHERE voice_status = '1' ORDER BY voice_ivr DESC
                    ";
                    $statement = $connect->prepare($query);
                    $statement->execute();
                    $result = $statement->fetchAll();
                    foreach($result as $row)
                    {
                    ?>
                    <div class="list-group-item checkbox">
                        <label><input type="checkbox" class="common_selector ivr" value="<?php echo $row['voice_ivr']; ?>"  > <?php echo $row['voice_ivr']; ?> </label>
                    </div>
                    <?php
                    }
                    ?>	
                </div>
            </div>

            <div class="col-md-9">
            	<br />
                <div class="row filter_data">

                </div>
            </div>
        </div>

    </div>
<style>
#loading
{
	text-align:center; 
	background: url('loader.gif') no-repeat center; 
	height: 150px;
}
</style>

<script>
$(document).ready(function(){

    filter_data();

    function filter_data()
    {
        $('.filter_data').html('<div id="loading" style="" ></div>');
        var action = 'fetch_data';

        // var minimum_price = $('#hidden_minimum_price').val();
        // var maximum_price = $('#hidden_maximum_price').val();

        var gender = get_filter('gender');
        var genres = get_filter('genres');
        var voice_modulation = get_filter('voice_modulation');
        var languages = get_filter('languages');
        var jingle_moods = get_filter('jingle_moods');
        var ivr = get_filter('ivr');
        $.ajax({
            url:"fetch_data.php",
            method:"POST",
            data:
            {
                action:action, 
                // minimum_price:minimum_price, 
                // maximum_price:maximum_price,
                gender:gender,
                genres:genres, 
                voice_modulation:voice_modulation,
                languages:languages,
                jingle_moods:jingle_moods,
                ivr:ivr
            },
                success:function(data)
                {
                $('.filter_data').html(data);
                }
        });
    }

    function get_filter(class_name)
    {
        var filter = [];
        $('.'+class_name+':checked').each(function(){
            filter.push($(this).val());
        });
        return filter;
    }

    $('.common_selector').click(function(){
        filter_data();
    });

    // $('#price_range').slider({
    //     range:true,
    //     min:1000,
    //     max:65000,
    //     values:[1000, 65000],
    //     step:500,
    //     stop:function(event, ui)
    //     {
    //         $('#price_show').html(ui.values[0] + ' - ' + ui.values[1]);
    //         $('#hidden_minimum_price').val(ui.values[0]);
    //         $('#hidden_maximum_price').val(ui.values[1]);
    //         filter_data();
    //     }
    // });

});
</script>
</body>
</html>

 

and my
data fetching file,
data_fetch.php

 

<?php

//fetch_data.php

include('database_connection.php');

if(isset($_POST["action"]))
{
	$query = "
		SELECT * FROM voice_bank_data WHERE voice_status = '1'
	";

	// if(isset($_POST["minimum_price"], $_POST["maximum_price"]) && !empty($_POST["minimum_price"]) && !empty($_POST["maximum_price"]))
	// {
	// 	$query .= "
	// 	 AND product_price BETWEEN '".$_POST["minimum_price"]."' AND '".$_POST["maximum_price"]."'
	// 	";
	// }

	// Gender
	if(isset($_POST["gender"]))
	{
		$gender_filter = implode("','", $_POST["gender"]);
		$query .= "
		 AND voice_gender IN('".$gender_filter."')
		";
	}

	// Genres
	if(isset($_POST["genres"]))
	{
		$genres_filter = implode("','", $_POST["genres"]);
		$query .= "
		 AND voice_genres IN('".$genres_filter."')
		";
	}

	// Voice Modulation
	if(isset($_POST["voice_modulation"]))
	{
		$voice_modulation_filter = implode("','", $_POST["voice_modulation"]);
		$query .= "
		 AND voice_voice_modulation IN('".$voice_modulation_filter."')
		";
	}


	// Languages
	if(isset($_POST["languages"]))
	{
		$languages_filter = implode("','", $_POST["languages"]);
		$query .= "
		 AND voice_languages IN('".$languages_filter."')
		";
	}

	// Jingle Moods
	if(isset($_POST["jingle_moods"]))
	{
		$jingle_moods_filter = implode("','", $_POST["jingle_moods"]);
		$query .= "
		 AND voice_jingle_moods IN('".$jingle_moods_filter."')
		";
	}

	// IVR
	if(isset($_POST["ivr"]))
	{
		$ivr_filter = implode("','", $_POST["ivr"]);
		$query .= "
		 AND voice_ivr IN('".$ivr_filter."')
		";
	}

	$statement = $connect->prepare($query);
	$statement->execute();
	$result = $statement->fetchAll();
	$total_row = $statement->rowCount();
	$output = '';
	if($total_row > 0)
	{
		foreach($result as $row)
		{
			$output .= '
			<div class="col-sm-3 col-lg-4 col-md-3">
				<div style="border:1px solid #ccc; border-radius:5px; padding:10px; margin-bottom:16px; height:300px;">
					<audio controls controlsList="nodownload" style="padding: 10px 10px 10px 10px;margin-left: -21px;">
						<source src="audio_sample/'. $row['voice_audio_file'] .'" alt="" class="img-responsive">
					</audio>
					<p align="center"><strong> '. $row['voice_name'] .'</strong></p>

					<p style="font-size: 12px;">
					Gender		      : '. $row['voice_gender'].' <br />
					Genres 			  : '. $row['voice_genres'].' <br />
					Voice Modulation  : '. $row['voice_voice_modulation'].' <br />
					Languages		  : '. $row['voice_languages'].' <br />
					Jingle Moods	  : '. $row['voice_jingle_moods'].' <br />
					Ivr 			  : '. $row['voice_ivr'].' <br /> </p>
					<button class="btn btn-primary" type="submit" style="padding: 5px 83px 5px 83px;"> Add to PlayList </button>
				</div>

			</div>
			';
		} 
	}
	else 
	{
		$output = '<h3>No Data Found</h3>';
	}
	echo $output;
}
?>

 

How can i add add-to-cart functionality?
Note : In the cart just voice_id, voice_name, not necessary qty & price.
My current output:

https://snag.gy/xQ8TXP.jpg

Edited June 10, 2019 by aveeva

I am working on a REST application which is intended to be used with various CMS’s (Drupal, WordPress, etc).  Each CMS installation passes a unique GUID in the header to identify the organization so that the organization's individual data is utilized.  I’ve since realized I need some basic way to identify the individual user for at least two reasons:

The API provides a help desk where individual users can ask questions and get responses (not real time). There is some need for user access/privileges (I suppose this could be CMS side if necessary).

Instead of inputting users both into the API as well as the CMS, the organization should be responsible for entry only through the CMS.  They will add users as appropriate for the given CMS and then another page on the CMS will list all the CMS users and provide a way to set whether they are authorized to access the API as well as their access level.

The remaining of this post is kind of what I am thinking, but I am open to change.

When the CMS gives a user access to the API for the first time, a cURL request is made to the API and a unique key is returned and the CMS will save it as being associated with the given user.  Note sure if this should be an incrementing number on a per organization basis or another GUID, and if a GUID whether it should be passed along with the organization’s GUID or replace it.  Also, not positive, but thinking that user data (name, email, etc) should not be given to the API as it might be difficult to keep them synchronized. If a user’s access level is changed on the CMS or their access is removed, the user’s GUID is passed to the API and the work is done on the API.  If the user is removed, they are not deleted from the API’s database but just tagged as deleted. Before performing step 1, the CMS should first perform a query requesting all users who are tagged as deleted and is responsible to determine whether a new user should be added or an existing user should be reinstated.  Alternatively, I can make the API responsible for doing so, but then it would need to have stored various data to identify whether the user was previously instated which might result in the synchronization issue I described in step 1.

Any comments, potential pitfalls, or recommendations would be appreciated.

Hi all.  I'm using a cron job to pull the XML feed of my last five tweets, and using simplexml to parse and display the feed on my website.  Here's the PHP I'm using--it works just fine, and displays exactly as I want it to:

<?php
$xml = simplexml_load_file('crontwitter.xml');
foreach ($xml->status as $status) {
print "<p><span class=\"twittertext\">{$status->text}</span><br />";
print "<a class=\"twittertime\" href=\"http://twitter.com/#!/eaners/status/{$status->id}\" target=\"_blank\">";
echo date("j M Y, g:i A",strtotime($status->created_at));
print "</a></span></p>";
}
?>
I'd like to add a touch more "intelligence" to this script, though.  Namely, there are three things I'd also like to have this script do:
I'd like to append "I" to any tweets that include the #fb hashtag, so that things display correctly (e.g., "I did such and such today" instead of just "did such and such today") I'd like to link to any other Twitter users mentioned (they would always be mentioned using the @username format) I'd like to link to a search for any other hash tag mentioned aside from #fb (they would always be included using the #tag format) I guess I'm not sure how exactly to further parse the XML file.  I'll admit to being a relative newbie when it comes to PHP, so any assistance would be greatly appreciated!

Hello all,

My question is about a custom-coded latest-news plugin written by someone else. I don't know if it is generic, a copy of something else or what. It works good! but when I go to add a new news item to the list under Settings, it adds the item to the bottom of the list. The news is displayed on my homepage in short form and in full format on the primary news page.

I need new items to be added to the TOP of the list instead or in reverse, so that in all the containers where it resides, the latest news item added is always at the top of the list. I know nothing about php but I am looking to learn. I plan on taking some basic classes on css and php to upgrade my archaic html skills, but I'm currently studying other subjects. Regardless, if this has a simple fix, I would be very interested in knowing what is needed and where/why.

Here is the core of the php that I am finding in the plugin: There are three php files, This one says active, the other two say inactive so I get the impression they are not in use. Let me know if I should post their contents as well.

Appreciate any help with this! My sincere thanks in advance.

Labeled active: latest_news.php
*/ob_start();register_activation_hook(__file__, latest_news_install);function latest_news_install() {    global $wpdb;    $table_name = $wpdb->prefix . "latest_news";    if ($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) {        $sql = "CREATE TABLE IF NOT EXISTS " . $table_name . " (                     `id` int(10) NOT NULL AUTO_INCREMENT,                     `title` varchar(255) NOT NULL,                     `description` text NOT NULL,                     `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,                     PRIMARY KEY (id)                 );";        mysql_query($sql) or die(mysql_error());    }}if( !function_exists('wp_latest_news_init') ) {    function wp_latest_news_init() {        add_shortcode( 'wp_latest_news', 'shortcode_latest_news');    }}if( !function_exists('shortcode_latest_news') ) {    function shortcode_latest_news() {       // extract(shortcode_atts(array('limit' => '5', ), $atts));        global $wpdb;              $user_count = $wpdb->get_results("SELECT * FROM wp_latest_news ORDER BY date ASC LIMIT 4");                foreach ($user_count as $output) {            $htmlOutput[] = "<li><b><a href='".  get_permalink(287)."?news_id=".$output->id."'>" . $output->title . "</a></b></li>";        }        //echo $htmlOutput;        //echo "<pre>"; print_r($user_count); echo "</pre>";        foreach ($htmlOutput as $out) {            echo $out;        }                return $htmlOutput;    }}/* add_action('init', 'wp_latest_news_init' ) is used for call init function for create shortcode */add_action('init', 'wp_latest_news_init' );add_action('admin_menu', 'wp_latestnews_links' );function wp_latestnews_links() {    add_submenu_page( 'options-general.php', __( 'Latest News ' ), __( 'Latest News ' ), 5 , 'latest_news_settings', 'latest_news_settings' );}//     function latest_news_settings() {//          global $wpdb;//        if (isset($_POST["submit"])) {//            $sql="INSERT INTO ".$wpdb->prefix . "latest_news(`title`,`description`) VALUES ('".$_POST['news_title']."','".$_POST['description']."') ";//           //$sql=$wpdb->insert( $wpdb->latest_news, array( 'title' => $_POST['news_title'] ,'description' => $_POST['description'] ) );//           mysql_query($sql) or die(mysql_error());//         }//         include 'Latest_news_setting.php';function latest_news_settings() {    global $wpdb;    $action = $_REQUEST["action"];    $id = $_REQUEST['id'];    $sql = "SELECT * from ".$wpdb->prefix."latest_news ";    $results = $wpdb->get_results($sql);    //echo "<pre>";print_r($results);    //$post_arr = query_posts("");    //echo "<pre>";print_r($post_arr);exit;    switch ($action) {        case 'add' :            include('news_form.php');            break;        case 'save' :            if(isset($_POST['cancel'])) {                include('latest_news_list.php');            } else if(isset($_POST['add'])) {                $wpdb->query("insert into ".$wpdb->prefix."latest_news (`title`,`description`) VALUES ('".$_REQUEST['news_title']."','".$_REQUEST['description']."')");                //header("Location: http://localhost:81/Bravo/wp-admin/edit.php?page=slider_images");                header("location:?page=latest_news_settings");            }            break;        case 'edit' :            $sql = "SELECT * from ".$wpdb->prefix."latest_news where id = '".$id."' ";            $results_arr = $wpdb->get_results($sql);            //echo "<pre>";print_r($results_arr);            include('news_form.php');            break;        case 'update' :            if(isset($_POST['cancel'])) {                include('news_form.php');            } else if(isset($_POST['edit'])) {                //echo $id;                $wpdb->query("update ".$wpdb->prefix."latest_news set title = '".$_REQUEST['news_title']."', description = '".$_REQUEST['description']."' where id='".$id."'");                header("location:?page=latest_news_settings");            }            break;        case 'delete' :            $wpdb->query("delete from ".$wpdb->prefix."latest_news where id='".$id."'");            header("location:?page=latest_news_settings");            break;        default:            include('latest_news_list.php');            break;    }}?>()

I have Win 7 home premium, Apache 2.2 (installed using the .msi) and PHP 5.2.14 (downloaded as "php-5.2.14-Win32-VC6-x86.zip", installed manually, it works) on both machines. The other is 32-bit and the other is 64-bit, both Windows 7 Home Premium.

When I run the exactly same script on one machine, it does what it is supposed to (32-bit), but on the 64-bit it does not.

Basically this appears in two situations (so far): I have a script that reads a (xml) file into a simplexml object, and if this is not successful, it prints an error message. On the 32-bit machine I can import (read) another xml file at once once the first one is processed (into a sqlite database), but on the 64-bit machine it gives me an error originating from the fact that the script did not manage to create the simplexml object.

The other situation is when I want to open a specific PDF - file in a browser window (Firefox, the newest one, on the 32-bit machine, IE something newish on the 64-bit). The file exists, the path to the folder is in the Path environment variable, I can open it normally etc on the 64-bit machine, but when I click on a link that is supposed to open the file in a browser window I only get an error message saying that the file does not start with "%PDF....

Needless to say, the precisely same script works just fine on the 32 bit machine.

$path_to_image="D:\\path_to_folder\\";

$file_name=$_GET['file_name'];

header("Content-disposition: inline; filename=".$path_to_image.$file_name);
header("Content-type: application/pdf");
readfile($path_to_image.$file_name);

The above code is from the part that receives the file name from a form (other file).

Anyone noticed anything like this? Any suggestions? Have been trying to figure this out for days, now...

Oh, forgot: In both cases the thing is accessed as/from "localhost".

Hello Freaks,

I am currently working on a status report web application.  A user inputs what they are planning on accomplishing that week.  Afterwords realizes that they made a mistake and need to correct it.  The way I want to go about this is sql the database and return * where the username and report date are current.

With the results of this query I insert them into the form as the value.  This yields a populated form.  From here I want the user to be able to change any line and submit the whole form.  However, the post array is only populated with one row of data.  I thought this might have to do with the names of the inputs all being the same so i tried to index those through the while loop with no luck.

Any help would be appreciated!

here's the code


Code: [Select]
<?
// renaming sess var
$UAID = $_SESSION['UAID'];
$WEND = $_SESSION['WEEK_ENDING2'];

//have we submitted our changes?
if($EDIT == TRUE){

//how many task are there this week
$results = mysql_query("Select COUNT(UAID) FROM `WPFTW` where UAID ='$UAID' and Rend = '$WEND'");
$row = mysql_fetch_row($results);

//clean $_POST
print_r($_POST);
unset($_POST['Report']);
echo "<br>";
print_r($_POST);

}
//what do we plan on editing
$results = mysql_query("Select * FROM `WPFTW` where UAID ='$UAID' and Rend = '$WEND'");

//while there are results
while($row = mysql_fetch_array($results)){

//increment for input name
$k = 1;

//date formatting
list($year,$month,$day) = explode("-",$row['Target']);
$row['Target'] = $month."-".$day."-".$year;

//empty string to uncheck checkboxes
$checked = "";

//populate checkboxes
if($row['MS'] == "on"){
$checked = "yes";
}

//select the correct drop down menu option
if(isset($row['Status'])){
        if($row['Status'] == " "){
        $selected = "selected";
        $selected1 = "";
        $selected2 = "";
        $selected3 = "";
        }

        elseif($row['Status'] == "P"){

        $selected = "";
        $selected1 = "selected";
        $selected2 = "";
        $selected3 = "";
        }

        elseif($row['Status'] == "C"){

        $selected = "";
        $selected1 = "";
  $selected2 = "selected";
        $selected3 = "";
        }

        elseif($row['Status'] == "CL"){

        $selected = "";
        $selected1 = "";
        $selected2 = "";
        $selected3 = "selected";
        }
}

//select the correct drop down menu option
if(isset($row['OT'])){
        if($row['OT'] == "Y"){
        $selected4 = "selected";
        $selected5 = "";
        }

        elseif($row['OT'] == "N"){

        $selected4 = "";
        $selected5 = "selected";
        }
}

//var to send form to self
$cani = htmlentities($_SERVER['PHP_SELF']);

//concatenate html & php for form
$test =  "<form id =\"2bigform\" action=$cani method = \"post\">" . "<tr>" .
        "<td><input id=\"hidden\" name=\"UAID$k\" type=\"hidden\" value=" . $_SESSION['UAID'] ."></td>".
        "<td width=\"7%\"> <input id=\"SR\#$k\" name=\"SR#\" type=\"text\" size=\"10%\" maxlength=\"10\" value=" . $row['SRNUM'] . "></td>" .
        "<td width=\"63%\"> <input id=\"Task$k\" name=\"Task\" type=\"textarea\" size=\"63%\"  value=" . $row['Task'] . "></td>" .
        "<td width=\"7%\"> <select id=\"Status$k\" name=\"Status\">".
                                                        " <option value=\" \" $selected></option>".
                                                        " <option value=\"P\" $selected1>P</option>".
                                                        " <option value=\"C\" $selected2>C</option>".
                                                        " <option value=\"CL\" $selected3>CL</option>".
                                                        "</select></td>".

        "<td width=\"7%\"> <input id=\"MS$k\" name=\"MS\" type=\"checkbox\" size=\"7%\"  value=" . $row['MS'] . " checked = $checked></td>".
        "<td width=\"7%\"> <select id=\"OT$k\" name=\"OT\">".
                                                        " <option value=\"Y\" $selected4>Y</option>".
                                                        " <option value=\"N\" $selected5>N</option>".
                                                        "</select></td>".

     "<td width=\"9%\"> <input id=\"Target$k\" name=\"Target\" type=\"text\" size=\"9%\"  value=" . $row['Target'] . "></td>".
        "<input id=\"hidden\" name=\"RDate$k\" type=\"hidden\" value=" . $_SESSION['WEEK_ENDING'] ."></td></tr>";
echo $test;
$k++;
echo $k;
}
echo "</table>".
     "<input id=\"Sub\" type= \"Submit\" name=\"Report\" value= \"Submit\"/>".
     "</form>".
     "</body>".
     "</html>";

//<td width="7%"> <input id="SR#" name="SR#" type="text" size="10%" maxlength="10"/></td>
//<td width="63%"> <input id="Task" name="Task"  type="textarea" size= "63%"/></td>






}
?>

I am trying to make a login which works perfectly until I try and add remember me functionality into the User class. 

Hi There

I am trying to create a page that edit mysql database from a php page. I can get the edit page to show the orginal information but it wont update the data in the mysql database.

I am sure I have entered everything right. If anyone could help with this I would greatly appreciated

<?php

include("dbconnect.php");

     if(isset($_POST['submit']))

  {


      // Set global variables to easier names
     // and prevent sql injection and apostrophe to break the db.
    
      $ProductName = mysql_escape_string($_POST['ProductName']);
      $ProductText = mysql_escape_string($_POST['ProductText']);
      $ProductImage = mysql_escape_string($_POST['ProductImage']);
      $ProductPrice = mysql_escape_string($_POST['ProductPrice']);


         $result = mysql_query("UPDATE Product SET ProductName='$ProductName', ProductText='$ProductText', ProductImage='$ProductImage', ProductPrice='$ProductPrice' WHERE ID='$ID' ",$dbconnect);

          echo "<b>Thank you! Product UPDATED Successfully!<br>You'll be redirected to View Page after (2) Seconds";

          echo "<meta http-equiv=Refresh content=2;url=view.php>";
         
          echo "$ProductName <br> $ProductText <br> $ProductImage <br> $ProductPrice";

}

elseif(isset($_GET['ID']))

{

 

        $result = mysql_query("SELECT * FROM Product WHERE ID='$_GET[ID]' ",$dbconnect);

        while($myrow = mysql_fetch_assoc($result))

             {

                $ProductName = $myrow["ProductName"];
                $ProductText= $myrow["ProductText"];
                $ProductImage = $myrow["ProductImage"];
                $ProductPrice = $myrow["ProductPrice"];



?>

<br>

<h3>::Edit Product</h3>

   <form method="post" action="<?php echo $PHP_SELF ?>">
   
      <input type="hidden" name="ID" value="<? echo $myrow['ID']?>">            
      Product Name: <input name="ProductName" size="40" maxlength="255" value="<? echo $ProductName; ?>"><br>
      Product Text: <textarea name="ProductText"  rows="7" cols="30"><? echo $ProductText; ?></textarea><br>
      Product Image: <textarea name="ProductImage"  rows="7" cols="30"><? echo $ProductImage; ?></textarea><br>
      Product Price: <textarea name="ProductPrice" rows="7" cols="30"><? echo $ProductPrice; ?></textarea><br>
      <input type="submit" name="submit" value="Update Product">
   
   </form>

<?

              }//end of while loop

 

  }//end else

?>

Hi,
I found a couple of topics in the search on this but can't resolve my problem.
I have a cart and want to mail it to myself and the client. The cart I'm using works fine but the moment I "check out" (mail the order) it gives a error. I build an error trap but see nothing wrong then I tried a different way to send the order in html with no avail.
6x files I use: Index.php -The products I'm selling and "add to chart"
                      Cart.php - To update and display the products in the basket
                      SendOrder.php - To mail the cart etc. to me and client
as the main files and some functions, db connection and global's...
1) Index.php by Simon Mayer

<?php
// Start the session
session_start();
// Include MySQL class
require_once('inc/mysql.class.php');
// Include database connection
require_once('inc/global.inc.php');
// Include functions
require_once('inc/functions.inc.php');
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>MedSET Store</title>
<link rel="stylesheet" href="css/styles.css" >
</head>

<body>
<div id="shoppingcart">

<h1>Your Shopping Cart</h1>

<?php
echo writeShoppingCart();
?>

</div>

<div id="booklist">

<h1>Products</h1>

<?php
$sql = 'SELECT * FROM books ORDER BY id';
$result = $db->query($sql);
$output[] = '<ul>';
while ($row = $result->fetch()) {
$output[] = '<li>"'.$row['title'].'" by '.$row['author'].': &pound;'.$row['price'].'<br /><a href="cart.php?action=add&id='.$row['id'].'">Add to cart</a></li>';
}
$output[] = '</ul>';
echo join('',$output);
?>

</div>

</body>
</html>


2)Cart.php by Simon Mayer

<?php
// Start the session
session_start();
// Include MySQL class
require_once('inc/mysql.class.php');
// Include database connection
require_once('inc/global.inc.php');
// Include functions
require_once('inc/functions.inc.php');

// Process actions
$cart = $_SESSION['cart'];
$action = $_GET['action'];
switch ($action) {
case 'add':
if ($cart) {
$cart .= ','.$_GET['id'];
} else {
$cart = $_GET['id'];
}
break;
case 'delete':
if ($cart) {
$items = explode(',',$cart);
$newcart = '';
foreach ($items as $item) {
if ($_GET['id'] != $item) {
if ($newcart != '') {
$newcart .= ','.$item;
} else {
$newcart = $item;
}
}
}
$cart = $newcart;
}
break;
case 'update':
if ($cart) {
$newcart = '';
foreach ($_POST as $key=>$value) {
if (stristr($key,'qty')) {
$id = str_replace('qty','',$key);
$items = ($newcart != '') ? explode(',',$newcart) : explode(',',$cart);
$newcart = '';
foreach ($items as $item) {
if ($id != $item) {
if ($newcart != '') {
$newcart .= ','.$item;
} else {
$newcart = $item;
}
}
}
for ($i=1;$i<=$value;$i++) {
if ($newcart != '') {
$newcart .= ','.$id;
} else {
$newcart = $id;
}
}
}
}
}
$cart = $newcart;
break;
}
$_SESSION['cart'] = $cart;

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>MedSET Store</title>
<link rel="stylesheet" href="css/styles.css" >
</head>

<body>

<div id="shoppingcart">

<h1>Your Shopping Cart</h1>

<?php
echo writeShoppingCart();
?>

</div>

<div id="contents">

<h1>Please check quantities...</h1>

<?php
echo showCart();
?>
<form action="sendOrder.php" method="post"> //I added the action file to handle the form
<input type="submit" name="sendmail" value="Check Out" >
</form>
<p><a href="index.php">Continue Shopping...</a></p>

</div>

</body>
</html>


      2.1)MySQL.class.php

<?php
/**
* MySQL Database Connection Class
* @access public
* @package SPLIB
*/
class MySQL {
    /**
    * MySQL server hostname
    * @access private
    * @var string
    */
    var $host;

    /**
    * MySQL username
    * @access private
    * @var string
    */
    var $dbUser;

    /**
    * MySQL user's password
    * @access private
    * @var string
    */
    var $dbPass;

    /**
    * Name of database to use
    * @access private
    * @var string
    */
    var $dbName;

    /**
    * MySQL Resource link identifier stored here
    * @access private
    * @var string
    */
    var $dbConn;

    /**
    * Stores error messages for connection errors
    * @access private
    * @var string
    */
    var $connectError;

    /**
    * MySQL constructor
    * @param string host (MySQL server hostname)
    * @param string dbUser (MySQL User Name)
    * @param string dbPass (MySQL User Password)
    * @param string dbName (Database to select)
    * @access public
    */
    function MySQL ($host,$dbUser,$dbPass,$dbName) {
        $this->host=$host;
        $this->dbUser=$dbUser;
        $this->dbPass=$dbPass;
        $this->dbName=$dbName;
        $this->connectToDb();
    }

    /**
    * Establishes connection to MySQL and selects a database
    * @return void
    * @access private
    */
    function connectToDb () {
        // Make connection to MySQL server
        if (!$this->dbConn = @mysql_connect($this->host,
                                      $this->dbUser,
                                      $this->dbPass)) {
            trigger_error('Could not connect to server');
            $this->connectError=true;
        // Select database
        } else if ( !@mysql_select_db($this->dbName,$this->dbConn) ) {
            trigger_error('Could not select database');
            $this->connectError=true;
        }
    }

    /**
    * Checks for MySQL errors
    * @return boolean
    * @access public
    */
    function isError () {
        if ( $this->connectError )
            return true;
        $error=mysql_error ($this->dbConn);
        if ( empty ($error) )
            return false;
        else
            return true;
    }

    /**
    * Returns an instance of MySQLResult to fetch rows with
    * @param $sql string the database query to run
    * @return MySQLResult
    * @access public
    */
    function query($sql) {
        if (!$queryResource=mysql_query($sql,$this->dbConn))
            trigger_error ('Query failed: '.mysql_error($this->dbConn).
                           ' SQL: '.$sql);
        return new MySQLResult($this,$queryResource);
    }
}

/**
* MySQLResult Data Fetching Class
* @access public
* @package SPLIB
*/
class MySQLResult {
    /**
    * Instance of MySQL providing database connection
    * @access private
    * @var MySQL
    */
    var $mysql;

    /**
    * Query resource
    * @access private
    * @var resource
    */
    var $query;

    /**
    * MySQLResult constructor
    * @param object mysql   (instance of MySQL class)
    * @param resource query (MySQL query resource)
    * @access public
    */
    function MySQLResult(& $mysql,$query) {
        $this->mysql=& $mysql;
        $this->query=$query;
    }

    /**
    * Fetches a row from the result
    * @return array
    * @access public
    */
    function fetch () {
        if ( $row=mysql_fetch_array($this->query,MYSQL_ASSOC) ) {
            return $row;
        } else if ( $this->size() > 0 ) {
            mysql_data_seek($this->query,0);
            return false;
        } else {
            return false;
        }
    }

    /**
    * Returns the number of rows selected
    * @return int
    * @access public
    */
    function size () {
        return mysql_num_rows($this->query);
    }

    /**
    * Returns the ID of the last row inserted
    * @return int
    * @access public
    */
    function insertID () {
        return mysql_insert_id($this->mysql->dbConn);
    }
    
    /**
    * Checks for MySQL errors
    * @return boolean
    * @access public
    */
    function isError () {
        return $this->mysql->isError();
    }
}
?>

   2.2)Global.inc.php

<?php
$host = 'localhost';
$user = 'MyUserName';
$pass = 'MyPassword';
$name = 'MyDataBase';
$db = &new MySQL($host,$user,$pass,$name);
?>


   2.3)Function.inc.php

<?php
function writeShoppingCart() {
$cart = $_SESSION['cart'];
if (!$cart) {
return '<p>You have no items in your shopping cart</p>';
} else {
// Parse the cart session variable
$items = explode(',',$cart);
$s = (count($items) > 1) ? 's':'';
return '<p>You have <a href="cart.php">'.count($items).' item'.$s.' in your shopping cart</a></p>';
}
}

function showCart() {
global $db;
$cart = $_SESSION['cart'];
if ($cart) {
$items = explode(',',$cart);
$contents = array();
foreach ($items as $item) {
$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
}
$output[] = '<form action="cart.php?action=update" method="post" id="cart">';
$output[] = '<table>';
foreach ($contents as $id=>$qty) {
$sql = 'SELECT * FROM books WHERE id = '.$id;
$result = $db->query($sql);
$row = $result->fetch();
extract($row);
$output[] = '<tr>';
$output[] = '<td><a href="cart.php?action=delete&id='.$id.'" class="r">Remove</a></td>';
$output[] = '<td>'.$title.' by '.$author.'</td>';
$output[] = '<td>&pound;'.$price.'</td>';
$output[] = '<td><input type="text" name="qty'.$id.'" value="'.$qty.'" size="3" maxlength="3" /></td>';
$output[] = '<td>&pound;'.($price * $qty).'</td>';
$total += $price * $qty;
$output[] = '</tr>';
}
$output[] = '</table>';
$output[] = '<p>Grand total: <strong>&pound;'.$total.'</strong></p>';
$output[] = '<div><button type="submit">Update cart</button></div>';
$output[] = '</form>';
} else {
$output[] = '<p>You shopping cart is empty.</p>';
}
return join('',$output);
}
?>

     
3)SendOrder.php

<?php 
$cart = $_SESSION['cart'];
$to = "me@myself.com";
$subject =  "MedSET Order";
$message = "<html>
<head>
<title>Email Order<Title>
</head>
<body>
This is my message in body
</body>";
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
$headers .= 'From: "email address" <an email existing on same server as shopping cart>' .  "\r\n";

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

?>


Any help will be appreciated...