PHP - Merging Two Queries

When i upload photos and the name of the photo i would like to be able to overlay a portion of the original photo with another image already in the site directory, and also add the photos name over the top of the overlayed image,  i may have explained this in a confusing way so i have attached an example.

Is this something that can be done using something like GD or imagick, if so could someone please give me a good place to start.

Hello guys,

I don't really know php but I am always been able to copy/paste it and move stuff around on my wordpress website until now.

This last challenge is beyond my skills though (I am sure it will be trivial for you).

So I have this code snippet to show a video duration

    <?php
  global $post;
  $video = cbc_get_video_data( $post );
  if( $video ) {
    echo $video->get_human_duration();
  }
?>

And I have this code to show a post title

if ($show_title) {
        $title_content .= apply_filters( 'uncode_before_body_title', '' );
        $title_content .= '<div class="post-title-wrapper"><h1 class="post-title">' . get_the_title() . '</h1>';
        $title_content .= uncode_post_info() . '</div>';
        $title_content .= apply_filters( 'uncode_after_body_title', '' );
    }

I want to show the video duration right before the post title and in line with it, so inside the h1 tag. How to do that?

Thanks for any help!

 

 

Hello.
I'm currently trying to write a code to merge two separate images together, but for the life of me I can't find anything that works.

Basically what I'm trying to do is add a "marking" (cat_stripes.png) to a pet image (cat.png). In the future I also want to use this for adding items to pets and things like that.
Both of the images have transparent backgrounds, so that needs to be taken into account. If you haven't got a clue what I'm talking about, look up Wajas or similar virtual pet sites to get an idea of how the markings work.

I just need something simple, since I don't have a site set up yet and I'm just testing some things out for a future project. I don't have any codes at the moment, since nothing has worked so far.
I'm pretty new to GD too (I'm familiar with all the basic php stuff, so don't panic), so you might need to explain some of the more advanced stuff to me.

Any help with this would be really appreciated, thanks. (:

I currently have a flat file user registration and login in system. I also have a simple guestbook which i didn't code myself, the guest book currently requires the user to type in there name and e-mail address to make a post. how ever i would like them to have to login and if they aren't logged in then don't display the guestbook.

Live version:
B50crew.co.uk

Guestbook.php:
Code: [Select]
<?php
  // find out the domain:
  $domain = $_SERVER['HTTP_HOST'];
  // find out the path to the current file:
  $path = $_SERVER['SCRIPT_NAME'];
$url = "http://" . $domain . $path  ;
extract($_POST);
if($Submit){
$date = date('D d Y h:i');

$comment=eregi_replace("\r\n","*",$comment);
$comment=eregi_replace("\n","*",$comment);
$fp = fopen("bin/guestbook.nfo","a+");

if(!$fp) {
    echo 'Error: Cannot open file.';
    exit;
}

fwrite($fp, $date."||".$name."||".$email."||".$comment."\n");

fclose($fp);

 }
?>



<div align="center">
  <h2><span class="style1">Guestbook </span><br>
  </h2>
</div>
<form name="form1" method="post" action="<?php echo $url;?>">
  <label>Name
  <input type="text" name="name">
  </label>




  <label>Email
  <input type="text" name="email">
  </label>
  <p>&nbsp;</p>
  <p>
    comment<br>
    <textarea name="comment" cols="40" rows="10"></textarea>

    <br>
    <label>
    <input type="submit" name="Submit" value="Sign">
    </label>
    <br>
    </p>
</form>
<hr>

<?php

$userinfo = file("cgi-bin/guestbook.nfo");

   echo '<table border="0">';

foreach($userinfo as $val)

{
   //explode that data into a new array:
   $data = explode("||", $val);


  echo '<tr><td>'.$data[0].'</td></tr>';
   echo '<tr><td>'.$data[1].' Wrote:</td></tr>';

    $data[3]=eregi_replace("\*","<br>",$data[3]);

   echo '<tr><td>'.$data[3].'</td></tr>';
   echo '<tr><td>Email:'.$data[2].'<hr></td></tr>';
}


   echo '</table>';



 ?>
Login:
Code: [Select]
<?php
  // find out the domain:
  $domain = $_SERVER['HTTP_HOST'];
  // find out the path to the current file:
  $path = $_SERVER['SCRIPT_NAME'];
$url = "http://" . $domain . $path  ;
extract($_POST);
if($Submit){
$date = date('D d Y h:i');

$comment=eregi_replace("\r\n","*",$comment);
$comment=eregi_replace("\n","*",$comment);
$fp = fopen("bin/guestbook.nfo","a+");

if(!$fp) {
    echo 'Error: Cannot open file.';
    exit;
}

fwrite($fp, $date."||".$name."||".$email."||".$comment."\n");

fclose($fp);

 }
?>



<div align="center">
  <h2><span class="style1">Guestbook </span><br>
  </h2>
</div>
<form name="form1" method="post" action="<?php echo $url;?>">
  <label>Name
  <input type="text" name="name">
  </label>




  <label>Email
  <input type="text" name="email">
  </label>
  <p>&nbsp;</p>
  <p>
    comment<br>
    <textarea name="comment" cols="40" rows="10"></textarea>

    <br>
    <label>
    <input type="submit" name="Submit" value="Sign">
    </label>
    <br>
    </p>
</form>
<hr>

<?php

$userinfo = file("cgi-bin/guestbook.nfo");

   echo '<table border="0">';

foreach($userinfo as $val)

{
   //explode that data into a new array:
   $data = explode("||", $val);


  echo '<tr><td>'.$data[0].'</td></tr>';
   echo '<tr><td>'.$data[1].' Wrote:</td></tr>';

    $data[3]=eregi_replace("\*","<br>",$data[3]);

   echo '<tr><td>'.$data[3].'</td></tr>';
   echo '<tr><td>Email:'.$data[2].'<hr></td></tr>';
}


   echo '</table>';



 ?>
Session.php

<?php
class user {
    var $file_dir = "";
     
    function start($time = 3600) {
        session_set_cookie_params($time , '');
        session_name('afroxav-login');
        session_start();

         // Reset the expiration time upon page load
        if (isset($_COOKIE['afroxav-login'])) {
            setcookie('afroxav-login', $_COOKIE['afroxav-login'], time() + $time, '', 'localhost', 0, 1);
        }

        if (!isset($_SESSION['info'])) {
            $this->data = array('name' => 'Anonymous', 'logged' => false);
        } else {
            $this->data = $_SESSION['info'];
        }
    }

    function check_login() {
        if ($this->data['logged'] !== true) {
            return false;
        } else if ($this->data['logged'] === true) {
            if ($this->data['name'] !== 'Anonymous') {
                return true;
            }
            return false;
        }
        return false;
    }

    function login($user, $pass) {
        $logins_raw = @file_get_contents($this->file_dir . 'users.php');
        $logins_processed = str_replace('<?php exit; ?>', '', $logins_raw);
        $logins_array = explode('\n', $logins_processed);
        foreach ($logins_array as $id => $line) {
            $logins[$id] = explode('|', $line);
        }
        $pass = $this->hash_pass($pass);

        foreach ($logins as $user_info) {
            if ($user_info[1] == $user) {
                if ($user_info[2] == $pass) {
                    $this->update_session($user_info);
                    return true;
                }
            }
        }

        return false;
    }

    function hash_pass($string) {
        return hash('sha512', $string);
    }

    function logout() {
        $_SESSION['info'] = array('name' => 'Anonymous', 'logged' => false);
        $this->data = $_SESSION['info'];
        return true;
    }

    function prep_reg_array($name, $pass, $email, $mod = 'false', $admin = 'false') {
        $id_raw = @file_get_contents($this->file_dir . 'id.php');
        $id = str_replace('<?php exit; ?>', '', $id_raw);
        $id = $id + 1;
        @file_put_contents($this->file_dir . 'id.php', '<?php exit; ?>' . $id);
        return array($id, $name, $this->hash_pass($pass), $email, $mod, $admin);
    }

    function register($userdata) {
        $write = file_put_contents($this->file_dir . 'users.php', '\n' . implode('|', $userdata), FILE_APPEND);
        return ($write !== false) ? true : false;
    }

    function update_session($array) {
        $_SESSION['info'] = array(
            'id'        => $array[0],
            'name'        => $array[1],
            'pass'        => $array[2],
            'email'        => $array[3],
            'mod'        => $array[4],
            'admin'        => $array[5],
            'logged'    => true
        );
        $this->data = $_SESSION['info'];
    }
};

//html related functions
//not related at all with the sessions
function html_start($title) {
    header('Content-type: text/html');

    echo "<html>\n";
    echo "<head>\n";
    echo "<title>\n";
    echo $title;
    echo "</title>\n";
    echo "</head>\n";
    echo "<body>\n";
    echo "<h1>\n";
    echo $title;
    echo "</h1>\n";
}

function html_nav() {
    global $user;
     
    echo "<div>\n";
    echo "Navigation\n";
    echo "<ul>\n";
    echo "<li><a href=\"?page=home\">Home</a></li>\n";
    if ($user->check_login() == true) {
        echo "<li><a href=\"?page=logout\">Log Out</a></li>\n";
    } else {
        echo "<li><a href=\"?page=login\">Log In</a></li>\n";
        echo "<li><a href=\"?page=register\">Register</a></li>\n";
    }
    echo "</ul>\n";
    echo "</div>\n";     
}

function html_end() {
    echo "</body>\n";
    echo "</html>\n";
}
?>

Hi, I'm trying to combine two images - an uploaded image and a permanent. First I try to resize them to the same dimensions. Why I resize the uploaded image to the dimensions of permanent, everything works fine. But when I do the opposite, the images just don't merge, and the output is just the permanent image with resized dimensions. Anyone knows why? Here is my code:

<?php
if( isset( $_FILES['image'] ) ){
	$desired_width = 360;
	$desired_height = 360;

	$layers = array();
	switch($_FILES['image']['type']){
		case "image/jpeg":
			$source_image = imagecreatefromjpeg($_FILES['image']['tmp_name']);
		    break;
		case "image/gif":
			$source_image = imagecreatefromgif($_FILES['image']['tmp_name']);
			break;
		case "image/png":
			$source_image = imagecreatefrompng($_FILES['image']['tmp_name']);
			break;
	}
	
	$frame = imagecreatefrompng("1.png");
        $desired_width = imagesx($source_image);
        $desired_height = imagesy($source_image);
        $virtual_image = imagecreatetruecolor($desired_width, $desired_height);
        imagecopyresampled($virtual_image, $frame, 0, 0, 0, 0, $desired_width, $desired_height, 360, 360);

	$layers = array($source_image,$virtual_image);

	$image = imagecreatetruecolor($desired_width, $desired_height);

	// to make background transparent
	imagealphablending($image, false);
	$transparency = imagecolorallocatealpha($image, 0, 0, 0, 127);
	imagefill($image, 0, 0, $transparency);
	imagesavealpha($image, true);

	imagealphablending($image, true);
	for ($i = 0; $i < count($layers); $i++) {
	    imagecopy($image, $layers[$i], 0, 0, 0, 0, $desired_width, $desired_height);
	}
	imagealphablending($image, false);
	imagesavealpha($image, true);

	header('Content-type: image/png');
	header('Content-Disposition: attachment; filename="new_profile.png"');
	imagepng($image);
}
?>

Hello,

I want to 'join' two corresponding array values together as in the example below.

$one = array('tomato', 'ham', 'bacon');
$two = array('soup', 'sandwich', 'roll');

$final=array(?)

//Desired answer =  (tomatosoup, hamsandwich, baconroll)

Is there a php function that can do this, or a series of functions? I am aware of array_merge but this only alternates the values from what I can see.

Ideally there should be a check performed that the two are the same length before completing a merge.

New to this, many thanks!

I have tried many solution, but nothing seems to fix this.
The problem is that i put an image with transparency on top of another image, but the transparent pixels still transparent, where they should show some of the image below it.

If you call it with l=100 and p=20 i would get this result http://cl.ly/566Z instead of this http://cl.ly/56OF.

Here is the source code and I have attached the images:
Code: [Select]
<?php
header('Content-type: image/png');
echo imagepng(progressbar($_GET['l'], $_GET['p']));
function progressbar($length, $percentage)
{
$length = round($length / 2) * 2;
$percentage = min(100, max(0, $percentage));
if($length > 0)
{
$bar = imagecreate($length, 14);
imagealphablending($bar, false);
imagesavealpha($bar, true);
$empty = imagecreatefrompng('Empty.png');
imagealphablending($empty, false);
imagesavealpha($empty, true);
$fill = imagecreatefrompng('Fill.png');
imagealphablending($fill, false);
imagesavealpha($fill, true);
$lempty = imagecreatefrompng('LeftEmpty.png');
imagealphablending($lempty, false);
imagesavealpha($lempty, true);
$lfill = imagecreatefrompng('LeftFill.png');
imagealphablending($lfill, false);
imagesavealpha($lfill, true);
$rempty = imagecreatefrompng('RightEmpty.png');
imagealphablending($rempty, false);
imagesavealpha($rempty, true);
$rfill = imagecreatefrompng('RightFill.png');
imagealphablending($rfill, false);
imagesavealpha($rfill, true);
$emptycaplength = min(7, $length / 2); //5 
imagecopy($bar, $lempty, 0, 0, 0, 0, $emptycaplength, 14);
imagecopy($bar, $rempty, $length - $emptycaplength, 0, 7 - $emptycaplength, 0, $emptycaplength, 14);
if($length > 14)
{
imagecopyresized($bar, $empty, 7, 0, 0, 0, $length - 14, 14, 1, 14);
}
$filllength = round(($length * ($percentage / 100)) / 2) * 2;
$fillcaplength = min(7, $filllength / 2);
imagecopy($bar, $lfill, 0, 0, 0, 0, $fillcaplength, 14);
imagecopy($bar, $rfill, $filllength - $fillcaplength, 0, 7 - $fillcaplength, 0, $fillcaplength, 14);
if($filllength > 14)
{
imagecopyresized($bar, $fill, 7, 0, 0, 0, $filllength - 14, 14, 1, 14);
}
imagealphablending($bar, true);
return $bar;
}
else
{
return false;
}
}
?>

Hi wondering if there's a simple way to merge or update the data from one array to another . I've tried merge data but it just adds additional records rather than merging them off one common key.   The array is just simply adding a name to another array the format of both is as follows   Array 1   [0] => stdClass Object
(
[name] =>
[market] => Football
[selection] => 7051575

)   )   Array 2   Array
(
[0] => stdClass Object
(
[name] => Something
[market] =>
[selection] => 7051575

) )     There are other fields but I'm just trying to merge the name from Array two into Array one using the selection as a common key. Is there an easy command like merge or do I have to loop thru the arrays to add the data.   Thanks

Hi guys,   I wonder if you can offer any advice?   I have two user database tables that are about 70% identical. The problem is that with one of them, the phone number for each user has been cut short by two digits (it was an error on my part early on in the database design).    What I need to do is to get the values from both tables and put them into separate arrays then compare the arrays in a loop. If, say, the first five digits of the phone number in each row of the first table match one entry in the second table then update the second table with the phone number (the full length one).   I'm about puzzled about how to approach this, I've still got a lot to learn about array functions, it seems like it should be fairly simple but I'm a bit lost as to where to begin.   Any advice would be massively appreciated!    

Good day everyone. I go by the nickname Sbosh and I am a newbie in PHP.

I am currently learning php using video tutorials. I need help with regards to php queries.

I have the following code:

"SELECT 'food', 'calories' FROM 'diet' ORDER BY 'id'"

which is supposed to display content from a table inside phpmyadmin which i created manually using phpmyadmin. But It gives an error saying i must check the MariaDB version on how to right this query, something like that.

Please assist on the proper way of writing this code. Again I am a newbie in PHP and just starting to learn, so your help will be highly appreciated.

ive had these queries working okay until i checked on it today, it's not working anymore..
these are the errors:::
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\arrastre\add.php on line 105
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\arrastre\add.php on line 117


if(isset($_POST['add'])){
if($billnmbr=="" or $orno=="" or $payor=="" or $arrastre=="" or $wharfage=="" or $total=="" or $date=="" or $tcl==""){
echo "At least one field was left blank.";
}
else{
$query = mysql_query("select * from `arrastre` WHERE `billnmbr`='$billnmbr'"); /*****************this is my line 105************/
$count = mysql_num_rows($query);
if($count==1){
echo "This billnumber is already in the database.";
}

else{
$bll = strtoupper($billnmbr);
$payr = strtoupper($payor);
$query="insert into `arrastre` (`billnmbr`, `orno`, `payor`, `arrastre`, `wharfage`, `total`, `date`, `tcl`)
values ('$bll', '$orno', '$payr', '$arrastre', '$wharfage', '$total', '$date', '$tcl')";
$result=mysql_query($query);

$query = mysql_query("select * from `arrastre` where `billnmbr`= '$billnmbr'", $link); /************and this is my line 117*************/
$count = mysql_num_rows($query);
if($count==1){
echo "last bill number added: ".$billnmbr;
}
}
Thank you very much for your time and have a nice day.

Hello all,

I've tried several ways to calculate a commission in the multi level marketing script, but it all ended up with nothing, recursive functions, nested sets nothing worked, and i'm running out of time to keep trying

I've made multiple queries on the same table, and it's working, but only the first 3 queries, not more, I tried to perform it 4 times (although I need the queries to be performed 13 times) but still only 3 times

example: A recruited B and C, and B recruited D, and D recruited E.... what's supposed to happen is A takes a commission on B, C, D, and E
but now it only takes commission on the first three, and no commission for anyone comes after that, and the same for B, C, D, and E each takes commission on only 3 members down the line, and no more

here is the queries

Code: [Select]
<?
 $result = mysql_query("SELECT * FROM users");


echo "<table width='589' border='1'>
<tr>
<th>ID</th>
<th>Name</th>
<th>National ID</th>
<th>Commission</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
 
$query = mysql_query("SELECT * from users where recruiteris = '".$row['id']."'");
$num_rows=mysql_num_rows($query);

              $id1 = $row['id']; 
               
                $commission = $num_rows;
               
               
            $_SESSION['id1'] = $id1;
               
  echo "<tr>";
  while ($roww = mysql_fetch_array($query))
  {
  $querry=mysql_query("select * from users where recruiteris = '".$roww['id']."'");
    $num_rowss = mysql_num_rows($querry);
  while ($rowws= mysql_fetch_array($querry))
   { $var3= '10';

  $querrys=mysql_query("select * from users where recruiteris = '".$rowws['id']."'");
    $num_rowsss = mysql_num_rows($querrys);
   while ($rowwss= mysql_fetch_array($querrys))
   
   {
    $querryss=mysql_query("select * from users where recruiteris = '".$rowwss['id']."'");
    $num_rowssss = mysql_num_rows($querryss);
   while ($rowwsss= mysql_fetch_array($querryss))
   {
   
   
    $querryr=mysql_query("select * from users where recruiteris = '".$rowwsss['id']."'");
    $num_rowssr = mysql_num_rows($querryr);
    }
    }
    }
    }
    $total= ($commission + $num_rowws + $num_rowwss + $num_rowwsss + $num_rowss + $num_rowssr) * $var3;
 echo  "<td><a href=\"user.php?id=".$row['id']."\">".$row['id']."</a></td>";
echo "<td>" . $row['fname'] .''. $row['lname'] ." </td>";
 echo"<td> ". $row['nid'] ." </td>";
  echo  "<td>".$total."</td>
   </tr>";
  }
 
echo "</table>";
        ?> 

Hi,

Hey guys - me again!

I have a discount box, where i wish to check two "if" queries.  These are i) the 'uniquecode' and ii) the 'uses' - so a code can only be used a set amount of times.

1) How do i state that question in php, bearing in mind the "if uses > 0" needs to relate to the same row as the unique code entered?

2) Also, i have stored the session price in $_SESSION['sessionprice'] - is this the best way to do this, and if not how should i store the current price. 

3) Lastly, and how do I do the php mathematics of "$_SESSION['sessionprice'] minus the discount" - again bearing in mind the "discount" needs to relate to the same row as the unique code entered? (as different codes will have different discounts).


This is how far i've gotten:

Code: [Select]
<?php
//connection settings bla bla bla

$uniquecode = $_POST['discountcode'];

mysql_connect($localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$discountcodecheck = mysql_query("SELECT uniquecode FROM discounttable WHERE uniquecode = '".$uniquecode."'");
$remainingusescheck = mysql_query("SELECT uses FROM discounttable WHERE uniquecode = '".$uniquecode."'");

if (mysql_num_rows($discountcodecheck) > 0) and if (mysql_num_rows($remainingusescheck) > 0)  // <-- this "and if" doesn't work
{
// discount calculation:
// session price minus the unique code's corresponding discount
// update $_session['discountammount']

}
else
{
?><script type="text/javascript">
alert("Discount Code Entered Is Either Not Valid Or Has Been Previously Used.");
        history.back();
      </script><?php
}

// rest of code and close connection
?>

Any help or comments will, as always be politely welcomed and appreciated

Cheers,

Tom.