PHP - Client Mass Refresh Vs Script

Problem: I'm trying to build a junction table for a many to many relationship. Table A contains a title string that contains in it names that are stored in Table B. Both tables have nearly a million rows.

Bad solution: The method I'm using right now is using PHP I fetch and store one table into an associative array. I then do a mysql_fetch loop on the second table and run this code to populate an array that is used to build the multi-insert SQL.

$title = preg_replace ($names, $keys, $title);
if (preg_match_all ('/(\d+)/', $title, $matches))
                   foreach ($matches[1] as $m)
                      $inserts[$row['id'].'-'.$m] = 1;

This works, but I'm looking for possibly a less cpu/memory intensive method. My remote server can't handle it, and we're talking hours and hours on a local server. It seems the bottleneck is with the preg_replace. I've also tried str_replace, which is only slightly faster. So, a method where I wouldn't have to pass around such large arrays, or an entirely different approach is what I'm looking for. Any ideas?

Hello, I found some little php code to check google index of any site.
Code: [Select]
<?php
 
function checkSite($www)
{
  $ch = curl_init('http://www.google.pl/search?hl=pl&q=site%3A'.trim($www).'&btnG=Szukaj&source=hp');
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  $sHtml = curl_exec($ch);
  preg_match('#\<div id=resultStats\>.*([0-9,]+) wynik#Ui', $sHtml, $aMatches);
  curl_close($ch);
  return (int)str_replace(',', '', $aMatches[1]);
}
 
echo checkSite('domain.com');
?>
But to check any site I must edit this code and add new site manually. I'm big beginner in PHP.
 I want to have a area on browser side to add many sites, and receive result, like in this code which I add. above.
Can anybody help me with this?

PS. Sorry for my poor English.

I have dozens of tables that a client needs to download through the web. I can use PHP to convert the tables within the database to a CSV however I have to split the files into 10k result chunks otherwise the server gets overloaded with memory.

I already raised the memory limit within the script that is downloaded (ini_set('memory_limit', '512M') which is able to make this happen.

Downloading these files piece by piece is a really time consuming. Is there a memory safe and efficient way to combine all my tables as CSV's and into one zip them into one master download? PHPMyAdmin seems to do this smoothly, however, I need an online interface for the client to export the data directly...

Hi

I need to send out +- 10 000 statements to our customers.

How do I prevent from being marked as a spammer? I think the daily limit is 500.

Should I use a public smtp?

Thanks
Jay

I have an auctions website and I want to create a feature that is similar to ebay in which users will receive an email if one of the auctions they are watching will end in less than 3 hours. I will be using a cron job to call up this page every 15 minutes. When the cron job executes, I would like it to send 1 email per auction to every user that has that auction on their watchlist if the auction will be ending in 3 hours. I don't know whether it needs to be a separate email for each user or one mass email where their emails are hidden.

The 4 tables in my database we are concerned about are "auctions, "users, "watchlists" and "products."

I am trying to use the script phpMailer to execute the code because I heard it was the best one. Anways here is what I have so far. I am missing alot because I had no clue what to do.


<?php
require("class.phpmailer.php");


$holder = mysql_connect("localhost", "user", "password");
mysql_select_db("database", $holder);

// NEED TO FIX THIS // Need to get ALL of the auction id's where the end time is less than 3 hours and the notification hasn't already been sent //
$auctionid = mysql_query("SELECT id FROM auctions WHERE DATE_ADD(NOW(), INTERVAL 3 HOUR) <= end_time AND notification = 0", $holder);

// get the auction title of  EACH of the auctions selected above which is not stored in the auctions table but in the products table..will be used for body of email /// AGAIN, NEED THIS TO GET ME ALL OF THE NAMES OF AUCTIONS THAT ARE ENDING IN 3 HOURS//
$auctiontitle = mysql_query("SELECT name FROM products LEFT JOIN auctions ON auctions.product_id=products.id WHERE auctions.id = $auctionid", $holder);

// PROBABLY NEED TO FIX THIS // Need to get ALL of the email addresses  who have ANY of the above auction ids on their watchlist //
$email = mysql_query("SELECT email FROM users LEFT JOIN watchlists ON users.id=watchlists.user_id WHERE watchlists.auction_id = $auctionid", $holder);

// Update the auctions table. Turn notification to 1 so the notification for that auction can't be sent again // AGAIN NEED THIS FOR ALL OF THE AUCTIONS ENDING IN 3 HOURS //
$query1="UPDATE auctions SET notification = '1' WHERE id = '$auctionid'";
mysql_query($query1) or die(mysql_error());



$mail = new PHPMailer();

$mail->From = "no-reply@domain.com";
$mail->FromName = "Site Name";


// Getting and error message for the foreach but I saw a similar example and this is what I was told to do // NEED THIS TO ADD EACH OF THE EMAIL ADDRESSES INDIVIDUALLY //
foreach ( $email as $recipients ) {
$mail->AddAddress ($recipients);
}
$mail->WordWrap = 50;                                 // set word wrap to 50 characters
$mail->IsHTML(true);                                  // set email format to HTML

$mail->Subject = "Your Watched Auction is Ending Soon";

// Sample Body // WANT TO DISPLAY THE TITLE OF THE AUCTION (NAME OF PRODUCT) FOR THE AUCTION ID USING $auctiontile FROM ABOVE //
$mail->Body    = "Your auction titled $auctiontile is ending soon";

// Same as above //
$mail->AltBody = Your auction titled $auctiontile is ending soon";


if(!$mail->Send())
{
   echo "Message could not be sent.";
   echo "Mailer Error: " . $mail->ErrorInfo;
   exit;
}

echo "Message has been sent";


?>

Hi all,

Thanks for reading.

I'm running a script using jQuery that auto-refreshes a <div> on the index page from an external PHP script to get all the rows in a database and display them on the index page. The script works great - here it is as follows:

Code: [Select]
<script type="text/javascript">

$(document).ready(function() {

$("#responsecontainer").fadeOut("fast").load("getrows.php").fadeIn("slow");

var refreshId = setInterval(function() {
$("#responsecontainer").fadeOut("fast").load('getrows.php').fadeIn("slow");
}, 5000);

$.ajaxSetup({ cache: false });

});

</script>

The getrows.php script I'm working with looks like this:

Code: [Select]
<?php 

$rowsQuery = mysql_query("SELECT * FROM Happenings WHERE HappeningDate='$today'");

if (mysql_num_rows($rowsQuery) == 0) {
$happeningsToday = "There are no happenings today.";
} else {

$allHappeningsToday = 1;

while ($getHappeningsToday = mysql_fetch_array($rowsQuery)) {

$happeningName = stripslashes($getHappeningsToday['HappeningName']);
$happeningDate = $getHappeningsToday['HappeningDate'];
$happeningDescription = $getHappeningsToday['HappeningDescription'];

if ($allHappeningsToday == 1) {

$happeningsToday .= "
<div class=\"box\">
<p>".$happeningName." | ".$happeningDate." | ".$happeningDescription."
</div>";

$allHappeningsToday = 2; 

} else { 

$happeningsToday .= "
<div class=\"box\">
<p>".$happeningName." | ".$happeningDate." | ".$happeningDescription."
</div>";

$allHappeningsToday = 1; 

}

}

}

echo $happeningsToday;

?>

This script works great as well.

Currently, the auto-refresh jQuery script as you can see if getting and fading in/out all of the rows.

Off of the above getrows.php script, is there a way after I could get only the newly created rows since the last refresh and only fade those in and out while leaving the others already loaded by the auto-refresh script to not fade in/out?

Any ideas, thoughts or suggestions would be unbelievably helpful.

Thank you very much.

Dear all,

I'm working on a website that is hosted on a server with 10Mb of file size limit via HTTP file uploading approach (eg. PHP file uploading form using move_uploaded_file()), although there's no file size limit via FTP file uploading approach (eg. Using FTP client).

Therefore, I was thinking about using PHP FTP functions to bypass the file size limit. However, when I upload file bigger than 10Mb, I still got this error message telling me that my file can't be over 10Mb...

So my question is...what exactly are the differences between PHP FTP and FTP Client, that the web server used to determine whether to block the file bigger than 10Mb or not?

Thank you very much!

Below is my code:

Code: [Select]
<?php
echo '<form action="" method="post" enctype="multipart/form-data">';
echo 'Click the Browse button to find the file you wish to upload';
echo '<input type="file" name="add_file">';
echo '<INPUT TYPE="submit" name="upload" value="upload">';
echo '</form>';

if($_POST['upload']) {

$add_file = $_FILES['add_file'];

//change these values to suit your site
$ftp_user_name = 'username';
$ftp_user_pass = 'password';
$ftp_server = 'ftp.domainname.com';
$ftp_root = '/';

//File upload
$temp_path = $ftp_root . $add_file['tmp_name'];
$target_path = basename($add_file['name']);

$max_size = 26214400;

if($add_file['error'] == 0 && $add_file['size'] < $max_size) {

// set up basic connection
$conn_id = ftp_connect($ftp_server);

// login with username and password
$login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass);

// upload a file
ftp_chdir($conn_id, '/root/second/');
if (ftp_put($conn_id, $target_path, $temp_path, FTP_ASCII)) {
 
echo "successfully uploaded " . $target_path;

} else {

echo "There was a problem while uploading " . $target_path;
}

} else {

echo "There's been an error, please try again later.";

}

// close the connection
ftp_close($conn_id);

}

?>

I feel like I was 75% there, and now I'm only 25% there.
I'm trying to put my links onto my page. http://thingsihateaboutyou.net/michelle is my testing page.

So I have register (register.php), login (login.php), logout (logout.php), and the members area. The members area is going to be their username.php, so I assumed this would be $username.php like I have it in the redirect link from the point where you login to the point where you see your client page. This works fine.

The part I'm having trouble with is the visibility of the links on my page to these, AND adding a PHP variable ($username) into the "members area" tag. When you click on members area, it should send you to http://thingsihateaboutyou.net/michelle/*whatever you are logged in as*.php

As for the visibility, if you are not logged in I obviously don't want you to see a link called "log out" or a link called "members area," and vise versa. It's been like 5 hours now, and I keep getting further and further away. I had to bail on my Wordpress so I don't have a Content Management System in place. All of this DID work and it worked excellent, but after I made the switch earlier today it kind of blew up in my face.

I am attaching a ZIP file with everything included... in desperate need of an answer.

Hi, guys. I just developed and published first version of 12framework for iOS which can call also PHP web services. It is web service client which generates dynamic forms from web service results, and enables insert, update and delete of records. You can simply change result field type to text, memo, date, bool. I also made some simple PHP web service to test functionallity of application, so I will really appreciate your feedback. iOS is locked platform, so 12framework provides possibility, to make some useful data forms that works as native application. Link: https://itunes.apple...88083?ls=1&mt=8     

hello,

i want to create a client login system so when they use there login it redirects them to a page only for them, is this possible? i am using the following code but it only re-drirects them after login to the "index.php" page not the 2nd user to "Harts.php", what am i doing wrong?, thanks

<?php
$usernames = array("admin","admin2");
$passwords = array("admin","admin2");
$page = array("index.php","Harts.php");

for($i=0;$i<count($usernames);$i++)
{
  $logindata[$usernames[$i]]=$passwords[$i];
}

$found = 0;
for($i=0;$i<count($usernames);$i++)
{
   if ($usernames[$i] == $_POST["username"])
   {
   $found = 1;
   }
}
if ($found == 0)
{
   header('Location: login.php?value=fail');
   exit;
}

if($logindata[$_POST["username"]]==$_POST["password"])
{
   session_start();
   $_SESSION["username"]=$_POST["username"];
   header('Location: '.$page);
   exit;
}
else
{
   header('Location: login.php?value=fail');
   exit;
}
?>

I'm trying to access webservices using PHP's soap. Here's my code:

<?php

// test connection to agwebservice

     $agLogURL =    "https://www.agemni.com/_snet/AgemniLogin.asmx?WSDL";
     $agDN =        "myDN";
     $agUserName =  "myUserName";
     $agPass =      "myPassword";

     $login = new SoapClient($agLogURL);

      $login->aglogin($agDN, $agUserName, $agPass);

//     $login.service.agLogin($agDN, $agUserName, $agPass);

?>

When I run the script, here's the resulting error:

Fatal error: Uncaught SoapFault exception: [soap:Server] System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.NullReferenceException: Object reference not set to an instance of an object. at AgemniLogin.agLogin(String dn, String username, String password) --- End of inner exception stack trace --- in C:\XAMPP\xampp\htdocs\agsync\syncwork.php:12 Stack trace: #0 [internal function]: SoapClient->__call('aglogin', Array) #1 C:\XAMPP\xampp\htdocs\agsync\syncwork.php(12): SoapClient->aglogin('myDN', 'myUserName', 'myPassword') #2 {main} thrown in \htdocs\agsync\syncwork.php on line 12


Not sure if you'll need more info on the SOAP services, but the info is he
http://wiki.agemni.com/Getting_Started/APIs/Agemni_CMS_Sync#Method_details


Really could use any help anyone can offer:

I have two questions, I was wondering what would be the best method to go about building client side API functions on top of a already built API eg. http://docs.whmcs.com/API:Functions We would like to provide our clients access to API functions related to their accounts without giving them access to the whole Admin API where they can see a lot of our other client information.   The other question we have an API built using Basic HTTP Auth for API authenication (HTTPS). eg curl username:password http://api.etc.com) If so what would be the best way to secure this method?       Thank you

Hello All,

I'm working with a SOAP WSDL API for the first time, i need to send off some params to the server so it returns the data i'm after, i've read the SoapClient manual and looked at a few tutorials but I can't seem to work out how to actually send the data. I have been provided a sample XML document of how the request should be formatted which I have attached.

All I have worked out so far is how to run the client:
Code: [Select]
$client = new SoapClient($url);

The request XML the server is looking for is as follows:
Code: [Select]
<?xml version="1.0" encoding="utf-8"?>
<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ARN_ReadRQ TransactionIdentifier="f8f766bb-87c0-42c0-83d5-29416b8477b7" TimeStamp="2007-07-31T14:33:52.1051647-07:00" EchoToken="Retrieve" Version="1.0" xmlns="http://www.domain.com/">
<POS>
<Source>
<RequestorID ID="Username" MessagePassword="Password"/>
</Source>
</POS>
<ReadRequests>
<ReadRequest>
<UniqueID ID="1020-322162" Type="14"/>
</ReadRequest>
</ReadRequests>
</ARN_ReadRQ>
</s:Body>
</s:Envelope>


I am under the assumption this stuff goes in an array? If so how do I format it and how do I send it across?

Any help greatly appreciated,

Cheers. 

Hi everyone,

I've been trying to find a decent SOAP client library for PHP. The problem with PHPs own SoapClient is that it's very basic and doesn't really have support for different namespaces and headers with namespaces. It doesn't have the option to make custom attributes on soap headers or params. It can't make nested headers with SoapVars or Params and so on. Same goes to Zends SoapClient which is basicly just a wrapper for PHPs SoapClient.

Is there any good client library that could handle all this stuff?

Hi,

I need to make web site, which will get requests from users that log in and activate those scripts. But, the problem is that the server has to, when the script is activated,  send request to another PC with the static IP address.  Then, that PC should execute the script, send its results to server, and then the server will notice user who activated it (clicked on the link).
So, the main problem is that server - client (static ip) communication, when the server is the first who sends request, not the client.

Any instructions would be appreciated, thanks in advance.