PHP - Write Binary Data To A File

Hi, guys.  I'm trying to wrap my head around trying to read a header in a binary file in php.  So, far, I have been able to get the data into a string using file_get_contents.  Now, I think I need to use unpack, but it's a bit confusing to me still.  For example, my file starts by having a 1 byte version number, 4 bytes to represent a number of walls, then "number of walls" * 40 bytes for the actual walls.  But, the problem is, the wall itself is a structure composed of various elements to make up that 40 bytes, from which I'll need to pick out a specific area of interest.  I can do this easily in C, but in php. I can't think how to grab the info.  Any ideas?  Maybe just how to read 1 byte, 4 bytes, then "number of walls" * 40 bytes will get me in the right direction.

I'm planning on storing RIPEMD-160 passphrase hash's raw binary data in MySQL as BINARY(20).  Right now, I'm not sure if one of the following INSERT approach is more preferrable and more efficient:

Approach (1) - Using mysqli::real_escape_string()
=================================================

Code: [Select]
$binhash = $mysqli->real_escape_string(hash('ripemd160', $passphrase, true));
$mysqli->query("INSERT INTO testtbl (Passphrase) VALUES ('" . $binhash . "')");
This approach saves hash() from converting raw binary data to hexadecimal format, but need to process and escape the binary string.

Approach (2) - Using UNHEX() on MySQL
=====================================

Code: [Select]
$hexhash = hash('ripemd160', $passphrase);
$mysqli->query("INSERT INTO testtbl (Passphrase) values (UNHEX('" . $hexhash . "'))");
This approach needs hash() to convert binary data to hexadecimal but no need for escaping the string and it put extra load on MySQL to convert the hexadecimal back to binary.

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 guys,

I have a trouble of updating the data in the database by input the data at the end of the url. It have not been added in the table.


Here it is updated:


<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'myusername');
    define('DB_PASSWORD', 'mypassword');
    define('DB_DATABASE', 'mydatabasename');

    $errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {
  die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }

    $login = clean($_GET['user']);
    $password = clean($_GET['pass']);
    $firstname = clean($_GET['firstname']);
    if($login == '') {
  $errmsg_arr[] = 'Login ID missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD ID missing';
  $errflag = true;
    }
    if($value == '') {
  $errmsg_arr[] = 'THE first name IS missing';
  $errflag = true;
    }
    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
  $qry="SELECT * FROM members WHERE login='$login' AND passwd='$password'";

  $result=mysql_query($qry) or die('Error:<br />' . $qry . '<br />' . mysql_error());

if(mysql_num_rows($result) > 0) {

  $row = mysql_fetch_row($result);
    echo $row[0];
    }
else {

echo 'Username, Password or first name is not found.';
close;

$sql="INSERT INTO members (firstname, lastname)
VALUES
('$_POST[firstname]','$_POST[lastname]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "first name have been updated";
}
?>


It have only login in the database but did not doing any update when I have input the data at the end of the url to get the database update.

Do you know why I can't update the data in the database by input the data in the url like this?

http://www.mysite.com/updatemysql.php?user=test&pass=test&firstname=shitorwhateveriwanttoinputandgetitupdate

Do you have any idea and maybe if I have miss something?

Hi everyone,

Here's the part of the script I think is wrong :

<?php
include "util/log.php";
include "util/connect.php";

if (loggedin() == $NO)
{   
   header("Location: login.php");
   exit();
}

else if (isset($_GET["p"]))
{
   $udata = explode("-", $_COOKIE["log"]);
   $query = "SELECT * FROM l_users WHERE user='$udata[0]'";
   $usrsql = mysql_query($query) or handledberror(mysql_error());
   $usrdata = mysql_fetch_array($usrsql);
   switch ($_GET["p"])
   {
      case "delete":
         include "util/linkfunc.php";
         if (isset($_GET['id'])) delete_link($_GET['id']);
         else delete_all();
         $CONTENT = "pages/urls.php";
      break;
      case "approve":
         include "util/approve.php";
         $CONTENT = "pages/approve.php";
      break;
      case "urlview":
      case "add":
      case "edit":
         include "pages/modify.php";
         $CONTENT = "pages/edit.php";
      break;
      case "reset":
         include "util/linkfunc.php";
         if (isset($_GET['id'])) reset_link($_GET['id']);
         else reset_all();
         $CONTENT = "pages/urls.php";
      break;
      case "urls":
      default:
      $CONTENT = "pages/urls.php";
   }
}
else
{
   $udata = explode("-", $_COOKIE["log"]);
   $query = "SELECT * FROM l_users WHERE user='$udata[0]'";
   $usrsql = mysql_query($query) or handledberror(mysql_error());
   $usrdata = mysql_fetch_array($usrsql);
   $CONTENT = "pages/urls.php";
}

?>
<html>
<head><title>EzyLinkExpire :: Member's Area</title><head>
<body bgcolor="#1D2B60" link=#CCFFFF vlink=#CCFFFF>

<table align="center"  cellspacing="0" width=90% bgcolor="white" bordercolordark="black" bordercolorlight="black">
    <tr>
      <td bgcolor="#1D2B60"> <img src="images/logo.gif"  border="0"></td>
      <td valign=top bgcolor="#1D2B60" align=right><font color="white" size="1" face="Verdana">Welcome <? print $usrdata["fname"] . " ". $usrdata["lname"]; ?>!<br>User Since: <? print date("F d Y",$usrdata["since"]); ?><br>Server Time:<? print date("r"); ?><br><a href="login.php?a=logout" color=#CCFFFF>Click Here To Logout</a><br><a href="members.php" color=#CCFFFF>Click Here To Goto the Main Page</a></font></td>
   </tr>
   <tr><td colspan=2 height=14 bgcolor="#1D2B60"></td></tr>
   <tr>
        <td width="100%" height="100%" colspan=2 bgcolor="white" bordercolordark="black" align="center" bordercolorlight="black" border=1 valign="top">
           <br><? include $CONTENT; ?><br><br>
        </td>
    </tr>
</table>
</body>

<style type="text/css">
table.t  {border: thin solid #000000; background-color: #FFFFFF}
td.th {border: thin solid #000000; background-color:#FFFFFF; font-style: bold 12px; text-align:center; font-size: 12px; font-weight:bold}
td.t  {border: thin solid #000000; background-color:#FFFFFF; font-style: bold 12px; text-align:center; font-size: 12px; font-weight:bold}
td.te  {border: thin solid #000000; background-color:#FFFFFF;  text-align:center; }
td.ac1 {border: thin solid #000000; background-color:#FFFFFF;  text-align:left; }
td.ac2 {border: thin solid #000000; background-color:#FFFFFF;  text-align:left; }
a.t {color: #3366FF}
a.msg {color: #3366FF}
font.msg {font-style: bold 12px;  font-size: 12px; font-weight:bold}
</style>
<script language='javascript'>
function deleteconfirm()
{
   if (confirm("Are you sure you want to delete all links?"))
      document.location = "members.php?p=delete";
}
function resetconfirm()
{
   if (confirm("Are you sure you want to reset the hit count for all links?"))
      document.location = "members.php?p=reset";
}

</script>
</html>

Thank you,
Sylvain

<?php
$a = 2;
$b = 3;
$z = fopen("test.txt", 'a+');
if($a > $b)
  {
  echo "A is bigger than B";
  }
  elseif fwrite($z, $b);
fclose($z);
?>


is there a way to get elseif to write to a file?

so if b is bigger than a it writes $b to a file?

Why doesn't it add a new line when I open up index.php

Code: [Select]
$fp = fopen('text.txt','w');
fwrite($fp, "Your IP: ".$_SERVER['REMOTE_ADDR']."\n");
fclose($fp);

I produce a series of php variables in a php strict (mostly come from mysql), and I want to save them as a php file. To be use for "include". What is the safest way to write them in a php file?

I tried to save them in the manner of saving a text file with fwrite as

Code: [Select]
$data='<?php $cat=array('array created in the text'); $string='some value';?>';
$fh = fopen("file.php", 'w');
fwrite($fh, $data);
Now, file.php is a normal php file and I can call it with "include"; but the problem is that this method is not safe. For example, if the string is "There's something", php gives error for the presence of ' in the string. I can skip ' and " by backslash; but this method is costy, as I need to perform this process for all strings to be saved. Moreover, there might be other source of errors too (that I have not encountered yet).

Is there a safe way for writing a php code to 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?

eg

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

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

Hello Everyone,

I'm new to PHP and got a good big stuff.

I would like to write an image in excel file. There will be almost 600+ rows and each row will have url and qrcode image. I would like to write an excel file which will write url and respective image into the next cell of the url.

Is it possible to write an image in excel file? If yes, can anyone please guide me how? I have read so many post saying to use a pear package but again pear package is not allowing to write jpe/gif it only allows .bmp files. So, pear package is I don't think will work for me. I have also attached an example excel file which is showing the way I require to have an output.

Please anyone if having any idea guide me and let me know.

Thank you in advance for your help.

Looking forward to hear from you soon!

I am trying to write post variables to a csv file but it writes everything in one line separated by comma

<?php

$list= array($_POST['purchases']);
$file = fopen("purchases.csv", "w");

foreach ($list as $line)
{
fputcsv($file, $line); 
}

fclose($file); 
?>

Result in purchases.csv file

Marilyn,Nancy,Johan,Carol,Juanic,Shirley

But I want every string value on separated line

Marilyn
Nancy
Johan
Carol
Juanic
Shirley

 

I very new to php and all I am simply trying to do is read the contents of a text file and echo it out on the screen.
I have tried many things to see what I am doing wrong but it just simply isnt working for me. I know the server I am using has php enabled as well because I have tried a simple echo and it works fine.

This is the code I am currently using.

<?php
   $file = fopen(file.txt", 'r');
   $read = fread($file, '6')
   echo $read;
?>

also, I have tried this.

<?php
   $file = file_get_contents('file.txt');
   echo $file;
?>

I have a file.txt on the server I am using in the same directory as index.php, I feel like this should be working but I get no result!
Alls I have in the text file is a statement that says "hello world".

I'm trying to include a routine to catch an error but it doesn't seem to write to a text file within a function. just using the following simple code, even if I simply try to write a letter it doesn't work

 

if ($http_status == 200) {
        return $response;

    } else {


$myfile = fopen("ErrorData.txt", "a+") or die("Unable to open file!");

$txt =  date("H:i:sa d-m-Y")." / Error data- / ".json_encode($response)."\r\n";
fwrite($myfile, $txt);
fclose($myfile);


}

 

 

Edited September 13, 2019 by Dvae56
Added code

Hey there,

Thanks for taking the time to read my thread, well basically I'm in a bit of a dilemma. I've got a string in PHP containing the contents of a file I would like to be created and I have a method of sending the command to the remote server like so:


$Connection->exec('ps aux'); 


Now my issue is I am unaware of any file editors via command like that don't have some sort of user prompt I've scoured Google for hours searching for the best possible method for this but all the file editors aren't simply processed by one line commands and edited in that same command e.g

Create File -> Write File -> Close File

Is there no possible means of doing that via one line command?.

Here is my string I wish to be written to the file.



$RestartFile = "#!/bin/bash
export SERVER_PATH=/home/client".$Server['server_owner']."/".$Server['server_id']."
cd $SERVER_PATH
while [ true ]; do
./server".$Server['server_id']." &
done");


Thank you for your time.