PHP - Inserting Binary String To Mysql Binary Column

 :confused:can any one please guide me through this.

i want  to calculate binary income like

FOR 1 ST PAIR 1:2 OR 2:1
1ST PAIR 1:2 OR 2:1
1:1 UNLIMITED DEPTH
WEEKLY CAPPING 30 PAIR

i have created a binary tree and i am also able to display it.
but don't know how to make pairs and implement that,and provide an income.

i really need this and it is urgent,
any help will be of great value for me,
this is for my college project,
actually i am a not so good at algorithms.

thanks.

[attachment deleted by admin]

I am trying to count left node of a binary tree.I made a function but my result is always 3 .

Code:-

Code: [Select]
<?php
  include'config.php';  // Connect database

  function leftcount($node)   //Function to calculate leftcount
  {
    $sql = "SELECT lchild,rchild FROM tree WHERE parent = '$node'";
    $execsql = mysql_query($sql);
    $array = mysql_fetch_array($execsql);
    
    if(!empty($array['lchild']))
    {
      $count++;
      leftcount($array['lchild']);  
    } 
    if(!empty($array['rchild']))
    {
       $count++;
       leftcount($array['rchild']); 
    }
    
    $totalcount = 1 + $count;
    return $totalcount;
    
  }
  
  $parent = "2";
  $left = leftcount($parent);
  echo $left;
  
?>
Can someone please point the error in my logic ? I searched google but i only got scripts with classes and i don't want to use classes.

ive been doing some research on this, and i cant seem to find an answer that makes sense.

im reading the manual on mysql_real_escape() and I know how to use the function, but in the description:

Escapes special characters in the unescaped_string, taking into account the current character set of the connection so that it is safe to place it in a mysql_query(). If binary data is to be inserted, this function must be used.

What is an example of inserting "binary data" as described above??

As far as I understand that would be any numerical values and a string would not apply.. But does not seem to add up. A binary file cannot be inserted, so Im a bit lost.

Any thoughts welcome.

I am running Apache with the PHP module installed on Debian Linux.  My goal is to launch a binary in a background process and then feed it commands via fifo.

The binary I need to launch has a config file which lives in the home directory of the apache user (in my case the user name apache is started with is www-data). www-data's home dir was the web root so I changed it to /home/www-data.  I also change the shell from /bin/sh to /bin/bash for www-data.

Neither of these changes are present when I load a php file from a browser.

This script:

Code: [Select]
<?php
echo "User: " . exec('whoami') . "<br>";
echo "Shell: " . exec('ps -p $$ | grep sh') . "<br>";
?>
Outputs this:

Code: [Select]
User: www-data
Shell: 9179 ? 00:00:00 sh
Also if I execute the binary it does seem to read the config file which is in the www-data users directory.  I have set the home dir and the web root to be owned by www-data and it's read and writeable.

How do I get php to execute the binary so it has access to the users home directory and uses the bash shell?
Are there any other ways to launch and control a binary on a unix system via php?

I am trying to display binary tree  level wise. Breadth-first tree traversal can be used in it.Can anyone point me towards its logic or point me towards a good tutorial.

Hey guys,
i am a college student and working on a project of mlm ad want to display the binary income tree,and also calculate the income that is given to each node.
Please see the attachments for the binary tree structure and database table structure.
Thanks.

[attachment deleted by admin]

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.

This is my first try to display binary tree so please go easy on me.
I am trying to display binary tree using array. The values are stored in mysql.

Structure of mysql-
Code: [Select]
CREATE TABLE IF NOT EXISTS `tree` (
  `parent` int(7) NOT NULL,
  `rchild` int(7) NOT NULL,
  `lchild` int(7) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Display should look like
Code: [Select]
                    1
              ______|______
             |             |
             2             3
                     ______|______
                    |             |
                    4              5   


My Code till now-
Code: [Select]
<?php
 include 'connection.php';
 $rsearch = "SELECT rchild FROM tree WHERE parent='".$parent."'";
 $lsearch = "SELECT lchild FROM tree WHERE parent='".$parent."'";
    
  $rexec = mysql_query($rsearch);
  $lexec = mysql_query($lsearch);
  
  while($rrow = mysql_fetch_assoc($rexec)) // Putting right branch in an array first
{
    $rtree[$i][0] = $rrow['parent'] ; 
    $rtree[$i][1] = $rrow['lchild'] ;
    $rtree[$i][2] = $rrow['rchild'] ;
    $i++;
}
while($lrow = mysql_fetch_assoc($lexec)) // Putting left branch in an array 
{
    $ltree[$j][0] = $lrow['parent'] ; 
    $ltree[$j][1] = $lrow['lchild'] ;
    $ltree[$j][2] = $lrow['rchild'] ;
    $j++;
}

function displaytree($parent,$array)
{
   // Im stuck here. Can someone please help me with it
}
?>
I am stuck at displaying the tree function. Can someone please point me in the right direction ?

Is this the correct way to write binary data to a file?

$string = 'this is a string';
$handle = fopen('b.dat', 'wb');
for($i=0;$i<strlen($string);$i++){
    $hx = bin2hex($string{$i});
    fwrite($handle, pack("H*", $hx));
} 

If so, how do I read it an convert it back to a string?
If it is not correct, how do I do it?

I have a column in my db called 'Sold' which is set to Binary. I need a dropdown in my form, that converst the binary into 'True', 'False' for the options, and also selects the one that is set in the db.

This is for an edit form, so will then need to adapt it for a add form.

This is my code, which doesnt seem to be working

        <?php
		$id = $_GET["id"];
        $sqlSold = "SELECT Sold FROM Products WHERE idProducts = $id;";
        $products = [
    		'True' => true, 
    		'False' => false
		];
		?>
     <select name="Sold">
        <option selected="selected">Choose one</option>
        <?php       
        foreach($products as $item){
            echo "<option value='strtolower($item)'>$item</option>";
        }
        ?>
    </select>

 

Hi there. 

I was wondering if it were possible to convert text to numbers or some sort of URL friendly link. For example, "Hello there" would be converted to '435342553' or whatever.

I want to do this because for example when someone goes to this URL, example.com/435343434, the number/uri string would be decoded and whatever the text was it would be displayed on the site.  I can write all this code no bother I just need some advice/ideas on the the encoding/decoding of the text.

I was looking at some options for doing this.....

hexdec - removes spaces
md5 - cannot be decoded?

None of them seem to be working, the problem is decoding them.    md5 creates a perfect uri string but as I said it cannot be decoded.

I would appreciate any ideas of suggestions.

Thanks a million.

I made a function to check if the child belongs to a parent ($node) or not. However its not working completely.If i include immediate children of the parent ($node) then the answer is yes otherwise it gives nothing (indicating it isnt the child) which is wrong. I think its because of recursive functions.Can someone please point out my mistake.

Code: [Select]
<?php
function ischild($node,$child)   //$node is parent to see if $child is its child or not.
  {
    $sql = "SELECT lchild,rchild FROM tree WHERE parent = '$node'";
    $execsql = mysql_query($sql);
    $array = mysql_fetch_array($execsql);
    
    if(($array['lchild']) == $child)
    {
   
      return "yes";
    }
    elseif (!empty($array['lchild']))
    {
        ischild($array['lchild'],$child);
    } 
    if($array['rchild'] == $child)
    {
        return "Yes";
    }
    elseif(!empty($array['rchild']))
    {
        ischild($array['rchild'],$child);
     }
   
  }  

I was looking at the manual:   http://php.net/manua...ction.fopen.php   And I noticed the the binary mode 'b' is missing from the list. Any reason why?

Hi,

I have managed to get the code working to store a .jpg file in the database under the longblob type.

Now all i have left to do is to retrieve that image and display it.

So far i have this:

list.php
Code: [Select]
while($r = mysql_fetch_array($sql)) { //for each record
...
echo "     <img src=  getoutside.php?id='".$r[apartmentId].  " '>     ";

getoutside.php
Code: [Select]
<?php
header("Content-type: image/jpg"); // act as a jpg file to browser
    $nId = $_GET['id'];
include 'dbase.php'; //connect to database
    $sqlo = "SELECT outside FROM apartment WHERE apartmentId = $nId";

$oResult = mysql_query($sqlo);

$oRow = mysql_fetch_array($oResult);
$sJpg = $oRow["outside"];
echo $sJpg;
?>
The result from this is a box with a red cross in it.
Can anyone find a problem with this code please?

Thanks

Hi all,

Is it possible in php to read data from file as binary and operate on it with bitwise operators and save result as binary.

Thanks