PHP - Fopen Fails Where Copy Works Fine / Windows

Code: [Select]
<?php
$objConnect = mysql_connect("localhost","","cgdfgdfg") or die(mysql_error());
$objDB = mysql_select_db("ffdfvbbd");
$pic2 = "SELECT * FROM images";
if (!isset($_GET['Page'])) $_GET['Page']='0';
$pic1 = mysql_query($pic2);
$Num_Rows = mysql_num_rows($pic1);
$Per_Page = 16;   // Per Page
$Page = $_GET["Page"];
if(!$_GET["Page"])
{$Page=1;}
$Prev_Page = $Page-1;
$Next_Page = $Page+1;
$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{$Num_Pages =1;}
else if(($Num_Rows % $Per_Page)==0)
{$Num_Pages =($Num_Rows/$Per_Page) ;}
else
{$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;}
$pic2 .="ORDER by thumbnailID DESC LIMIT $Page_Start , $Per_Page" ;
$pic1  = mysql_query($pic2);
$cell = 0;
$link1 = "SELECT * FROM images";
echo '
    <div id="tablediv">
      <table border="0" cellpadding="17" cellspacing="0" class="table">
        <tr>';

  while($pic = mysql_fetch_array($pic1)) {

    if($cell % 4 == 0) {
      echo '</tr><tr>';
    }

    if($cell == 2) {
      echo '
        <td>
          filler
        </td>';
    } elseif ($cell == 3) {
      echo '
        <td>
          filler
        </td>';
    } else {
      echo '
        <td>
          <a href="/' . $pic["link"] . '.php">
            <div class="image">
              <img src="https://s3.amazonaws.com/images/' . $pic["pic"] . '.png" 
                   alt="' . $pic["alt"] . '" 
                   height="200" 
                   width="200" 
              />
            </div>
          </a>
        </td>'; 
    }
    $cell++;
  }
  echo '</tr></table></div>';
?>The code above works just fine.

However, once I add a WHERE function,as shown below, I get a "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource" error.

Code: [Select]
<?php
$objConnect = mysql_connect("localhost","","cgdfgdfg") or die(mysql_error());
$objDB = mysql_select_db("ffdfvbbd");
$pic2 = "SELECT * FROM images WHERE folder = 'blog' "; //WHERE FUNCTION IS HERE
if (!isset($_GET['Page'])) $_GET['Page']='0';
$pic1 = mysql_query($pic2);
$Num_Rows = mysql_num_rows($pic1);
$Per_Page = 16;   // Per Page
$Page = $_GET["Page"];
if(!$_GET["Page"])
{$Page=1;}
$Prev_Page = $Page-1;
$Next_Page = $Page+1;
$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{$Num_Pages =1;}
else if(($Num_Rows % $Per_Page)==0)
{$Num_Pages =($Num_Rows/$Per_Page) ;}
else
{$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;}
$pic2 .="ORDER by thumbnailID DESC LIMIT $Page_Start , $Per_Page" ;
$pic1  = mysql_query($pic2);

My mysql table includes column thumbnailID   folder   link   pic   alt   time

The folder column is there so I can specify what I want in the page.

Anyhow, why won't it work?

Hello everyone,

I'm having this problem which is really annoying, tried to solve it but couldn't, I write that code in PHPMyAdmin and it works great, but it doesn't work in the website it self

ok long story short, there are three tables, hotels, cities, countries
hotels include in addition to hotel info, 2 columns (city_id) and (country_id)
Cities include id and name and also countries include id and name

what I was trying to do, that when a person inputs a city or country name in the search form, it should get the hotels that exists in this city or country, but unfortunately it shows all the hotels in all cities and countries, although the pagination code for number of pages works just fine, it count the number of hotels in that city or country and show the number of pages correctly

so here is the code for both

for hotel search

Code: [Select]
class hotelManager
{


public function getHotel($where)
{
$where = isset($_POST['where']) ? $_POST['where'] : "";
$dbObj = new DB();
$sql = "select * from hotels where city_id = (select id from cities where name = '$where' ) or country_id = (select id from countries where name = '$where' )";
$result = MYSQL_QUERY($sql);
$arr = array();
echo "<table>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td valign=\"top\" width=\"120px\">";
$rowid = $row['id'];
$imageqry=mysql_query("SELECT * FROM `hotelphotos` where hotel_id='$rowid' LIMIT 1");
$image=mysql_fetch_array($imageqry);
$imagename=$image['attachmentName'];
echo "<img src=\"foxmaincms/webroot/files/small/$imagename\"/>";
echo "</td>";
echo "<td valign=\"top\">";

echo "<table>
<tr>
<td valign=\"top\">
<a href=\"hotels.php?id=".$row['id']."\" class=\"titleslink\">".$row['name']."</a>
</td>
</tr>
<tr>
<td class=\"text\" valign=\"top\">
".$row['location']."
</td>
</tr>
</table>";

echo "</td>";
echo "</tr>";
}
echo "</table>";

for hotel pagination

Code: [Select]
<?php
  include("includes/hotelsManager.php");
  $hotelObj = new hotelManager();
  $where = isset($_POST['where']) ? $_POST['where'] : "";
  if(isset($_POST['where']))
  {
    
$hotelObj -> getHotel($where);


$per_page = 9;

//Calculating no of pages
$sql = "select * from hotels where city_id = (select id from cities where name = '$where' ) or country_id = (select id from countries where name = '$where' )";
$result = MYSQL_QUERY($sql) or die("<br />No Hotels found in this city, please check the city name and try again");
$count = mysql_num_rows($result);
$pages = ceil($count/$per_page)
?>


<div id="loading" ></div>
<div id="maincontent" ></div>
<ul id="pagination">
thank you in advance

 FOR the CMS go to http://sandeepthapa.com.np/project/admin
and login in
username: user
pasword: 123456
with both Chrome and IE. pleease
 
and site is http://sandeepthapa.com.np/project/

it works fine with Chrome, but not with IE.
please help me
this is my first CMS . i am learning..  it
i use joommla templetefor design. oz i am not a designer



//..here is the code for process_login.php  page

<?php require_once("includes/session.php"); ?><?php require_once("includes/connection.php"); ?><?php require_once("includes/functions.php"); ?><?php

   if (logged_in()) {
      redirect_to("content.php");
   }

   
   if (isset($_POST['submit']))
 {
   
   
      
      
      if(!$_POST['username'])
      {
      echo ' Make sure u type in username';
      }
      if( !$_POST['password'])
      {
      echo 'make sure you type password';
      }

      $username = trim(mysql_prep($_POST['username']));
      $password = trim(mysql_prep($_POST['password']));
      $hashed_password = sha1($password);
   
      
   
         // Check database to see if username and the hashed password exist there.
         $query = "SELECT id, username ";
         $query .= "FROM users ";
         $query .= "WHERE username = '{$username}' ";
         //$query .= "AND hashed_password = '{$hashed_password}' ";
         $query .= "AND hashed_password = '{$hashed_password}' ";
         $query .= "LIMIT 1";
         $result_set = mysql_query($query) or die(mysql_error());
         if(!$result_set)
         {die("Database connection failed: " . mysql_error());}
         confirm_query($result_set);
         if (mysql_num_rows($result_set) == 1) {
            // username/password authenticated
            // and only 1 match
            $found_user = mysql_fetch_array($result_set);
            //echo $found_user['id'];
            
            
            $_SESSION['user_id'] = $found_user['id'];
            $_SESSION['username'] = $found_user['username'];
            
         
            
            //echo 'test query';
         
            redirect_to("content.php");
               }
}
               
                 
            
         
            
      
         
   else
   {
      
   
   echo 'error'.mysql_error();
   
   }
?>
</body>
</html>

Good day dear community.

I need to build a function which parses the domain from a url. I have used various ways to parse html sources. But this one is is a bit tricky! See the target i want to parse - it has some invaild Markup:

http://www.schulministerium.nrw.de/BP/SchuleSuchen?action=644.0013008534253&SchulAdresseMapDO=194190

well what do you think - can i apply this code here


<?php
require_once('config.php'); // call config.php for db connection
$filename = "url.txt"; // Include the txt file which have urls
$each_line = file($filename);
foreach($each_line as $line_num => $line)
{
    $line = trim($line);
    $content = file_get_contents($line);
    //echo ($content)."<br>";
    $pattern = '/<td>(.*?)<\/td>/si';
    preg_match_all($pattern,$content,$matches);

    foreach ($matches[1] as $match) {
        $match = strip_tags($match);
        $match = trim($match);
        //var_dump($match);
        $sql = mysqli_query("insert into tablename(contents) values ('$match')");
        //echo $match;
    }
}
?>


well i have to rework the parser-part of this script. I need to parse somway different - since i have other site here.

Can anybody help me  here to get a better regex - or a better way to parse this site ...

Any and all help will be greatly apprecaited.

regards
db1

Hi, I'm not totally sure if this is the right section for this question but...

I have my dev environment (my laptop) - windows vista, apache web server, also using my laptop as a client.

I have my php project on the web server, I go to the login page in my browser (IE8) and login in, if it's valid it reloads the page with the user detail etc..it works.

I've moved it onto a linux server (i think it still uses apache), I go to the login page in my browser (IE8) and login in. A blank page is displayed BUT if i hit refresh the user detail is displayed as expected.
Also if I logout, again a blank page (it should display the login page) but when I hit refresh this time, it stays blank.

I won't post my code just yet as I was wondering if anyone ever had the same issue before?

Windows..works ok, Linux..doesn't work ok till refresh, but even then that doesn't work for the logout.
My other thought is that it may work ok in windows because everythings on my laptop as in c:/php and the web server.

Not much to go on I know but it may ring a bell with someone.

thanks

Hi all,

I wonder if any of you have this problem before..

I have a login page with "checked box remember me" - It is working fine in my localhost machine I can see the COOKIE in my browser's option setting (Firefox).

But now the problem is: When I run the script in my test server; and do exactly the same thing..the COOKIE did not seem know.

When I logged in as an admin and checked the box. And closed all the browser. Then, open the browser (Firefox)and go to the index page (landing page) then it redirect me to the login page instead. I looked the at COOKIE setting in my Firefox and I can it is stored there.

Any ideas whats wrong?

hi i have the script below which copies data from one table to another but will only insert new data update current data or delete old data from tempproducts to products then it will delete the tempproducts from the db however i keep getting this error:

Warning: mssql_query() [function.mssql-query]: Query failed in E:\UpdateProducts.php on line 33

updateproducts.php
Code: [Select]
<?php
include('../../otherscripts/functions.php');
$log = new Logging(); 

// create DB connection
 $host = "localhost";
 $user = "user";
 $pass = "pass";
 $mydb = "db";

 $db = mssql_connect($host,$user,$pass);
 
//Select Database
 mssql_select_db($mydb);
 

 // delete all old data
    $sql0 = "SELECT * FROM tempproduct";
    $sql1 = "INSERT INTO products SELECT * FROM tempproduct WHERE manf_part_no NOT IN (SELECT manf_part_no FROM products) AND supp_id NOT IN (SELECT supp_id FROM products)";
    $sql2 = "DELETE FROM products WHERE manf_part_no NOT IN (SELECT manf_part_no FROM tempproduct) AND supp_id NOT IN (SELECT supp_id FROM tempproduct)";
    $sql3 = "UPDATE p1 SET p1.avail_qty = t1.avail_qty, p1.cost_price = t1.cost_price, p1.rrp = t1.rrp, p1.date_added = t1.date_added, p1.description = t1.description FROM Products p1 INNER JOIN tempproduct t1 ON (p1.manf_part_no = t1.manf_part_no AND p1.supp_id = t1.supp_id)";
    $sql4 = "TRUNCATE TABLE tempproduct";

//If tempproduct is empty done Execute Commands if it is full then execute commands

$query = mssql_query($sql0) or die($log->lwrite('Failed to select for count from db'));
$rowcount = mssql_num_rows($query);

if($rowcount == 0){
$log->lwrite('Teh tempproduct am emptyish');
}
else{
   mssql_query($sql1) or die($log->lwrite('Failed to insert to db'.$sql1));
   mssql_query($sql2) or die($log->lwrite('Failed to Delete from db'));
   mssql_query($sql3) or die($log->lwrite('Failed to Update db'));
   mssql_query($sql4) or die ($log->lwrite('Failed to TRUNCATE db'));
}
?>

if i run $sql1 command in the sql manager it runs fine and no errors occur?

I have strange problem with SOAP. My file SchoolAPI look like that:


<?php
require_once('../require/constants.php');
require_once('../require/connection.inc.php');
 
class SchoolAPI{

private $dbh;

   

public function __construct()
    {
 

 

$this->dbh = new PDO(DRIVER.':host='.HOST.';dbname='.DB, USER, PASSWORD);
  

}
  

//function return all subcjects

public function getSubjects(){

$sth = $this->dbh->prepare('  SELECT id, nazwa ROM subjects');

$sth->execute(); 

 

return $sth->fetchAll(PDO::FETCH_NUM); 

//return array(array("1", "subject1"),array("2", "subject2"));

}

//function return all classes

public function getClasses(){

$sth = $this->dbh->prepare('  SELECT id, nazwa FROM classes');

$sth->execute();  
 

return $sth->fetchAll(PDO::FETCH_NUM);

//return array(array("1", "class1"),array("2", "class2"));

}
  
}
ini_set("soap.wsdl_cache_enabled", "0");
$server = new SoapServer("SchoolAPI.wsdl");
$server->setClass("SchoolAPI");
$server->handle();
?>


wsdl file is named SchoolAPI.wsdl and look like that:


<wsdl:definitions  

xmlns="http://schemas.xmlsoap.org/wsdl/" 

xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" 

xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" 

xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" 

xmlns:xsd="http://www.w3.org/2001/XMLSchema" 

xmlns:tns="http://schema.example.com" 

targetNamespace="http://schema.example.com" >
  
  <wsdl:types>
  

<xsd:schema targetNamespace="http://schema.example.com">

<xsd:complexType name="myarry2">

<xsd:sequence>

<xsd:element minOccurs="0" maxOccurs="unbounded" name="row" nillable="true" type="xsd:string" /> 

</xsd:sequence>

</xsd:complexType>

</xsd:schema>
    <xsd:schema targetNamespace="http://schema.example.com">

<xsd:complexType name="myarray">

<xsd:sequence>

<xsd:element minOccurs="0" maxOccurs="unbounded" name="table" nillable="true" type="tns:myarry2" /> 

</xsd:sequence>

</xsd:complexType>

</xsd:schema>
  </wsdl:types>

  <wsdl:message name="getSubjectsRequest"></wsdl:message>
  <wsdl:message name="getSubjectsResponse">
    <part name="getSubjectsReturn" type="tns:myarray"/>
  </wsdl:message>

  <wsdl:message name="getClassesRequest"></wsdl:message>
  <wsdl:message name="getClassesResponse">
    <part name="getClassesReturn" type="tns:myarray"/>
  </wsdl:message>

  <wsdl:portType name="SchoolAPIPortType">
    <wsdl:operation name="getSubjects">
      <wsdl:input message="tns:getSubjectsRequest"/>
      <wsdl:output message="tns:getSubjectsResponse"/>
    </wsdl:operation>

    <wsdl:operation name="getClasses">
      <wsdl:input message="tns:getClassesRequest"/>
      <wsdl:output message="tns:getClassesResponse"/>
    </wsdl:operation>
  </wsdl:portType>

  <wsdl:binding name="SchoolAPIBinding" type="tns:SchoolAPIPortType">
    <soap:binding transport="http://schemas.xmlsoap.org/soap/http"/>
    <wsdl:operation name="getSubjects">
      <soap:operation soapAction="urn:SchoolAPI/getSubjects" style="document"/>
      <wsdl:input> <soap:body use="literal"/></wsdl:input>
      <wsdl:output><soap:body use="literal"/></wsdl:output>
    </wsdl:operation>
    <wsdl:operation name="getClasses">
      <soap:operation soapAction="urn:SchoolAPI/getClasses" style="document"/>
      <wsdl:input> <soap:body use="literal"/></wsdl:input>
      <wsdl:output><soap:body use="literal"/></wsdl:output>
    </wsdl:operation>
  </wsdl:binding>
  
  <wsdl:service name="SchoolAPI">
    <wsdl:port name="SchoolAPIPort" binding="tns:SchoolAPIBinding">
      <soap:address location="http://localhost:82/myschool/webservices/SchoolAPI.php" />
    </wsdl:port>
  </wsdl:service>
</wsdl:definitions>


The problem is that correct data is returned olny by first function declarated in <wsdl:binding> section. In this example correct data will be return by getSubjects function, and function getClassses return null. However, if we change order and put getClasses operation first in binding section like this:


  <wsdl:binding name="SchoolAPIBinding" type="tns:SchoolAPIPortType">
    <soap:binding transport="http://schemas.xmlsoap.org/soap/http"/>

 <wsdl:operation name="getClasses">
      <soap:operation soapAction="urn:SchoolAPI/getClasses" style="document"/>
      <wsdl:input> <soap:body use="literal"/></wsdl:input>
      <wsdl:output><soap:body use="literal"/></wsdl:output>
    </wsdl:operation>
    <wsdl:operation name="getSubjects">
      <soap:operation soapAction="urn:SchoolAPI/getSubjects" style="document"/>
      <wsdl:input> <soap:body use="literal"/></wsdl:input>
      <wsdl:output><soap:body use="literal"/></wsdl:output>
    </wsdl:operation>
  </wsdl:binding>


then correct data will be return by getClasses function, and getSubjects will return null. Do you know what is going on? I do my best to solve this problem and I have no idea what is wrong...

Hello,
The following is my situation where I seem to get a 500 error code from the linux server:

i have an 'index' file like this:
Code: [Select]
<?php
require("includes/config.php");

$a = $_REQUEST['a'];

switch ($a)
{
   case "home":
      include("frontpage/main.php");
   case "user-process":
      include("user-process.php");
}
?>
config.php is something like this:
Code: [Select]
<?php

require(includes/classes/session.class.php);
require(includes/classes/user.class.php);
require(includes/classes/db.class.php);
...
?>
Now if we fall into the case "home" it works fine. Instead, if we fall into user-process it writes to the logs file Fatal Error: Class User does not exist bla bla bla. Why doesn't it exist ? every class is included in the config.php file then index.php includes first config.php ( which has all the classes) and then includes the requested page.

I also have a .htaccess file which is as follows:
Code: [Select]
RewriteEngine On
RewriteRule ^([^/\.]+)?/?([^/\.]+)?/?([^/\.]+)?/?([^/\.]+)?/?([^/\.]+)?/?([^/\.]+)?/?([^/\.]+)?$ index.php?a=$1&b=$2&c=$3&d=$4&e=$5&f=$6&g=$7 [NC,L]
which is used to access in a SEO friendly way the pages that users request.

hi,

I want to write pdf file but it is getting garbage value

i check following url

http://bugs.php.net/bug.php?id=21904&edit=1

Code: [Select]
$fp = fopen($fdirandname,'wb');
fwrite($fp,$pdfcode);
fclose($fp);

Ok I am designing a php upload that will take a image file from a form and change the name of the file to the productnumber also recieved from the form. I had it working the otherday now it says Warning: copy() [function.copy]: open_basedir restriction in effect File() is not within the allowed path(s): (/home:/tmp:/usr) addpro.php on line 51.

my files are attached.... note that $pnum is the product number gotten from my form and image is the image being uploaded gotten from the form also.  The thing is it worked the other day but now it don't is it a change to the server ( I dont run the server) or did I mess up my code since then?  I really need a code that will do this two time over once for a small image being put into a folder called small and once for a folder called large both images being uploaded and being changed to $pnum.ext so they will both be displayed when being called out by the product number. but I can work on that after I get this one working.


line 51 is $copied = copy($_FILES['image']['tmp_name'], $newname);

Hi guys,

I am wirting a script to upload an image file, but I get the error:

copy() [function.copy]: Filename cannot be empty in

Obviouly it has something to do with the copy() function - (copy($HTTP_POST_FILES['product_img']['tmp_name'], $path))

I think it is not copying from my temp folder or something.

Can anyone help me out?

Code is:

Code: [Select]
//IMAGE FILE
$file_name = $_FILES['product_img']['name'];

echo '<p>File Name:' . $file_name . '</p>';
//IMAGE UPLOAD
// random 4 digit to add to file name
$random_digit=rand(0000,9999);

//combine random digit to file name to create new file name
//use dot (.) to combile these two variables
$new_image_name = $random_digit.$file_name;

echo $new_image_name;


//SET DESINATION FOLDER
$path= "uploads/".$new_image_name;
echo '<p>Path:' . $path . '</p>';
if($product_img !=none)
{
if(copy($HTTP_POST_FILES['product_img']['tmp_name'], $path))
{
echo "Successful<BR/>";
echo "File Name :".$new_file_name."<BR/>";
echo "File Size :".$HTTP_POST_FILES['product_img']['size']."<BR/>";
echo "File Type :".$HTTP_POST_FILES['product_img']['type']."<BR/>";
}
else
{
echo "Image upload Error<BR/>";
}
}
Any help would be greatly appreciated!

Thanks

This was generated through phpFormGenerator, but I'm getting the following warning message when a file is not uploaded. I didn't set it as a required field.

"Warning: copy() [function.copy]: Filename cannot be empty ..."

If it possible to skip this check since it's not supposed to be required to upload a file? I'm simply trying to make a contact form that emails basic information with the added option of attaching a file/picture.

Code: [Select]
<?php
include("global.inc.php");
$errors=0;
$error="The following errors occured while processing your form input.<ul>";
pt_register('POST','FullName');
pt_register('POST','Email');
pt_register('POST','Phone');
pt_register('POST','QuestionsorComments');
$QuestionsorComments=preg_replace("/(\015\012)|(\015)|(\012)/","&nbsp;<br />", $QuestionsorComments);$AttachPictureforQuote=$HTTP_POST_FILES['AttachPictureforQuote'];
pt_register('POST','Howdidyoufindus');
if($FullName=="" || $Email=="" ){
$errors=1;
$error.="<li>You did not enter one or more of the required fields. Please go back and try again.";
}
if($HTTP_POST_FILES['AttachPictureforQuote']['tmp_name']==""){ }
 else if(!is_uploaded_file($HTTP_POST_FILES['AttachPictureforQuote']['tmp_name'])){
$error.="<li>The file, ".$HTTP_POST_FILES['AttachPictureforQuote']['name'].", was not uploaded!";
$errors=1;
}
if(!eregi("^[a-z0-9]+([_\\.-][a-z0-9]+)*" ."@"."([a-z0-9]+([\.-][a-z0-9]+)*)+"."\\.[a-z]{2,}"."$",$Email)){
$error.="<li>Invalid email address entered";
$errors=1;
}
if($errors==1) echo $error;
else{
$image_part = date("h_i_s")."_".$HTTP_POST_FILES['AttachPictureforQuote']['name'];
$image_list[4] = $image_part;
copy($HTTP_POST_FILES['AttachPictureforQuote']['tmp_name'], "files/".$image_part);
$where_form_is="http".($HTTP_SERVER_VARS["HTTPS"]=="on"?"s":"")."://".$SERVER_NAME.strrev(strstr(strrev($PHP_SELF),"/"));
$message="Full Name: ".$FullName."
Email: ".$Email."
Phone: ".$Phone."
Questions or Comments: ".$QuestionsorComments."
Attach Picture for Quote: ".$where_form_is."files/".$image_list[4]."
How did you find us: ".$Howdidyoufindus."
";
$message = stripslashes($message);
mail("webmaster@gmail.com","Form Submitted at your website",$message,"From: phpFormGenerator");
?>


<!-- This is the content of the Thank you page, be careful while changing it -->

<h2>Thank you!</h2>

<table width=50%>
<tr><td>Full Name: </td><td> <?php echo $FullName; ?> </td></tr>
<tr><td>Email: </td><td> <?php echo $Email; ?> </td></tr>
<tr><td>Phone: </td><td> <?php echo $Phone; ?> </td></tr>
<tr><td>Questions or Comments: </td><td> <?php echo $QuestionsorComments; ?> </td></tr>
<tr><td>Attach Picture for Quote: </td><td> <?php echo $AttachPictureforQuote; ?> </td></tr>
<tr><td>How did you find us: </td><td> <?php echo $Howdidyoufindus; ?> </td></tr>
</table>
<!-- Do not change anything below this line -->

<?php 
}
?>
Thanks for your time and any help you can provide!

I came across the PHP clone method. Does this clone first level fields and methods or does it also do deep copying e.g. copying references to those fields. For example, a field may be an array. Does it make a copy of the actual array or does it refer to the same array position in memory, so if the original changes, then the copy's changes as well?

So I am tryting to create a script to upload a CSV file into a MySql DB. It has like 10K records into SQL   My Code is copy below ...   I get the following errors.   Line 16 is the $handle line 18 is the While Statement   Error: Warning: fopen(): Filename cannot be empty in C:\local\htdocs\ADPStorage\DemandCSV.php on line 16

Warning: fopen()expects parameter 1 to be resource, boolean given in C:\local\htdocs\ADPStorage\DemandCSV.php on line 18       I use my script for another table and it worked like a charm. Less data and less colums do.   Bad Code: (good Code sample below. this one)

<?php

$today = date("m.d.y.h.m.s");                       
echo $today;

$BPTD_fy = '2014';
$BPTD_updatedate = $today;

  $conn = mysql_connect("Localhost","root","password") or die (mysql_error());
  mysql_select_db("ds_storage",$conn);
  
	if(isset($_POST['submit']))
	{
		$file = $_FILES['file']['tmp_name'];
		  
		  $handle = fopen($file, "r");
		
		while(($fileop = fgetcsv($handle, 100000, ",")) !==FALSE)
		{
			$BPTD_fy = $fileop[0];
			$BPTD_Status = $fileop[1];
			$BPTD_Classification = $fileop[2];
			$BPTD_ProcureCat = $fileop[3];
			$BPTD_Product = $fileop[4];
			$BPTD_Project = $fileop[5];
			$BPTD_DSCategory = $fileop[6];
			$BPTD_Calculated = $fileop[7];
			$BPTD_CapacityType = $fileop[8];
			$BPTD_Amount = $fileop[9];
			$BPTD_Jul = $fileop[10];
			$BPTD_Aug = $fileop[11];
			$BPTD_Sep = $fileop[12];
			$BPTD_Oct = $fileop[13];
			$BPTD_Nov = $fileop[14];
			$BPTD_Dec = $fileop[15];
			$BPTD_Jan = $fileop[16];
			$BPTD_Feb = $fileop[17];
			$BPTD_Mar = $fileop[18];
			$BPTD_Apr = $fileop[19];
			$BPTD_May = $fileop[20];
			$BPTD_Jun = $fileop[21];
			$BPTD_Location = $fileop[22];
			$BPTD_Env = $fileop[23];
			$BPTD_Requester = $fileop[24];
			$BPTD_ServiceArea = $fileop[25];
			$BPTD_ServiceGroup = $fileop[26];
			$BPTD_DepHead = $fileop[27];
			$BPTD_Recgroup = $fileop[28];
			$BPTD_RecOwner = $fileop[29];
			$BPTD_Entrydate = $fileop[30];
			$BPTD_updatedate = $fileop[31];
			
			
			$sql = mysql_query("INSERT INTO inv_bpt_demand (Status, Classification, ProcureCat, Product, Project, DSCategory, Calculated, CapacityType, Amount, Jul, Aug, Sep, Oct, Nov, Dec, 
			Jan, Feb, Mar, Apr, May, Jun, Location, Env, Requester, ServiceArea, ServiceGroup, DepHead, Recgroup, RecOwner, Entrydate, updatedate) 
			
			VALUES ('$BPTD_Status', '$BPTD_Classification', '$BPTD_ProcureCat', '$BPTD_Product', '$BPTD_Project', '$BPTD_DSCategory', '$BPTD_Calculated', '$BPTD_CapacityType', '$BPTD_Amount',
			'$BPTD_Jul', '$BPTD_Aug', '$BPTD_Sep', '$BPTD_Oct', '$BPTD_Nov', '$BPTD_Dec', '$BPTD_Jan', '$BPTD_Feb', '$BPTD_Mar', '$BPTD_Apr','$BPTD_May', '$BPTD_Jun','$BPTD_Location',
			'$BPTD_Env','$BPTD_Requester', '$BPTD_ServiceArea', '$BPTD_ServiceGroup','$BPTD_DepHead', '$BPTD_Recgroup','$BPTD_RecOwner','$BPTD_Entrydate','$BPTD_updatedate')");
			
			if($sql)
			{
			echo 'Data Uploaded Successfully';
			
			}
		}
	}
  
?>

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <title>BPT Demand CSV</title>
  <link rel="stylesheet" type="text/css" href="file:///C|/local/htdocs/style/style.css" />
  <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
</head>
<body>
  <div id="mainWrapper">

    <form method="post" action="https://localhost/Storage/DemandCSV.php" enctype="multipart/form-data">
        <input type="file" name="file" />
        <br />
        <input type="submit" name="submit" value="Submit" />
    </form>
    
  </div><!--end mainWrapper-->
</body>
</html>

Similar Working code (good)

<?php
  $conn = mysql_connect("Localhost","root","password") or die (mysql_error());
  mysql_select_db("ds_storage",$conn);
  
	if(isset($_POST['submit']))
	{
		$file = $_FILES['file']['tmp_name'];
		  
		  $handle = fopen($file, "r");
		
		while(($fileop = fgetcsv($handle,1000,",")) !==FALSE)
		{
			
			$PC_Num = $fileop[0];
			$PC_Name = $fileop[1];
			$PC_BPTNUM = $fileop[2];
			$PC_busclass = $fileop[3];
			$PC_Note = $fileop[4];
			$PC_Acro = $fileop[5];
			$PC_type = $fileop[6];
						
			///echo $fileop[1];
			$sql = mysql_query("INSERT INTO inv_names (PC_Num, PC_Name, PC_BPTNUM, PC_busclass, PC_Note, PC_Acro, PC_type) 
			VALUES ('$PC_Num', '$PC_Name', '$PC_BPTNUM', '$PC_busclass', '$PC_Note', '$PC_Acro', '$PC_type')");
			
			if($sql)
			{
			echo 'Data Uploaded Successfully';
			
			}
		}
	}
  
?>

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <title>Upload CSV</title>
  <link rel="stylesheet" type="text/css" href="file:///C|/local/htdocs/style/style.css" />
  <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
</head>
<body>
  <div id="mainWrapper">

    <form method="post" action="https://localhost/Storage/Storage_CSV.php" enctype="multipart/form-data">
        <input type="file" name="file" />
        <br />
        <input type="submit" name="submit" value="Submit" />
    </form>
    
  </div><!--end mainWrapper-->
</body>
</html>

Please help and thx in advance   ~J