PHP - Php Encode Not Producing =

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.

Code: [Select]
echo '<img src="data:image/jpg/png/jpeg;base64,' . base64_encode( $row['image'] ) . '" height="150" />';
This is showing up images great in firefox, safari and chrome, but in internet explorer it shows a nice red cross, and I assume it is because of the encoding?

Does anyone know how to get working in internet explorer as well?

Pretty urgent job!

Much appreciated for your help!

Hello - I am connecting to MySql and running a query.  If I use a foreach loop, I can iterate over the results and have them print to screen.  However, when I try the below everything is null!

 

How can I add the results of my MySql query to a php array?

 

	<?php
$con=mysqli_connect("site", "user", "psasswr=ord", "db");
	if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
	$sql="SELECT * FROM test LIMIT 10";
$result = mysqli_query($con,$sql);
	echo json_encode($result);
	mysqli_free_result($result);
	mysqli_close($con);
?>
	

 

but what this prints is:

{"current_field":null,"field_count":null,"lengths":null,"num_rows":null,"type":null}

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=315503.0

I've used this before and it worked fine but the mt_rand is not working properly.  It keeps producing the same number.

I've tested it on with the $_GET to the next page and it produces a unique code but it doesn't want to insert that number into the table, just the other same, repetitive number.

$transaction_id =  mt_rand() . mt_rand();
$item_email = mysql_real_escape_string($_POST[email]);
$item_first_name = mysql_real_escape_string($_POST[first_name]);
$item_last_name = mysql_real_escape_string($_POST[last_name]);
$item_street = mysql_real_escape_string($_POST[street]);
$item_street2 = mysql_real_escape_string($_POST[street_2]);
$item_city = mysql_real_escape_string($_POST[city]);
$item_state = mysql_real_escape_string($_POST[state]);
$item_zip_code = mysql_real_escape_string($_POST[zip_code]);
$item_country = mysql_real_escape_string($_POST[country]);
$username = $_SESSION['username'];
$item_id = $_GET['id'];
$item_title = mysql_real_escape_string($_POST[title]);
$item_price = mysql_real_escape_string($_POST[price]);
$item_shipping_cost = mysql_real_escape_string($_POST[shipping_cost]);
$item_in_shipping = mysql_real_escape_string($_POST[in_shipping]);
$okay = TRUE;

if ($item_country == 'United States'){
$shipping = "$item_shipping_cost";
}
else { $shipping = "$item_in_shipping &nbsp;&nbsp;&nbsp;-&nbsp;<span class=\"submissionfont\">International Rate</span>";
}

$sql="INSERT INTO buyer (username, email, first_name, last_name, street, street_2, city, state, zip_code, country, transaction_id, date) VALUES ('$username', '$item_email', '$item_first_name', '$item_last_name', '$item_street', '$item_street2', '$item_city', '$item_state', '$item_zip_code', '$item_country', '$transaction_id', CURDATE())";

 if (!mysql_query($sql))

  {

  die('Error: ' . mysql_error());

  }  
  
  $sql2="UPDATE product SET transaction_id='$transaction_id', sold='1', sold_date=CURDATE() WHERE id = '$item_id'";
  
 if (!mysql_query($sql2))

  {

  die('Error: ' . mysql_error());

  } 

I am trying to join two tables but I am producing no results. I'm convinced that I have entered everything correctly, but clearly I haven't? Can anyone spot my mistake?

<?php
require 'core/memberinit.php';
$member = new Member();
include 'timeago.php';

$memberid = $member->data() ->id;

if(isset($_GET['q'])) {
    $q = html_entity_decode($_GET['q']);

$query2 = DB::getInstance()->query("SELECT c.id c.time as time, c.message as message, c.removed1, c.removed2, 
			m1.member_first_name as firstname1, m1.member_last_name as lastname1, m1.username as username1,  
			m2.member_first_name as firstname2, m2.member_last_name as lastname2, m2.username as username2 
			FROM conversation c
				LEFT JOIN members m1 ON c.member1=m1.id
				LEFT JOIN members m2 ON c.member2=m2.id
			WHERE (c.id=$q OR c.originalid=$q)
			AND ((c.member1=$memberid AND c.removed1='No') 
			OR (c.member2=$memberid AND c.removed2='No'))
			ORDER BY c.id");
		
foreach ($query2->results() as $result2)
{
		echo $result2->firstname1;
		echo $result2->lastname1;
		echo $result2->username1;
		echo timeAgo(strtotime($result2->time));
		echo $result2->message;
		echo $result2->firstname2;
		echo $result2->lastname2;
		echo $result2->username2;
}
?>

Edited by MartynLearnsPHP, 23 November 2014 - 12:55 PM.

Code: [Select]
 
  <?php
    $query = "Select * from users where username = '$user' ";
    $result = mysql_query($query) or die(mysql_error());
    $row = mysql_fetch_array($result);

    $test = $_POST['test1'];
    $ques = "Select * from questions where testname = '$test' ";
    $qres = mysql_query($ques) or die(mysql_error());
    $qdetails = mysql_fetch_array($qres);
    $id = $qdetails['id'];
    $testname = $qdetails['testname'];
    $ans = "Select * from answers where qid = $id";
    $ares = mysql_query($ans) or die(mysql_error());
    if($qdetails) {
    ?>
    <div class="padding">

    <form name="answerform" action="answer.php" method="POST">
    <h3>&nbsp;</h3>
    <input name="test2" id="test2"  type="text" value="<?php echo $qdetails['testname'];?>"      /><h3><?php echo $qdetails['text'];?></h3>
     <input name="test3" id="test3"  type="text" value="<?php echo      $qdetails['testseries'];?>" /><h3><?php echo $qdetails['text'];?></h3>
    <br />
    <br />
    <br />
    <?php while($opdetails = mysql_fetch_assoc($ares)) { ?>
    <input class="text" id="opt2" name="correctans" type="radio" value="<?php echo $opdetails['text']; ?>" /><br /><?php echo $opdetails['text']; ?>  <?php }?>
    <div class="two-fields clearfix".
    <p class="confirm">&nbsp;</p>
    </div>
    <input type="submit" value="SUBMIT ANSWER" />
    </form>
    </div>
    </div>
    </div>
 <?php }

this is the code for the program where i am creating the fields i want to fetch the data from the input fields with the name test 2 and test 3 in answer.php

Code: [Select]
    $query = "Select score from users where username = '$user' ";
    $result = mysql_query($query) or die(mysql_error());
    $row = mysql_fetch_array($result);
    $user_score = $row['score'];

    print_r($_REQUEST);
    $tester = $_POST['test3'];
    $test = $_POST['test2'];
    print_r($_POST);
    var_dump($_POST);
    $ques = "Select * from questions where testname = '$test' And testseries = '$tester' ";
    $result = mysql_query($ques) or die(mysql_error());
    $row = mysql_fetch_array($result);
    $qid = $row['id'];
    $score = $row['score'];
    if(isset($_POST['correctans']))
    {
    $answer = $_POST['correctans'];
    }
    else
    {
    $answer = '';
    }
    $fetch_ans = "Select * from answers where correct = 1 AND qid = $qid";
    $result = mysql_query($fetch_ans) or die(mysql_error());
    $row = mysql_fetch_array($result);
    $id = $row['id'];
    $correctans = $row['text'];

    if('$correctans' == '$answer')
    {
    $user_score += $score;
    $qid++;
    $query = "Update users set score = $user_score  where username = '$user'";
    $res = mysql_query($query) or die(mysql_error());
    if($res) {
 
header("Location: answer.php"); 
    }
    }else
    {
header("Location: answer.php");
    }


    ?>
THIS IS answer.php and here i try to post information from test2 and test3 fields  but i am not getting any output
the output shows blank array()
and unidentified index test2
and unidentified index test3
i am not able to figure out the error
any help will be highly appreciated
and forgive me if i have made any mistakes in posting the question since i am a newbie at PHPFREAKS

I am trying to produce a thresholded image with only an rgb value of zero or 255.

As you can see, although I only output 0 and 255,
I am finding that if I output as jpg file, I get other values in there as well.
If I output as gif, I also get other values in there too.

I am sure I am doing something stupid as there must be a way to do this.

My test file is this attached jpg greyscale file.

Is there a way to process this test file so that only 0 or 255 appears in the output image please? Thanks.

Here is my program

<?php
$url = 'greyscale_image.jpg';
$outfile = 'greyscaleout';
$src = imagecreatefromjpeg($url);
$w = imagesx($src);$h = imagesy($src);
$loband = 80;$hiband = 255;

$im_r = imagecreatetruecolor($w,$h);
imagefill($im_r,0,0,imagecolorallocate($im_r,255,0,0));

$im_j = imagecreatetruecolor($w,$h);
imagefill($im_j,0,0,imagecolorallocate($im_j,255,0,0));

for ($x=0;$x<$w;$x++) {
for ($y=0;$y<$h;$y++) {
$idx = imagecolorat($src,$x,$y);
$rgb = imagecolorsforindex($src,$idx); // this is safest (for gifs) rather than some calculation - apparently
$r =$rgb['red'];
$g = $rgb['green'];
$b = $rgb['blue'];

$gryout = $r;
if ($r <= $loband) {
$gryout = 0; // everything less than= loband is black
}
if ($r > $loband) {
$gryout = 255; // everything else is white
}
if ( ($gryout == 0) || ($gryout == 255) ) {
// only zero or 255 allowed
$idx = imagecolorallocate($im_r,$gryout,$gryout,$gryout);
imagesetpixel($im_r,$x,$y,$idx); //
imagesetpixel($im_j,$x,$y,$idx); //

$idx2 = imagecolorat($im_r,$x,$y);//
if ($idx != $idx2) {
die($idx2." at x,y ".$x.",".$y);
}
$rgb = imagecolorsforindex($im_r,$idx); // this is safest (for gifs) rather than some calculation - apparently
$r =$rgb['red'];
$g = $rgb['green'];
$b = $rgb['blue'];
if ($r != 0) {
if ($r != 255) {
die($r." at x,y ".$x.",".$y);
}
}
} else {
die('<br>Grey going out to image is '.$gryout);
}
}
}
imagegif($im_r,$outfile.'.gif');imagedestroy($im_r);
imagejpeg($im_j,$outfile.'.jpg');imagedestroy($im_j);
// ==========================
// done the writing, now check it
// ==========================
// $outfile = 'greyscale_image'; // test using original
$src = imagecreatefromjpeg($outfile.'.jpg');
$w = imagesx($src);$h = imagesy($src);
$errcount = 0;
$x = 0;
while($x<$w) {
$y = 0;
while($y<$h) {
$idx = imagecolorat($src,$x,$y);//
$rgb = imagecolorsforindex($src,$idx); // this is safest (for gifs) rather than some calculation
$r =$rgb['red'];
$g = $rgb['green'];
$b = $rgb['blue'];

if ($r != 0) {
if ($r != 255) {
echo sprintf('<br>r(%d,%d) r=%d g=%d b=%d',$x,$y,$r,$g,$b);$errcount++;
}
}
if ($g != 0) {
if ($g != 255) {
echo sprintf('<br>g(%d,%d) r=%d g=%d b=%d',$x,$y,$r,$g,$b);$errcount++;
}
}
if ($b != 0) {
if ($b != 255) {
echo sprintf('<br>b(%d,%d) r=%d g=%d b=%d',$x,$y,$r,$g,$b);$errcount++;
}
}
if ($errcount > 10) {break 2;}

$y++;
}
$x++;
}
if ($errcount == 0) {die( ' Checked OK' );}
die( ' Checked  NOT OK' );
// =================
?>

I have written code so that when something from a MySQL field equals 0, then PHP will take no action, and if the field equals anything else, then 'echo "foo"'.
The problem I am having is that when PHP echo's nothing (echo ""), its still creating the effect of a HTML <BR>.

Screen shots:

1. When the MySQL table contains something else than 0 (echo "foo").
http://i51.tinypic.com/2n7oxo1.png

2. When the table contains 0 (echo "").
http://i53.tinypic.com/2h5jg4k.png

3. What it should look like if the table were to contain 0 (echo ""). Note that their is no <BR> effect.
http://i51.tinypic.com/2jdtaf.png


Code:
$query = "select sizes from products where id='$id'"; $result = mysql_query($query); $data = mysql_fetch_array($result); if ($data['sizes'] == 0) {echo "";} else {echo "Small - ".$data['sizes'];}

Is it possible to make it so if a MySQL field result equals 0, then PHP will not produce the HTML <BR> effect when it echo's nothing (echo "")?