PHP - File Transfer Header

I want to call a different header file for firefox. Is this possible? I don't need to adjust anything in the css file.

How can I do this?

Hello one and all,

Just a quick request here, I've written a script that sends an email with an attached file by the user. (docx, txt, pdf, doc, rtf) are the formats I have accepted. At the moment I'm sending them with the following...

Code: [Select]
$fileatt_type = "application/pdf"; // File Type
It works fine with all formats in older email clients, i.e, like yahoo before they updated the layout, but in the newer versions it's specific and if I try to send it this way it is always delivered as a .PDF and doesn't open if it is any of the other formats.

It may sound silly but I've searched a fair bit for the other extensions or formats to include instead of the above code (maybe something like application/doc or something) but there doesn't seem to be a list.

Can anyone point me in the right direction?

Much obliged, PHP the learned.

Good morning folks, I'm having an obscure issue with previously sent headers.

I have an add_category.php for the admin backend of an app I'm working on. It was working fine until I added a Post.php class, but the Post.php class doesn't even interact with add_categories.php outside the initialization file. When I use this file to add a category I get the normal

Quote

 

Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/qcic/assets/class/Post.php:94) in /opt/lampp/htdocs/qcic/admin/category.php on line 6

 

Like I said, this was working fine until I added the Post.php class. But the only time that they even come close to interacting is in the initializations.php which I put at the top of each of the pages and looks like this ->

<?php
require("../load.php");

require("../assets/class/User.php");
require("../assets/class/Category.php");
require("../assets/class/Post.php");

$user = $user_obj->getUsername(); 
$role = $user_obj->getRole();

$cat_obj = new Category($conn, $user);
$post_obj = new Post($conn, $user);

The relevant code for the add_category.php is ->

<?php
require("assets/initializations.php");

if(isset($_POST['add_cat'])) {
  $cat_obj->addCategory($_POST['cat_title']);
  header("Location: category.php?message=category-added");
  exit;
  } 
?>

After some research I've altered this a bit to this ->

<?php
require("assets/initializations.php");

if(isset($_POST['add_cat'])) {
  $cat_obj->addCategory($_POST['cat_title']);
  if(!headers_sent()) {
    header("Location: category.php?message=category-added");
    exit;
  } else {
    var_dump(headers_list());
  }
}
?>

Which returns this ->

Quote

array(5) { [0]=> string(23) "X-Powered-By: PHP/8.0.3" [1]=> string(38) "Expires: Thu, 19 Nov 1981 08:52:00 GMT" [2]=> string(50) "Cache-Control: no-store, no-cache, must-revalidate" [3]=> string(16) "Pragma: no-cache" [4]=> string(38) "Content-type: text/html; charset=UTF-8" }

I have no idea where those are coming from or why they're coming at all and that date is a long time ago.  Some of it looks familiar, some I've never seen before. I haven't come across a remedy that works yet though. Any suggestions?

 

EDIT: typo

Edited Monday at 03:52 PM by TechnoDiver

Hey,

I'm trying to open a .php file and read a comment block that is in the beginning of the file.

I'm having some trouble in that nothing is being echoed out.

Here is the reading file:

<?php

$fb = fopen("tepl.php", "r");

$data = fread($fb, 8192);

fclose($fb);

var_dump($data);

?>


here is the file (tepl.php) being read:

<?php
/*
Name: Test Plugin 1
URI: http://www.theorangeday.com/plugintest/
Description: This is just a test plugin because I need to test how this thing is going to work overall.
Author: Thomas Francis
Author URI: http://www.theorangeday.com/
Version: 0.1
*/

function test_plugin(){
echo "we loaded the test plug";
}

?>


the var_dump returns
Code: [Select]
string(321) " "
What's wrong here?

Hi there, 

How to work out??

We have our web page where we enter our client information.. Part A

Than same information we have to enter third party web page. Part B

How can we transfer same information fr our web page to third party web page like .. Input in text field instead of type each box…

Please if someone can guide us or any link to follow…

Hi:

How do I transfer an ID to a 3rd page.

Meaning:
Events.php
Code: [Select]
...
<a href="eventDetails.php?calID=<?=$row['calID'];?>"><?=$row['calName'];?></a>
...

Goes to eventDetails.php, and transfer/displays the calID properly:
Code: [Select]
<?php
include('include/myConn.php');
include('include/myNav.php');

$calID = $_REQUEST['calID'];

$query=mysql_query("select * from calTbl where calID = $calID") or die("Could not get data from db: ".mysql_error());

while($result=mysql_fetch_array($query))
{
$calName=$result['calName'];
$calDesc=$result['calDesc'];
$calDate=$result['calDate'];
$calID=$result['calID'];
}
?>

...
<a href="?calID=<?php echo $calID; ?>" onclick="openSesame();" class="myBold">Print</a>
...

However, when I click the "Print" link (I see it is properly writing the calID on the link - like eventDetailsPrint.php?calID=7. The "eventDetailsPrint.php" is written from a JavaScript file as a new window function), it is coming up blank.
Code: [Select]
<?php
include('include/myConn.php');
//$calID = $_REQUEST['calID'];
//$calID = $_SERVER['calID'];
//$calID = echo $_GET['calID'];
echo $_POST["calID"];

$query=mysql_query("select * from calTbl where calID = calID") or die("Could not get data from db: ".mysql_error());

while($result=mysql_fetch_array($query))
{
$calName=$result['calName'];
$calDesc=$result['calDesc'];
$calDate=$result['calDate'];
$calID=$result['calID'];
}

?>

...
<?php echo $calID; ?>
...

What is the trick to pass an ID from page to page to page?

Thanks.

I am trying to transfer some data from one Servers DB to a new server with cleaner tables. When i run my code the transfer seems to be working but the script just keeps running and never give the desired responses. First it collects the data (for testing i limited results by 1) then checks to see if the app is in the new DB, if so then it updates its contents. If not then it adds it. It seems to work for both updates and inserts but i must still be missing something. Thanks for any help.

Code: [Select]
<?php
function getTime()
    {
    $a = explode (' ',microtime());
    return(double) $a[0] + $a[1];
    }
$Start = getTime(); 
######################################################################
$connection1 = mysql_connect('','','');
if (!$connection1){
   die('Could not connect: ' . mysql_error());
}
$db_selected1 = mysql_select_db('', $connection1);
if (!$db_selected1) {
    die ('Could not connect: ' . mysql_error());
}

//if(isset($_REQUEST['appcounting'])){
//$appcounting = ($_REQUEST['appcounting'] + 1);
//$appnext = 1;
//$appgroup = $appcounting + $appnext;
//echo "Checked app $appcounting-$appgroup.<br />\n";
//}
//else{
//$appcounting = 0;
//$appnext = 1;
//}

$count = 0;
$appinfo = mysql_query("SELECT app_id, ipayAppID, Status, MID, BusinessContactName, BusinessContactPhone, BusinessEmail, BusinessWebsite, BusinessName, BusinessAddress, BusinessCity, BusinessState, BusinessZip, BusinessTaxID, BusinessMailingAddress, BusinessMailingCity, BusinessMailingState, BusinessMailingZip, agent_id, CreateTime, StatusChangeTime, ReceiveTime, ReviewTime, PayrollApprovalTime, PayrollPayTime, ApproveTime, DeclineTime, CancelTime, CancelDesc, PendingTime, PendingDesc FROM app ORDER BY app_id DESC LIMIT 0, 1") or die('SELECT ' . mysql_error());
while($row = mysql_fetch_array($appinfo))
{
$app_id[] = $row['app_id'];
$ipayAppID[] = $row['ipayAppID'];
$Status[] = $row['Status'];
$MID[] = $row['MID'];
$BusinessContactName[] = $row['BusinessContactName'];
$BusinessContactPhone[] = $row['BusinessContactPhone'];
$BusinessEmail[] = $row['BusinessEmail'];
$BusinessWebsite[] = $row['BusinessWebsite'];
$BusinessName[] = $row['BusinessName'];
$BusinessAddress[] = $row['BusinessAddress'];
$BusinessCity[] = $row['BusinessCity'];
$BusinessState[] = $row['BusinessState'];
$BusinessZip[] = $row['BusinessZip'];
$BusinessTaxID[] = $row['BusinessTaxID'];
$BusinessMailingAddress[] = $row['BusinessMailingAddress'];
$BusinessMailingCity[] = $row['BusinessMailingCity'];
$BusinessMailingState[] = $row['BusinessMailingState'];
$BusinessMailingZip[] = $row['BusinessMailingZip'];
$agent_id[] = $row['agent_id'];
$CreateTime[] = $row['CreateTime'];
$StatusChangeTime[] = $row['StatusChangeTime'];
$ReceiveTime[] = $row['ReceiveTime'];
$ReviewTime[] = $row['ReviewTime'];
$PayrollApprovalTime[] = $row['PayrollApprovalTime'];
$PayrollPayTime[] = $row['PayrollPayTime'];
$ApproveTime[] = $row['ApproveTime'];
$DeclineTime[] = $row['DeclineTime'];
$CancelTime[] = $row['CancelTime'];
$CancelDesc[] = $row['CancelDesc'];
$PendingTime[] = $row['PendingTime'];
$PendingDesc[] = $row['PendingDesc'];
$count++;
}

mysql_close($connection1);
######################################################################
$connection2 = mysql_connect('','','');
if (!$connection2){
die('Could not connect: ' . mysql_error());
}
$db_selected2 = mysql_select_db('', $connection2);
if (!$db_selected2){
    die ('Could not connect: ' . mysql_error());
}


$number = 0;
$count_insert = 0;
while($number <= $count)
{
$findapp = $app_id[$number];
$one = mysql_query("SELECT AppID FROM Apps WHERE `AppID`='$findapp'") or die('FIND ' . mysql_error());
$num_rows = mysql_num_rows($one);
if ($num_rows == 1){
$myBusinessContactName = $BusinessContactName[$number];
$myBusinessContactName = addslashes($myBusinessContactName);
$myBusinessName = $BusinessName[$number];
$myBusinessName = addslashes($myBusinessName);
$myBusinessCity = $BusinessCity[$number];
$myBusinessCity = addslashes($myBusinessCity);
$myBusinessMailingCity = $BusinessMailingCity[$number];
$myBusinessMailingCity = addslashes($myBusinessMailingCity);
$myPendingDesc = $PendingDesc[$number];
$myPendingDesc = addslashes($myPendingDesc);
$myCancelDesc = $CancelDesc[$number];
$myCancelDesc = addslashes($myCancelDesc);
$myBusinessAddress = $BusinessAddress[$number];
$myBusinessAddress = addslashes($myBusinessAddress);
$myBusinessMailingAddress = $BusinessMailingAddress[$number];
$myBusinessMailingAddress = addslashes($myBusinessMailingAddress);

mysql_query("UPDATE Apps SET `IpayAppID`='$ipayAppID[$number]', `Status`='$Status[$number]', `MID`='$MID[$number]', `ContactName`='$myBusinessContactName', `ContactPhone`='$BusinessContactPhone[$number]', `ContactEmail`='$BusinessEmail[$number]', `ContactWebsite`='$BusinessWebsite[$number]', `DBA`='$myBusinessName', `BusinessAddress`='$myBusinessAddress', `BusinessCity`='$myBusinessCity', `BusinessState`='$BusinessState[$number]', `BusinessZip`='$BusinessZip[$number]', `BusinessTaxID`='$BusinessTaxID[$number]', `MailingAddress`='$myBusinessMailingAddress', `MailingCity`='$myBusinessMailingCity', `MailingState`='$BusinessMailingState[$number]', `MailingZip`='$BusinessMailingZip[$number]', `Agent1ID`='$agent_id[$number]', `CreateTime`='$CreateTime[$number]', `StatusChangeTime`='$StatusChangeTime[$number]', `ReceivedTime`='$ReceiveTime[$number]', `ReviewedTime`='$ReviewTime[$number]', `PayrollApprovalTime`='$PayrollApprovalTime[$number]', `PayrollPayTime`='$PayrollPayTime[$number]', `ApproveTime`='$ApproveTime[$number]', `DeclineTime`='$DeclineTime[$number]', `CancelTime`='$CancelTime[$number]', `CancelDesc`='$myCancelDesc', `PendingTime`='$PendingTime[$number]', `PendingDesc`='$myPendingDesc' WHERE AppID='$app_id[$number]'") or die('UPDATE ' . mysql_error());
$number++;
}
elseif(isset($app_id[$number]) && isset($BusinessName[$number])){
echo "Transfered App $findapp<br />\n";
$myBusinessContactName = $BusinessContactName[$number];
$myBusinessContactName = addslashes($myBusinessContactName);
$myBusinessName = $BusinessName[$number];
$myBusinessName = addslashes($myBusinessName);
$myBusinessCity = $BusinessCity[$number];
$myBusinessCity = addslashes($myBusinessCity);
$myBusinessMailingCity = $BusinessMailingCity[$number];
$myBusinessMailingCity = addslashes($myBusinessMailingCity);
$myPendingDesc = $PendingDesc[$number];
$myPendingDesc = addslashes($myPendingDesc);
$myCancelDesc = $CancelDesc[$number];
$myCancelDesc = addslashes($myCancelDesc);
$myBusinessAddress = $BusinessAddress[$number];
$myBusinessAddress = addslashes($myBusinessAddress);
$myBusinessMailingAddress = $BusinessMailingAddress[$number];
$myBusinessMailingAddress = addslashes($myBusinessMailingAddress);

mysql_query("INSERT INTO Apps (AppID, IpayAppID, Status, MID, ContactName, ContactPhone, ContactEmail, ContactWebsite, DBA, BusinessAddress, BusinessCity, BusinessState, BusinessZip, BusinessTaxID, MailingAddress, MailingCity, MailingState, MailingZip, Agent1ID, CreateTime, StatusChangeTime, ReceivedTime, ReviewedTime, PayrollApprovalTime, PayrollPayTime, ApproveTime, DeclineTime, CancelTime, CancelDesc, PendingTime, PendingDesc) VALUES ('$app_id[$number]', '$ipayAppID[$number]', '$Status[$number]', '$MID[$number]', '$myBusinessContactName', '$BusinessContactPhone[$number]', '$BusinessEmail[$number]', '$BusinessWebsite[$number]', '$myBusinessName', '$myBusinessAddress', '$myBusinessCity', '$BusinessState[$number]', '$BusinessZip[$number]', '$BusinessTaxID[$number]', '$myBusinessMailingAddress', '$myBusinessMailingCity', '$BusinessMailingState[$number]', '$BusinessMailingZip[$number]', '$agent_id[$number]', '$CreateTime[$number]', '$StatusChangeTime[$number]', '$ReceiveTime[$number]', '$ReviewTime[$number]', '$PayrollApprovalTime[$number]', '$PayrollPayTime[$number]', '$ApproveTime[$number]', '$DeclineTime[$number]', '$CancelTime[$number]', '$myCancelDesc', '$PendingTime[$number]', '$myPendingDesc')") or die('INSERT ' . mysql_error());
$number++;
$count_insert++;
}
}


if($count_insert == 0){
echo "All apps have been found.<br />\n";
exit;
}

mysql_close($connection2);
######################################################################
$End = getTime();
echo "Time taken = ".number_format(($End - $Start),2)." secs<br />\n";
//header('Refresh: 60; url=transfer_apps.php?appcounting=$appcounting');

?>

Hi all

I am updating a old system to transfer files, and implementing download data as zip. My client want to move to a new ISP due to problems with the current ISP

The old system run "5.5.38-1~dotdeb+7.1" (not sure how to read it, why plus seven?), and the new systenm "7.2.31-pl0-zoneos".

The code, same on both can zip and unzip. However the old system causes me problems as:

1) the new system can handle non English characters, the old cannot, eg replacing Ü with _ and ä with õ. How can I get around this?

2) the old system can make a zip and I can download it. However on win7 and some old zip stuff there I can open it.
I cannot upload to the new server, I get error 19, not a valid zip.
Same when downloading to win10, it cannot open the zip. 7-zip cannot open it either.
The old system can accept the zip from it self.
Zips from my windows both 7 and 10 can upload to both as well as zip from the new system. No problems.
A work-around - I download the weird zip on win7, unzip and re-zip with windows and upload to the new system. It works, it just leaves me with some weird character. There are 7705 files so I will not correct it manually.

 

So my problems is, some old system running "5.5.38-1~dotdeb+7.1" cannot handle non-English characters and the zip is not valid.

Does anyone have any idea how to handle the charcaters, and maybe - why the zip is in an old format not readable by newer systems?

I am trying to write a basic Private Messaging script.   I have my main page which lists all messages that have been received. I then want to click on an href link to run an ajax query to bring information in from another .php file which shows the content of the selected message.   But I can't fathom out how to do this with an href. First off, is it possible? If so, can anyone tell me what I am doing wrong?   The relevant script is:   privatemessage.php:

<?php
$query2 = DB::getInstance()->query("SELECT 
                c.id as cid, c.title, c.time, 
		m.id as membersid, m.username, 
		m.member_first_name, m.member_last_name 
		FROM conversation as c, members as m
		WHERE ((c.member1='{$memberid}' 
		and c.read1='Yes' and c.removed1='No' 
		and m.id=c.member2) 
		OR (c.member2='{$memberid}' and c.read2='Yes' 
		and c.removed2='No' and m.id=c.member1)) 
		GROUP BY m.id ORDER BY m.id DESC");
?>

<table>
<tr>
	<td align="left">
		<?php echo htmlentities($result2->member_first_name); ?>
		<?php echo htmlentities($result2->member_last_name); ?>
		<?php echo "("; echo htmlentities($result2->username); echo ")"; ?>
	</td>
	<td align="right">
		<?php echo timeAgo(strtotime($result2->time)); ?>
	</td>
</tr>
<tr>
	<td colspan="2" align="left">
		<form action="" method="post">	
		<?php echo "Subject: "; ?>
		<?php echo "<input type='hidden' name='id' id='id' value='{$result2->cid}'>"; ?>
		<a href="#$result2->cid" onClick="showMessages(this.value)"><?php echo htmlentities($result2->title); ?>
		</form>
		<script src="//code.jquery.com/jquery-1.10.2.js"></script>
		<script src="js/readmessage.js"></script>
	</td>
</tr>

My readmessage.js code is:

function showMessages(str)
{
if (str=="")
  {
  document.getElementById("txtMessage").innerHTML="";
  return;
  } 
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtMessage").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","readmessage.php?q="+str,true);
xmlhttp.send();
}

And my readmessage.php code is:

<?php
require 'core/memberinit.php';
$member = new Member();
include 'timeago.php';

$memberid = $member->data() ->id;

if(isset($_GET['q'])) {
	$q = html_entity_decode($_GET['q']);
	
	$req1 = DB::getInstance()->query("SELECT title, member1, member2 FROM conversation WHERE id='{$q}' AND id2='1'");
	
	foreach ($req1->results() as $dn1)
	
	if($req1->count()==1)
	{
		if(($dn1->member1=='{$memberid}') or ($dn->member2=='{$memberid}'))
		{
			if($dn1->member1=='{$memberid}')
			{
				DB::getInstance()->query("UPDATE conversation SET read1='Yes' where id='{$q}' and id2='1'");
				$user_partic = 2;
			} else {
				DB::getInstance()->query("UPDATE conversation SET read2='Yes' where id='{$q}' and id2='1'");
				$user_partic = "1";
			}
			$req2 = DB::getInstance()->query("SELECT conversation.time, conversation.message, 
						members.id as userid, members.username, members.member_first_name, members.member_last_name 
						FROM conversation, members 
						WHERE conversation.id='{$id}' AND members.id=conversation.member1 
						ORDER BY conversation.id2");
			if(isset($_POST['message']) and $_POST['message']!='')
			{
				$message = $_POST['message'];
				if(get_magic_quotes_gpc())
				{
					$message = stripslashes($message);
				}
				$message = $string(nl2br(htmlentities($message, ENT_QUOTES, 'UTF-8')));
				if(	DB::getInstance()->query("INSERT into conversation 
					(id, id2, title, member1, member2, message, time, read1, read2)
					VALUES('{$q}', '{(intval($req2->id2)+1)}', '', '{$memberid}', '', '{$message}', '.time().', '', '')") 
					and 
				DB::getInstance()->query("UPDATE conversation SET read'{$user_partic}'='Yes' WHERE id='{$q}' AND id2='1'"));
			}
			echo "<h4>";
			echo $dn1->title; 
			echo "</h4><br><br>";
			echo "<table><col width='150px'><col width='50px'><col width='150px'>";
			echo "<tr><th>Member</th><th>&nbsp</th><th>Message</th></tr>";
			
			foreach ($req2->results() as $dn2)
			{
			echo "<tr><td>";
			echo $dn2->members.member_first_name;
			echo $dn2->members.member_last_name;
			echo " (";
			echo $dn2->members.username;
			echo ")	</td><td></td><td>";
			echo timeAgo(strtotime($dn2->time));
			echo "<br>";
			echo $dn2->message;
			echo "</td></tr>";
			}
			echo "</table>";
		}
	}
}
?>

However, just to try and find where the error lies, I have tried the following code for my readmessage.php file:

<?php
require 'core/memberinit.php';
$member = new Member();
include 'timeago.php';

$memberid = $member->data() ->id;

if(isset($_GET['q'])) {
	$q = intval($_GET['q']);

echo $q;
}
?>

Which always returns a "0" reply - which says to me that my files are talking, but that the id isn't being carried across.   Anybody got any suggestions?   Many thanks for any help offered.

Hi everyone:

When I do Classic ASP programming, I use a "Server.Transfer" method to move one page into another on the server, before it is dished out to a viewer's browser.

Like this:

Code: [Select]
Page-1.asp

<%@ language=vbscript%>

<%

server.transfer "Page-2.asp"

%>

<html>

...

</html>

Is there a method in PHP that would do this? It's easy in ASP, but I can't find an answer on GOOGLE.

Thanks!

Hi guys and gals, i have two sites which interact with each other, if someone lands on my local site and searches, if the answer isnt found it will transfer them to my other site which has a wider range for what they are looking for.

My question is, how would i go about delaying the transfer and displaying a message that the user is now being transfered to a different site?

I was thinking something similar to one of those uploading please wait type overlays or somthing?

Any ideas would be useful, at the moment its done with a simple form and php, but is instant.

Sorry if this isn't the right forum, I wasn't sure where to post this. Alright, so I have a high score submit script, and it goes as follows...

This is the actionscript:
Code: [Select]
on (release) {
var usco LoadVars = new LoadVars();
uscore.name = _root.suname;
uscore.score = _root.suscore.stime;
uscore.game = "alien";
uscore.mode = "survival";
uscore.sendAndLoad("linkhere", uscore, "POST");
play();
}
Note: We have also tried:
Code: [Select]
on (release) {
var usco LoadVars = new LoadVars();
uscore.name = _root.suname;
uscore.score = _root.suscore.stime;
uscore.game = "alien";
uscore.mode = "survival";
var uscoresubmit:LoadVars = new LoadVars();
uscore.sendAndLoad("linkhere", uscoresubmit, "POST");
play();
}

The PHP is:
<?PHP
include('Connect.php');
$name=$_POST['name'];
$name=mysql_real_escape_string($name);
$score=$_POST['score'];
$score=mysql_real_escape_string($score);
$game=$_POST['game'];
$game=mysql_real_escape_string($game);
$mode=$_POST['mode'];
$mode=mysql_real_escape_string($mode);
if(!empty($game))
{
mysql_query("INSERT INTO scores(game, name, score, mode) VALUES ('$game', '$name', '$score', '$mode')");
}
?> 
I have also tried running a number of things on the "else" of that if(!empty($game)) and nothing has pulled through, so I'm under the notion that it isn't loading the page in sendAndLoad()?

It was working before, but it appears to have just stopped, we're not sure what we changed.

Any help would be greatly appreciated!
Thanks,
Xyphon

Can PHP working for money transfer online?

Any simple code for this?

Thank you   

I'm not asking for specific coding help, but what I am looking for is an answer from someone who might have dealt with this in the past and can help shed some light on the subject.

I'm working on a website that allows the user to upload several images at a time. I have serverA that hosts the website and database and serverB that hosts the image uploads.

I'm looking for the best (preferably the fastest) method to transfer image files from serverA to serverB.

I know I can transfer the files through FTP in PHP and I can also do it via HTTP by making a small script on serverB that would accept _POST transfers of each file.. Are there other methods?

Remember, there are 2-3 images sent each time.. so just because a method might be "preferred," I don't want to make the user wait longer than they have to.

Thanks for your time.

I am having trouble transferring data from provideX ODBC to MySQL using Navicat. So, I am wanting to write a php script that will write all of the data to a text file, then do a MySQL "DATA LOAD INFILE".

I am VERY limited as far as the SQL functions that are available to me with the ODBC connection. The table does not have a special unique identifier other than the item number.

This table I am pulling from has a little over 100,000 items.  How can I get php to process the full 100,000 rows.  I thought about getting it to process 5,000 rows sorted by item #> break > pass the last item to the next page > then process the next batch of 5,000 sorted by item # where the item is greater than the item processed on the last page. ??

Jake

I have not tested this code yet. I just kind of threw it together.
Code: [Select]
<?php
set_time_limit(900);
ini_set('max_execution_time', '999');

$myFile = "item_master.txt";
unlink($myFile);

$fp = fopen("item_master.txt", "w"); 


require("..\inc/data.inc");

if (!$conn)
  {exit("Connection Failed: " . $conn);}
$sql="SELECT ITEM_NUM, DESCRIPTION_1, DESCRIPTION_2, ITEM_CLASS, ALPHA_SORT, STANDARD_PACK, GL_TABLE, PRIMARY_VND_NUM, VENDOR_ITEM_NUM, ACTIVE, ITEM_PRICE_CLS FROM ic_inventry_mast";

$rs=odbc_exec($conn,$sql);
if (!$rs)
  {exit("Error in SQL");}
while (odbc_fetch_row($rs))
  {
$ITEM_NUM=trim(odbc_result($rs,"ITEM_NUM"));
$DESCRIPTION_1=trim(odbc_result($rs,"DESCRIPTION_1"));
$DESCRIPTION_2=trim(odbc_result($rs,"DESCRIPTION_2"));
$ITEM_CLASS=trim(odbc_result($rs,"ITEM_CLASS"));
$ALPHA_SORT=trim(odbc_result($rs,"ALPHA_SORT"));
$STANDARD_PACK=trim(odbc_result($rs,"STANDARD_PACK"));
$GL_TABLE=trim(odbc_result($rs,"GL_TABLE"));
$PRIMARY_VND_NUM=trim(odbc_result($rs,"PRIMARY_VND_NUM"));
$VENDOR_ITEM_NUM=trim(odbc_result($rs,"VENDOR_ITEM_NUM"));
$ACTIVE=trim(odbc_result($rs,"ACTIVE"));
$ITEM_PRICE_CLS=trim(odbc_result($rs,"ITEM_PRICE_CLS"));


$ITEM_NUM=str_replace('@','',$ITEM_NUM);
$DESCRIPTION_1=str_replace('@','',$DESCRIPTION_1);
$DESCRIPTION_2=str_replace('@','',$DESCRIPTION_2);
$ITEM_CLASS=str_replace('@','',$ITEM_CLASS);
$ALPHA_SORT=str_replace('@','',$ALPHA_SORT);
$STANDARD_PACK=str_replace('@','',$STANDARD_PACK);
$GL_TABLE=str_replace('@','',$GL_TABLE);
$PRIMARY_VND_NUM=str_replace('@','',$PRIMARY_VND_NUM);
$VENDOR_ITEM_NUM=str_replace('@','',$VENDOR_ITEM_NUM);
$ACTIVE=str_replace('@','',$ACTIVE);
$ITEM_PRICE_CLS=str_replace('@','',$ITEM_PRICE_CLS);


$row="$ITEM_NUM@$DESCRIPTION_1@$DESCRIPTION_2@$ITEM_CLASS@$ALPHA_SORT@$STANDARD_PACK@$GL_TABLE@$PRIMARY_VND_NUM@$VENDOR_ITEM_NUM@$ACTIVE@$ITEM_PRICE_CLS\r\n";

fwrite($fp, $row); 

  }
  
  
fclose($fp); 

?>