PHP - Need Help !!! Read And Write Image File In Php

Hey guys,

any suggestions how i could read and write msWord files without using the COM interface. I need to keep all the formatting intact though... any ideas?

many thanks

hgey guys im trying to create a text based login but im having trouble to get the echo to show up on submit.php which is the form action page for signup.html.

am not sure how i would make it showup on either file.

<?php
$myFile = "password.txt";
$fh = fopen($myFile, 'w') or die("can't open file");
$data= strip_tags($_POST['Username']);
fwrite($fh,$data);
fclose($fh);

$File = "username.txt";
$fh2 = fopen($File, 'w') or die("can't open file");
$mydata = strip_tags($_POST['Password']);
fwrite($fh2,$data);
fclose($fh2);

echo "You have Signed up Successfully Congrats!";
?>

HI,
I have a ms-access file which has linked table. The linked table is connected to a ODBC source (e.g MS-SQL or 3rd Party ODBC Driver).
WebPage(php) Apache, connecting to a ODBC DSN of MS-Access, MS-Access is having linked tables. Linked tables as from another ODBC source.
On the PHP Page, When I am trying to connect the ms-access odbc dsn , I am able to connect.
But when I query any of the linked tables, PHP is not able to query and is failing.

Does php has capabilities to read/write to linked tables in ms-access file.
Or it is issue with MS-Access
Or is it I am missing something.

Microsoft says, its an issue of PHP
https://social.msdn....forum=accessdev

Requesting you to please share your feedback

Regards
Rajendra Dewani

I am using apache web server on linux. I am using PHP for web designing. On web server, i want to show the configuration data by reading the ini file. I am creating this ini file from one php code itself. If this php code i run through linux terminal, the file is created with file and group owner as root.(i am having sudo rights on machine) Then if i try to read the ini file from my apache web server, it gives warning as failed to open stream: permission denied. I have tried changing the owner, and permissions to 777 of the file. Still it is not readable. On the other hand, if i run the php code of ini file creation through web server, ini file is created with file and group owner as apche. and web server is able to read/ write the file. But i want to create that file from root or some other user and later read/written by apache. How to give this access permission?

I need some help...I want to read the contents of a file into a variable and then insert/write that content into another file.

Code: [Select]
$handle = fopen($create_mysql_db_url, "rb");
  $contents = fread($handle, filesize($create_mysql_db_url));
  fclose($handle);

  $userFileName = $_POST['mysqluser'] . time() . ".php.txt";
  $fhandle = fopen($userFileName,"wb");
  fwrite($fhandle, $contents);
  fclose($fhandle);

  $fh = fopen($userFileName,"wb");
  $contents = fread($fh, filesize($userFileName));

  $content = preg_replace("/###USERNAME###/", $_POST['mysqluser'], $contents);
  $content = preg_replace("/###PASSWORD###/", $_POST['mysqlpass'], $content);

  fwrite($fh, $content);
  fclose($fh);

please help 

Hi there,

I have an xml file which actually hold the currency conversion information which I downloaded from xe.com

In the xml, the currency section snapshot looks like this:

<currency>
<csymbol>EUR</csymbol>
<cname>Euro</cname>
<crate>0.713</crate>
<cinverse>1.403 </cinverse>
</currency>
this is the conversion of USD to Euro. And it tells how much is 1USD gonna be in Euros. i.e 1 USD = 0.713 EUR

I have a product page on my website having the rates shown in USD.

For the visitor is accessing the page from Europe it has to show the converted price in Euros.

My application can detect the visitors country if hes accessing the page from Europe so that is not a problem.

I just need to read the xml file and display the converted price based on the rates in the xml file.

How can I read the xml file and output the price in Euros based on the rate.

Thank you.

All comments and feedbacks are always welcome

[LIST=1]
CSV File Reading
Displaying CSV file: Clicking the Show Logfile.txt link at the top of the page should display the CSV records inside logfile.txt
Displaying CSV records formatted : Clicking the Show logfile.txt Formatted should display the CSV records formatted in an HTML table is descending order (more recent records are at the top).
Use this function to convert CSV records back to an array : fgetcsv()
   
I have most of this done and the problem I'm having is trying to read what  I put into the file. (I hard coded what should go into the file). Could you tell me what I'm doing wrong and what I should do to fix it?

Code: [Select]
<?
 
 if ($_POST['_act'] = 'csv'):
$fp = fopen('logfile.txt', 'a');
while (($data = fgetcsv($fp, 1000, ",")) !== FALSE){
print_r($data);
}
fclose($fp);
 endif;
 
if ($_SERVER['REQUEST_METHOD'] == 'POST'):

if (empty($_POST['fullname'])):
$errMsg['fullname'] = "Please fill in Your Full Name.";
endif;
if (ereg("'Mr\. '", $_POST['fullname']) == false):
$errMsg['fullname'] = "Please fill in Your Full Name.";
endif;
print_r($errMsgs); echo count($errMsgs);

if (count($disperrMsgs > 0)):
$dispErrMsgs = true;
else:
$fp = fopen('logfile.txt', 'a');
$fputcsv($fp, array("test", "lol", "roool"));
fclose($fp);


$dispSuccessMsg = true;
endif;


endif;
?>

<html>
<head>

 
<style type="text/css">
h1 {color:red}
div.error {border: 1px solid red; margin: 20px; padding: 20px; width: 400px}
table {border: 1px solid #CCC; margin: 20px; border-collapse: collapse;}
td, th {border: 1px solid #DDD; padding: 2px}
th {background-color:#363; color: white}
td.error {color:red}
div.success  {border: 1px solid green; margin: 20px; padding: 20px; width: 400px; color:green}
</style>
</head>
<body> 
<h1> Form Validation Lab with  Reg Expressions  </h1>
<p><a href="<?= $_SERVER['PHP_SELF'] ?> ">Refresh This Page</a> | <a href="./logfile.txt">Show Logfile.txt</a> | 
<a href="<?= $_SERVER['PHP_SELF'] ?>?_act=csv">Show logfile.txt Formatted</a> 
    <a href="<?= $_SERVER['PHP_SELF'] ?>?_act=clear">Clear logfile.txt </a></p>
   
<? if ($dispErrMsgs): ?>
<div class="error">
<p>There are errors in the code: </p>
    <ol>
    <? foreach($errMsg as $errMsgs ): ?>
        <li><?= $errMsgs ?></li>
            <? endforeach; ?>
            </ol>
    </div>
<? endif; ?>
<? if ($dispSuccessMsg): ?>
<div class="success">
<p>Thank you for your submission. </p>
</div>
<? endif; ?>


<form action="<?= $_SERVER['PHP_SELF'] ?>"  name="getstuff" method="post" >
  <input type="hidden" name="_act" value="post">
  <table cellspacing = "0">
    <tr>
      <th width="78">Full Name:</th>
      <td width="184"><input name="fullname" type="text" class="textbox"
      value="<? $_POST['fullname']; ?>" size="20" ></td>
      <td width="626" >Salution of Mr. or Mrs. followed by two text strings separated by any number of spaces. </td>
      </tr>

    <tr>
      <th>Street:</th>
      <td><input name="street" type="text" class="textbox"
      value="<? $_POST['street']; ?>" size="30"></td>
      <td >2 or 3 digit number followed by a text string ending with Street or Road separated by any number of spaces. </td>
    <tr>
      <th>Phone:</th>
      <td><input name="phone" type="text" class="textbox"
      value="<? $_POST['phone']; ?>" size="20"></td>

      <td >10 digits, first 3 digits have optional parentheses, either side of digits 456 are optional space, dot or hyphen. </td>
    </tr>
    <tr>
      <th>PostalCode:</th>
      <td><input name="postcode" type="text" class="textbox"
      value="<? $_POST['postcode']; ?>" size="8" maxlength="8"></td>
      <td > Postal Code:
        Char Char Digit Hyphen/space Char Digit Digit (No XYZ or 0's. Case insensitive. )</td>
    </tr>

    <tr>
      <th>Email:</th>
      <td><input name="email" type="text" class="textbox"
      value="<? $_POST['email']; ?>" size="25" maxlength="40"></td>
      <td > Must accept as
        a minimum : a@b.com</td>
     </tr>
  </table>
  <input name="reset" type='button' class="button" value='RESET' onClick="location.href = location.href">

  <input name="_submit" type="submit" class="button" value="Submit me now!!!" >
</form>
<p id="notice">Everything below here is for testing purposes Don't remove this from your lab
  as I will use these buttons to fill your form with good and bad data as I mark
  it.</p>
<script>
az=document.getstuff;
function goodstuff(){
az.fullname.value=" Mr. Joe Smith ";
az.street.value="135 Fennell Road ";
az.phone.value="905-575.1212";
az.postcode.value="Ln9-T23";
az.email.value="jsmith@gov.ca";

}
function goodstuff2(){
az.fullname.value=" Mrs. Josephine Smith ";
az.street.value=" 13  Fennell Street";
az.phone.value=" (905)-575.1212 ";
az.postcode.value=" Ln9 T23";
az.email.value=" jsmith@gov.ca  ";

}
function badstuff(){
az.fullname.value="Miss Josephine Smith";
az.street.value="1 Somewhere Avenue";
az.phone.value="905575122";
az.postcode.value="Z8N 3T2";
az.email.value="jsmith$gov#ca";

}
function badstuff2(){
az.fullname.value=" Joe Smith ";
az.street.value="  1392  Fennell Street";
az.phone.value="[905] 575-1212";
az.postcode.value=" Ly9 T20";
az.email.value=" @jsmith$gov#ca";

}
function goodandbad(){
az.fullname.value="Mrs. Joe";
az.street.value=" 135 Fennell Avenue West";
az.phone.value="905:5751212";
az.postcode.value=" L99-T23";
az.email.value=" jsmith@.gov.ca  ";

}

</script>
<form>
  <input type=button class="button" onClick="goodstuff();" value="Fill form with good values " length=100 >
  <input type=button class="button" onClick="goodstuff2();" value="Fill form with good values 2 " >
 
  <input type=button class="button" onClick="badstuff();" value="Fill form with BAD values ">
  <input type=button class="button" onClick="badstuff2();" value="Fill form with BAD values 2 ">
 
  <input type=button class="button" onClick="goodandbad();" value="Fill form with Good and BAD values 2">

  <br>
</form>


</BODY>
</HTML>

how can I make php read a file with ids in the format

23423423
32423423
23423454
56667777

and output each id to $id[]?

I have a script which creates a Thumbnail image if one does not exists, the problem is i keep getting this error: Catchable fatal error: Object of class SimpleImage could not be converted to string in /homepages/22/d378569747/htdocs/scripts/primary_image.php on line 21 i have checked the logs and i think its a read error because the the image is already in use by the server if i remove

(!file_exists("$root/thumnail_user_images/$image"))


the script work fine,  is there anyway to stop this error occuring?


<?php
//header('Content-Type: image/jpeg');
$root = $_SERVER['DOCUMENT_ROOT'];
require("$root/include/mysqldb.php");                     //mysql login details
require("$root/include/mysql_connect.php");               //mysql connect


$uin = $_GET['uin'];


$result = mysql_query("SELECT * FROM Reg_Profile_images WHERE UIN='$uin' AND `primary` = '1' LIMIT 1");
while($row = mysql_fetch_array( $result )) {

$image = $row[2];


if (!file_exists("$root/thumnail_user_images/$image"))
 {
   require("$root/include/image_resizing_function.php");     //create image
   $image = new SimpleImage();
   $image->load("$root/raw_user_images/$image");
   $image->resizeToWidth(250);
   $image->save("$root/thumnail_user_images/$image");
   $image->output();


}

else {


 readfile("$root/thumnail_user_images/$image");




}
}
//End Image file





?>

im looking for a cool code to read file content of a file in a remote server

i have a file called
online.php that have this commands
<?php
echo (exec('netstat -a -n |find "5816"  |find "ESTABLISHED" /c')-2);
?>

i wanna have another file in my own host to read the content of this file from the remote server
anyone have an idea ?

Hi,

I have a Excel File Reader script that works perfectly on my private development hosting, the Excel file is read and then the contents are displayed to the page with the help of a for loop.  The trouble is when I try it out on my work's hosting space the script does nothing, no error messages or anything.  I have not changed anything and all paths ect are correct.
What else could be causing this?

Many Thanks,

I need some assistance in trying to resolve some issue I have with some code. Currently when I click on an upload button, this should read my csv file and the put the data into phpmyadmin but after looking around various forums and websites I still can not seem to get this to work any assistance would be appreciated.

<?php
$db	=	new mysqli('localhost','root','','');
if ($db->connect_errno) {
  echo "Failed to connect to MySQL: " . $db->connect_error;
  exit();
}
?>
<t<html>
<head>
  <title>Local Care Direct </title>
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" crossorigin="anonymous">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" crossorigin="anonymous">
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" crossorigin="anonymous"></script>
</head>
<body>
<form method="POST" enctype="multipart/form-data" action="<?php echo $_SERVER["PHP_SELF"]; ?>">
                         <div align="center">
                                  <p>Select CSV file: <input type="file" name="file"  /></p>
                                  <p><input type="submit" name="csv_upload_btn" value="Upload"  /></p>
                         </div>
                </form>
<table align="center"  width="800" border="1" style="border-collapse:collapse; border:1px solid #ddd;" cellpadding="5" cellspacing="0">
	<thead>
		<tr bgcolor="#FFCC00">
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
			<th>test</th>
		</tr>
	</thead>
	<tbody>
	<?php
	
	// Create database
$sql = "CREATE DATABASE IF NOT EXISTS csv";
if (mysqli_query($db, $sql)) 
{
  echo "Database created successfully";//confirmation message
} else
	{
		
  echo "Error creating database: " . mysqli_error($db);//error message and reason mysql  or php
  mysqli_close($db);
	}

//define the database to use
$sql = "Use `csv`";
if (mysqli_query($db, $sql)) 
{
  echo " Use csv successfully";//confirmation message
} else
	{
		
  echo " Error use csv: " . mysqli_error($db);//error message and reason mysql  or php
  mysqli_close($db);
	}

//create the table in the database
$sql = "CREATE TABLE IF NOT EXISTS`csvfile` (
  `Test` varchar(10) DEFAULT NULL,
  `Test` varchar(5) DEFAULT NULL,
  `Test` varchar(10) DEFAULT NULL,
  `Test` varchar(5) DEFAULT NULL,
  `Test` varchar(77) DEFAULT NULL,
  `Test` varchar(4013) DEFAULT NULL,
  `Test` varchar(16) DEFAULT NULL,
  `Test` varchar(16) DEFAULT NULL,
  `Test` varchar(5) DEFAULT NULL,
  `Test` varchar(10) DEFAULT NULL,
  `Test` varchar(10) DEFAULT NULL,
  `Test` varchar(5) DEFAULT NULL,
  `Test` varchar(10) DEFAULT NULL,
  `Test` varchar(16) DEFAULT NULL,
  `Test` varchar(22) DEFAULT NULL,
  `Test` varchar(16) DEFAULT NULL,
  `Test` varchar(22) DEFAULT NULL,
  `Test` varchar(10) DEFAULT NULL,
  `Test` varchar(10) DEFAULT NULL,
  `Test` varchar(10) DEFAULT NULL,
  `Test` varchar(10) DEFAULT NULL,
  `Test`varchar(10) DEFAULT NULL,
  `Test` varchar(10) DEFAULT NULL,
  `Test` varchar(10) DEFAULT NULL,
  `Test` varchar(10) DEFAULT NULL,
  `Test` int(8) DEFAULT NULL,
  `Test` varchar(5) DEFAULT NULL,
  `Test` varchar(5) DEFAULT NULL,
  `Test` varchar(5) DEFAULT NULL,
  `Test` varchar(5) DEFAULT NULL,
  `Test` varchar(5) DEFAULT NULL,
  `Test` varchar(5) DEFAULT NULL,
  `Test` varchar(5) DEFAULT NULL,
  `Test` varchar(5) DEFAULT NULL,
  `Test` varchar(5) DEFAULT NULL,
  `Test` varchar(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
";
if (mysqli_query($db, $sql)) 
{
  echo " table created successfully";//confirmation message
} else
	{
		
  echo  " Error creating table: " . mysqli_error($db);//error message and reason mysql  or php
  mysqli_close($db);
	}
	
//in case of data already in the csvtable, delete the data
$sql = "DELETE FROM `csvfile`";	
if (mysqli_query($db, $sql)) 
{
  echo " deleted data from the table successfully "; //confirmation message
} else
	{
		
  echo  " Error deleting data from the table: " . mysqli_error($db); //error message and reason mysql  or php
  mysqli_close($db);
	}
	

//do not delete	
//Process form
 if(isset($_POST["csv_upload_btn"]))	 
	 $file = fopen("csv3.csv","r")or die("Failed to read file");
print_r(fgetcsv($file))== NULL;
for ($i = 0; $row = fgetcsv($file); ++$i) {

}

fclose($file);
 
	 
	
	 
		/* $db->query('INSERT INTO `csvfile`(`Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`, `Test`) VALUES ("'.$row[1].'","'.$row[2].'","'.$row[3].'","'.$row[4].'","'.$row[5].'","'.$row[6].'","'.$row[7].'","'.$row[8].'","'.$row[9].'","'.$row[10].'","'.$row[11].'","'.$row[12].'","'.$row[13].'","'.$row[14].'","'.$row[15].'","'.$row[16].'")');
		if($n>1){ */
				?>
					<tr>
					<td><?php echo $row[0];?></td>
					<td><?php echo $row[1];?></td>
					<td><?php echo $row[2];?></td>
					<td><?php echo $row[3];?></td>
					<td><?php echo $row[4];?></td>
					<td><?php echo $row[5];?></td>
					<td><?php echo $row[6];?></td>
					<td><?php echo $row[7];?></td>
					<td><?php echo $row[8];?></td>
					<td><?php echo $row[9];?></td>
					<td><?php echo $row[10];?></td>
					<td><?php echo $row[11];?></td>
					<td><?php echo $row[12];?></td>
					<td><?php echo $row[13];?></td>
					<td><?php echo $row[14];?></td>
					<td><?php echo $row[15];?></td>
					<td><?php echo $row[16];?></td>
					<td><?php echo $row[17];?></td>
					<td><?php echo $row[18];?></td>
					<td><?php echo $row[19];?></td>
					<td><?php echo $row[20];?></td>
					<td><?php echo $row[21];?></td>
					<td><?php echo $row[22];?></td>
					<td><?php echo $row[23];?></td>
					<td><?php echo $row[24];?></td>
					<td><?php echo $row[24];?></td>
					<td><?php echo $row[26];?></td>
					<td><?php echo $row[27];?></td>
					<td><?php echo $row[28];?></td>
					<td><?php echo $row[29];?></td>
					<td><?php echo $row[30];?></td>
					<td><?php echo $row[31];?></td>
					<td><?php echo $row[32];?></td>
					<td><?php echo $row[33];?></td>
					<td><?php echo $row[34];?></td>
					<td><?php echo $row[35];?></td>
				</tr>
				<?php
			//}
			//++;
		//}
		//fclose($handle); 
	?> 
	</tbody>
</table>
</body>
</html> 

Before I upload the file I get the following errors

Notice: Undefined variable: file in C:\xampp\htdocs\index.php on line 157

Warning: fgetcsv() expects parameter 1 to be resource, null given in C:\xampp\htdocs\index.php on line 157

Notice: Undefined variable: file in C:\xampp\htdocs\index.php on line 158

Warning: fgetcsv() expects parameter 1 to be resource, null given in C:\xampp\htdocs\index.php on line 158

Notice: Undefined variable: file in C:\xampp\htdocs\index.php on line 162

Warning: fclose() expects parameter 1 to be resource, null given in C:\xampp\htdocs\index.php on line 162

The uploaded file contains dates, time, blank fields, true and false and text.  I will need to prevent sql injection and html entities like ampersand sign.

After uploading the file, it only reads the first line of my csv file which contains the title of each column and nothing is put into phpmyadmin 

Hello,

I'm trying to read the first line of some large files by PHP, which means, the ideal solution does not work:

Quote

   $content = file($file_import);
   
   $fields = explode(",", $content[0]);


Quote

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 110 bytes) in C:\wamp\www\exchange\admin\import.php on line 55



Is there any other way to read only the first line without opening the whole file?

Thanks!!

eg

http://www.xxxxxxx.com/index.php?action=viewarti&artid=5

How can I write the content of this link into file.

Got a little stuck here.

I'm trying to format an existing .txt file, format it and then write it to .sql file.

Here's my code:

Code: [Select]
$handle = @fopen("nations.txt", "r");
if ($handle) {
    while (($buffer = fgets($handle, 1024)) !== false) {

                      $column = explode("|",$buffer); // format file
                        $myFile = "nation_dump_".date("Y-m-d").".sql"; // create file
$fh = fopen($myFile, 'w') or die("can't open file");

foreach($column as $col)
{
fwrite($fh, $col[0]); //write the first broken segment from explode() to file
}
fclose($fh);
    }
    if (!feof($handle)) {
        echo "Error: unexpected fgets() fail\n";
    }
    fclose($handle);
}

The error is on this line, within the foreach loop.
fwrite($fh, $col[0]);

When I removed the index it only wrote the last line to the file, but I want it to loop through all the lines..

What am I doing wrong here?