PHP - Combine Similar Arrays - Additive

I'm pretty sure there isn't, but I was wondering if there was a php function that would return partial matches similar to MySQL's LIKE, I've been searching for a while and haven't found one.  If not, is there a class or something that someone knows of that will accomplish a like of search or a string comparison?  I want to be able to compare two variables and return one of three results - Exact Match, Partial Match, No Match.

I suppose regex may do the trick but I'm a complete novice when it comes to regex and I have no idea where to even begin.

Thanks for any suggestions.

Hello,

I am looking for a push in the right direction. I would like to be able to view a website that is duplicated on many servers by specifying the IP address. Similar to how one would use the hosts file.

I can do this using netcat
nc 1.2.3.4 80
Host: example.com
GET /contact-us.html
<CR><CR>

Can someone tell me how I would go about porting this to PHP? I would just like to set up a small page on my webserver where I can enter the domain and IP address and have the page displayed back to me.

Thanks Colin

I have this thing that i am trying to make but i cant get it to work.. can anyone help?

Code: [Select]
function sql_read( $dbname,$dbusername,$dbpassword )
{
$names = array();
$password = array();


$connect = @mysql_connect("mysql11.000webhost.com",$dbusername,$dbpassword) or die("Could Not Connect");
@mysql_select_db ($dbname) or die("Could not find DataBase");


$query = mysql_query("select * from users");
$numrows = mysql_num_rows($query);

if ($numrows > 0){

while($row = mysql_fetch_assoc($query)){

$names[] = $row["uname"];
$password[] = $row["password"];
$id = $row["id"];

}
$return = array($names,$password,$id);

}else{
$return = array();
}


return $return[];
}



$names = array();

$names = sql_read("XXXXXX","XXXXXX","XXXXXXX")[0];


The error i get is
Code: [Select]
Parse error: syntax error, unexpected '[' in /home/a5480952/public_html/sql/index.php on line 28
Line 28 is "$names = sql_read("XXXXXX","XXXXXX","XXXXXXX")[0];"

Please help... i REALLLLD need help with this.. ask questions if you want to know more about what i am trying to do... thanks!

I'm having troubling with trying to create a function to spit out a single array with the following array. I can write it in a away that looks through the arrays manually. 

the results i am trying to generate is that each item in generated array.

Array to convert

array(
    "account" => array(
        "login",
        "register",
        "logout",
        "edit",
    ),
    "p" => array( 
        "report",
    ),
    "array1.0" => array( 
        "array2.0" => array(
            "array3.0",
            "array3.1
        ),
        "array2.1",
    ),

generating the array will look like this

 

Array ( 
[0] => account 
[1] => account/login 
[2] => account/register 
[3] => account/logout 
[4] => account/edit 
[5] => p 
[6] => p/report 
[7] => array1.0 
[8] => array1.0/array2.0
[9] => array1.0/array2.0/array3.0
[10] => array1.0/array2.0/array3.1
[11] => array1.0/array2.1

)

The idea is that id generates a single array with combined labels and arrays inside, etc. I just can't figure out how to create a script that will create this array even If I add a new value or array. 

 

How to COUNT  the number of records (pulled from a db)which  contains the word "APPROVED". This code doesn't work though.

$result1;
$result2;
$result3;

$approvedApplicants = COUNT($result1=='Approved', $result2=='Approved', $result3=='Approved')
echo ($approvedApplicants)

This topic has been moved to HTML Help.

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

Hello,

I need to be able to find what is inbetween 2 values in a string of text.

For example,

<?php
$string="Hello and welcome to the site. Click [link]welcome.php[/link] here to continue to the site";

?>

So I need some method of searching the string to see what values are in between the [link] and [/link] which I will then deal with in my own way.

I have a feeling that I could do this with explode, but I'm not really sure. Any advice?

Thanks in advance

Hi Folks, i have been at this for ages and its now depressing me as i cannot figure out why i cant get it to work.

I am using a re-hashed version of a facebook style wall post system where it limits the amount of replies, you click a button and gets the next set and so on until there are no more results to get.
The original script runs ok but is not really suitable for what i need
So to my script which is based loosley on the same principal.

Ok i have a veiwmember.php page which uses pagination to limit the amount of wall posts to 5.
I have included the various javascript files jquery and another which is needed.

The function used is this one:

Code: [Select]
<script type="text/javascript" src="jquery.livequery.js"></script>
<script type="text/javascript" src="jquery-1.2.6.min.js"></script>

<script type="text/javascript">
//more records show
$('a.more_records').livequery("click", function(e){

var next =  $(this).attr('id').replace('more_','');

$.post("data.php?show_more_post="+next, {

}, function(response){
$('#bottomMoreButton').remove();
$('#posting').append($(response).fadeIn('slow'));

});

});

</script>

The php code in veiwmember.php that gets the wall posts is:

Code: [Select]
Pagination code here
<?php 
$getwallposts= ("SELECT * FROM wallposts WHERE recipientid='$memberid' ORDER BY id DESC LIMIT $offset, $rowsperpage");
$result = mysql_query($getwallposts,$con);
while ($row2 = mysql_fetch_assoc($result)) {
$messageid= $row2['id'];
$senderid= $row2['senderid'];
$wallpost= $row2['wallpost'];
$timesent= $row2['timesent'];
$timestamp = strtotime($timesent);
$likes= $row2['likes'];
$getname= ("SELECT fname, lname, image1 FROM memocp WHERE unid='$senderid'");
$nameresult= mysql_query($getname,$con);
while ($rowws = mysql_fetch_array($nameresult)) {
$fname= $rowws['fname'];
$lname= $rowws['lname'];
$wallpostprofilethumb= "{$rowws['image1']}";
if (empty($wallpostprofilethumb)) {$wallpostprofilethumb= "noimage.png";}
}
?>
<div class="wallpost"><div class="from"><div class"profilethumb"><img src="profilethumb/<?php echo $wallpostprofilethumb; ?>"></div><a href="veiwmember.php?membid=<?php echo "$senderid"; ?>"><?php echo "$fname $lname"; ?></a></div><div class="postbody"><?php echo txt2link($wallpost) ?><div class="timesent"><?php echo date('l jS F Y @ H:i a', $timestamp); ?></div></div><div class="likes"><form action="like.php" method="post"><?php if (isset($_GET['currentpage'])) {$currentpage= $_GET['currentpage']; echo "<input name=\"currentpage\" type=\"hidden\" value=\"$currentpage\">";} ?><input name="messageid" type="hidden" value="<?php echo "$messageid"; ?>"><input name="base" type="hidden" value="<?php echo "$memberid"; ?>"><input name="like" type="image" src="ima/like.jpg"><?php echo " $likes people like this"; ?></form></div></div>
<?php include_once('data.php'); ?>



<?php }
rest of pagination

The pagination sort of works, but only displays one result per page when it should show 5 results plus how ever many replies, but i can sort that out later, would prefer to get the replies working first.


You will see that data.php is included which gets the replies to the wall posts.
It should limit the amount of replies shown to five, and then if there is more, it will show a link to get more.
If that link is clicked it should get the next five results and show them. However it shows the first five and the link if there are more results, but if the link is clicked, nothing happens.

data.php

Code: [Select]
require ("database.php");
$next_records = 5;
$show_more_button = 0;

if(isset($_REQUEST['show_more_post'])) // more posting paging

{

   // button has been clicked so we need to get next set of results
   $next_records = $_REQUEST['show_more_post'] + 5;

   $result = mysql_query("SELECT * FROM wallreplies2 WHERE messageid='$messageid' ORDER BY wallreplyid DESC limit ".$_REQUEST['show_more_post'].", 5");

   // see if there are any more replies to get
   $check_res = mysql_query("SELECT * FROM wallreplies2 order by wallreplyid DESC limit ".$next_records.", 5");
   $show_more_button = 0; // button in the end

   $check_result = mysql_num_rows($check_res);
   if($check_result > 0)
   {
   // if there any more results counted the button needs to be shown
   $show_more_button = 1;
   }

}
// if the button hasnt been clicked we need to get the first results
else
{


   // lets count the number of results that exist
   $countreplies= mysql_query("SELECT * FROM wallreplies2 WHERE messageid='$messageid'");
   $countresult= mysql_num_rows($countreplies);


   // if there are more than 5 results
   if ($countresult > 5)
{
   // the button needs to be shown
   $show_more_button = 1;
}
   else
{
   // if there are 5 or less replies in total, dont show the button
   $show_more_button = 0;}
   //there are only 5 or less replies to get so get the first results
   $result = mysql_query("SELECT * FROM wallreplies2 WHERE messageid='$messageid' ORDER BY wallreplyid DESC limit 0,5");

}





//$replyresult = mysql_query($result,$con);
while ($roww = mysql_fetch_array($result)) {
$wallreplyid= $roww['wallreplyid'];
$sendid= $roww['senderid'];
$wallreply= $roww['wallreply'];
$time= $roww['timesent'];
$Timestamp = strtotime($time);
$like= $roww['likes'];
$getreplynames = ("SELECT fname, lname, image1 FROM memocp WHERE unid='$sendid'");
$nameresults = mysql_query($getreplynames,$con);
while ($roww = mysql_fetch_array($nameresults)) {
$fnames= $roww['fname'];
$lnames= $roww['lname'];
$wallreplyprofilethumb= "{$roww['image1']}";
if (empty($wallreplyprofilethumb)) {$wallreplyprofilethumb= "noimage.png";}
}
?>
<div class="wallreplies" id="record-<?php echo"$wallreplyid"; ?>">
<div class="wallreplywrap">
<div class="wallfrom">
<div class"profilethumb"><img src="profilethumb/<?php echo $wallreplyprofilethumb; ?>"></div>
<a href="veiwmember.php?membid=<?php echo "$sendid"; ?>"><?php echo"$fnames $lnames"; ?></a>
</div>
<div class="wallmessbody"><?php echo txt2link($wallreply) ?></div>
<div class="timesent"><?php echo date('l jS F Y @ H:i a', $Timestamp); ?></div>
<div class="likes"><form action="like2.php" method="post"><?php if (isset($_GET['currentpage'])) {$currentpage= $_GET['currentpage']; echo "<input name=\"currentpage\" type=\"hidden\" value=\"$currentpage\">";} ?><input name="messageid" type="hidden" value="<?php echo "$wallreplyid"; ?>"><input name="base" type="hidden" value="<?php echo "$memberid"; ?>"><input name="like" type="image" src="ima/like2.jpg"><?php echo " $like people like this"; ?></form>
</div>
</div>
</div>
<?php }
if($show_more_button == 1){
echo "<div class=\"bottomMoreButton\">
<a id=\"more_$next_records\" class=\"more_records\" href=\"javascript: void(0)\">Get more replies</a>
</div>"; }?>
<div class="wallreply">
<form action="wallreply.php" method="post">
<input name="sendrid" type="hidden" value="<?php echo "$loginuniqid"; ?>">
<input name="messageid" type="hidden" value="<?php echo "$messageid"; ?>">
<input name="base" type="hidden" value="<?php echo "$memberid"; ?>">
<?php if (isset($_GET['currentpage'])) {$currentpage= $_GET['currentpage']; echo "<input name=\"currentpage\" type=\"hidden\" value=\"$currentpage\">";} ?>
<textarea  class="newwallpostreply<?php echo $i++ ; ?>" name="wallreply" autocomplete="off" maxlength="1000" placeholder="Reply"></textarea>
<span class="wallreply-holder<?php echo $p++; ?>">
<div class="button_block">
<input type="submit" class="post" value="Post">
<input type="submit" class="cancel" value="Cancel">
</div>
</span>
</form>
</div>

I know its a lot of info there, but if anyone can see the problem i would be greatful.

are all of the following same, or some same or all different:
$variable=""
$variable=0
$variable=NULL

and which of the above will satisfy
if(empty($variable))
{
blah!;
}

I need to display multiple files that have a similar file name, but there are timestamps added to the filename once its been modified.  What could I use in PHP to display all these files?

Right now I use a $path variable that looks into a SQL table to build the path to the folder that the files reside in..

ELSEIF($Recordmyrow['Applicatio'] == "pdf file")
{
IF($securityvalue != "P"){$display = false;}
IF(file_exists(substr($path, 5))){}
ELSE{$column4 = "<A href='javascript:mbox();'>UNAVAILABLE</A>";}
}

So there is a file called file1.pdf then another one called file1.mmddyyyy.pdf

My code shows file1.pdf but not file1.mmddyyyy.pdf

Is there some kind of wildcard I can use to get it to show all the files if they exist?

Hello everybody,

I'm trying to write some code similar to Odesk.com or DMOZ.ORG.

I need to count the number of listings in each category.  Look here "http://ibatty.org/browse.php" to get a better idea of what I'm doing. That is the page I'm trying to add this function to.

I've been having major issues with the COUNT function.

Code: [Select]
$query = "SELECT category, COUNT(*) FROM postlisting WHERE category='billboards'";
        $result = mysqli_query($dbc,$query);
        while($row = mysqli_fetch_array($result))
        {
        echo $row[COUNT(category)];
        }
As you can see this works, but I'm trying to add State, Area code and Zip functuality to search through the data more precisely. This has been giving me problems though and the way I currently have it setup . . .
I'd have 25+ SELECT COUNT() querys going on 1 page. (I don't know if that is very good?)

5$ via paypal to whoever can help me solve this.

If I did not explain what I needed very well, please ask questions for me to clarify.

Thank you in advance

Hi guys, im currently querying my database and if ($row) im including a file. But i would like to make it so if ($row) or a session variable is active, to include the file.

I have tried using || but ive only ever used that for regular variables and I cant get it working in the way i want.

so at the moment i have

Code: [Select]
if ($row)

(

require 'myfile';
and i would like to add || $_SESSION['email'] is active. im guessing i would use isset, but i just cannot get it working.

I am building online dictionary with php. The following code allows the user to search a word and display the definition results from the database. The problem is the user has to input the identical words only. If the words are not exactly similar to the database words it returns error message. But in this case I need it to give a suggestion along with the error message based on the few beginning words of the submitted word. eg. if the user type a word "suggestion", and the word "suggestion" is not available in the database .... instead of just the error message to also search and include other stored data closer to the submitted word ... like "TRY the word SUGGEST".

can any one help me on this please.
Thank you in advance.

here is the code
Code: [Select]
<?php

$script = $_SERVER['PHP_SELF'];

if(isset($_POST['sbm']) && isset($_POST['word']) ) {
  submited();
} else {
  show_form();
}

function show_form() {
?>
<p><center> Type <span style='font-weight:bold;'>ENGLISH</span> word Only! <span style='font-weight:bold;'>SPELL IT CORRECTLY!!!.</span></center></P>
<p><center>Search</center></p>
 <center><form name=frm method=POST action="<?php echo $script ?>">
     <p><input type=text name="word"><br /></p>
    <p><input type=submit name="sbm" value="Submit">
  </form>    </center></p>
<?php
}

function submited() {
  require("dbconn.inc");
  $word=$_POST['word'];
  $sql="select * from words where eng like '".mysql_real_escape_string($word)."'";
  $result=mysql_query($sql,$link); // I assume $link is defined in dbconn.inc

  if(@mysql_num_rows($result)!=0) {
    $rows=mysql_fetch_array($result);
    $am=$rows["am"];
    echo("<center>The Word <h1><b>$word</b></h1> in Am is : <h1><b>$am </b></h1><br></center>");
  } else {
    echo("<center><span style='font-weight:bold;color:#FF0000;'>Could not find it! Check the spelling and try again !!</span></center>");
  }

  // The connection will close automatically since
  // this is near the end of the script.
  mysql_close($link);

  show_form();
}
?>

Hi

I have an array which looks a little like this, the first number in each array is a quantity

$cars = array (
  array(1,"BMW",15,13),
  array(8,"BMW",15,13),
  array(3,"Saab",5,2),
  array(4,"BMW",11,7),
  array(5,"Land Rover",17,15),
  array(6,"Saab",5,2)
);

what I want to do is combine any array which matches another, but ignoring the quanitity value (first one).

Then creating the array again and adding up the quanitity values and re-inserting them at the start.

Therefore the end result would look like

$cars = array (
  array(9,"BMW",15,13),
  array(9,"Saab",5,2),
  array(4,"BMW",11,7),
  array(5,"Land Rover",17,15),
);

Has anyone got any ideas on how I might do this?

Thanks

Edited July 23, 2020 by John84

Gud Eve peeps!
So i have 2 variable strings:
Code: [Select]
$variable1 = item, item, item;
 $variable2 = number, number, number;

I need to make this 2 variables into 1 array being variable 1 as a key value and variable 2 as a variable..
and i tried combining them using:
Code: [Select]
$array = array_combine($variable1, $variable2);

the problem is some item name are the same so it just overwrites the other so instead of giving me this:
Array ([item] => number, [item] => number, [item =>number])

it gives me this:

Array ([item =>number])

I really need them to be complete because i will loop each key and value to be inserted to a new row in my db..
thanks again for the help!