PHP - Not Matching Extensions - Preg_match

Wondering if someone could help me. What I am trying to do is display the information from each row. I am trying to read from 2 tables and display them on a page. I want them to show like this

name,make,type, price,"images/listings/a1.jpg,images/listings/a2.jpg,images/listings/a3.jpg,images/listings/a4.jpg,images/listings/a5.jpg,images/listings/a5.jpg"
name,make,type, price,"images/listings/b1.jpg,images/listings/b2.jpg,images/listings/b3.jpg,images/listings/b4.jpg,images/listings/b5.jpg,images/listings/b5.jpg"

Example. the table structures are as so:

Code: [Select]
listings
--------------------------------
id  name    make   type   price  (then a couple more columns I dont need data from)
--------------------------------
1   name1   make1  type1  price1
2   name2   make2  type2  price2
3   name3   make3  type3  price3


listimages
----------------------------------------------------
id  imagepath                 mainimage   listingid   
----------------------------------------------------
1   images/listings/a1.jpg     1            1
2   images/listings/a2.jpg     0            1
3   images/listings/a3.jpg     0            1
4   images/listings/a4.jpg     0            1
5   images/listings/a5.jpg     0            1
6   images/listings/a6.jpg     0            1
7   images/listings/b1.jpg     1            2
8   images/listings/b2.jpg     0            2
9   images/listings/b3.jpg     0            2
10  images/listings/b4.jpg     0            2
11  images/listings/b5.jpg     0            2
12  images/listings/b6.jpg     0            2
13  images/listings/c1.jpg     1            3

etc

Here is the code I am using. Everything works except some of the listing images don't match up to the names.
I think when certain names don't have pictures it just moves up the images to the next person. I need to somehow associate the listingid column from listimages table with the id column from the listings table. The mainimage column
tells what image of the group of images is default for that name. 1 being the default 0 not the default

Here is the code I am using.

Code: [Select]

<?php

// Make a MySQL Connection
mysql_connect("localhost", "xxxxxx", "xxxxxx") or die(mysql_error());
mysql_select_db("xxxxxx") or die(mysql_error());

$result = mysql_query("SELECT * FROM listings l JOIN listimages li ON l.id = li.listingid ORDER BY l.id DESC")
or die(mysql_error());

$last_listingid = null;
$curRow = array();
while($row = mysql_fetch_array($result)) {
    
    // Check for a difference in listing ID - and if it is, then we should show the previous row first
if ($last_listingid != $row['listingid'] && $last_listingid !== null)
{
        // Implode the array with quotes around it
echo $row['name'];
echo ",";
echo $row['make'];
echo ",";
echo $row['model'];
echo ",";
echo $row['type'];
echo ",";
echo $row['price'];
echo ",";
echo '"' . implode(',', $curRow) . '"<br />';
        
        // And start fresh
        $curRow = array();
}
    
    // Now we can save it to the array
    $curRow[] = $row['imagepath'];
    
    // And set the new ID
$last_listingid = $row['listingid'];
}
// Finally, we'll need to implode it one last time since there should always be at least one value in the array
echo '"' . implode(',', $curRow) . '"';

?>

Please let me know what I am doing wrong Anyone    Thanks

Hi,

I am in the procress of creating discussion system however I am a bit puzzled about the best way to go about it.

I am starting the discussion by creating an ID number and then match the answer to the initial ID number.  However, I dont know whether if is best to put the responses into a different database.

I'm a bit puzzled how ID matching systems works.

Lets say:

Question 1 =    ID1
Question 2 =    ID2
Question 3 =    ID3
Question 1 Answer 1    =   ID4   (How is this matched to ID1)
Question 2 Answer 1    =   ID5   (How is this matched to ID2)

is this based on preg_match?

I have a list of companies I have to look up information for on the entity search page for the state.

here is what i have so far except there seems to be a verification error. Anyone know how to fix this so the page will display results?

<?php
// INIT CURL
$ch = curl_init();
 
// SET URL FOR THE POST FORM LOGIN
curl_setopt($ch, CURLOPT_URL, 'http://appext9.dos.state.ny.us/corp_public/CORPSEARCH.SELECT_ENTITY');
 
// ENABLE HTTP POST
curl_setopt ($ch, CURLOPT_POST, 1);

//set curl options
curl_setopt($ch, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2. Gecko/20100722 Firefox/3.6.8 ( .NET CLR 3.5.30729)");
curl_setopt($ch, CURLOPT_REFERER, "http://www.google.com/");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_COOKIEJAR, 'CURLCOOKIE');
curl_setopt($ch, CURLOPT_HEADER, true);
curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 0);

//visit page to get cookies
//$strGet_page_contents = curl_exec ($ch);
 
// SET POST PARAMETERS : FORM VALUES FOR EACH FIELD
curl_setopt ($ch, CURLOPT_POSTFIELDS, 'p_entity_name=Apple LLC&p_name_type=Arwen&p_search_type=BEGINS&submit=Search!');
 
 
// EXECUTE
$store = curl_exec ($ch);
 
echo curl_exec ($ch);


// CLOSE CURL
curl_close ($ch); 
 
?>

Hey, I need a bit of help replacing some variables in a string. I know its done with preg_replace.

Here is the string:

Code: [Select]
Header 1 <|header 2|> header 3 <b>header 4</b>
I would like to get ONLY <|header 2|> from the above string. But "header 2" is variable so please its useless if the preg_replace isn't flexible to find whatever word is in there regardless.

Thanks you.

Hi

I'm trying to match @USERNAME in a string and replace it with @<a href="message.php?member=USERNAME">USERNAME</a>

I've tried a few different methods:

Code: [Select]
preg_replace ('/@(.*?)/', '<a href="message.php?member=$1">$1</a>', $str)and also

    * and \@ but i just can't seem to get it to work. any help would be appreciated!

In the below example, we match 0 or more alphanumeric characters in the beginning and 0 or more alphanumeric characters in the end. Then we create 4 groups. Each group has "?=" which means "the next text must be like this". Now in first group we match any character 8 or more times. The next group we match 0 or more characters and a digit. In the next group we match 0 or more characters and a lowercase letter. In the next group we match 0 or more characters and an uppercase letter.

<?php
$password = "Fyfjk34sdfjfsjq7";

if (preg_match("/^.*(?=.{8,})(?=.*\d)(?=.*[a-z])(?=.*[A-Z]).*$/", $password)) {
    echo "Your passwords is strong.";
} else {
    echo "Your password is weak.";
}
?>

My question is do these four groups impact each other? That is, the fact that the first group has 8 or more characters means that all the groups must have 8 or more characters. The fact that the second group has a digit means that all the groups must have a digit. Or do they work exclusively meaning that a 4 character word with a single digit would match this pattern, even though first group says it must have 8 characters.

 

I wish to find the closest two DateTimes which are within $fillStart and $fillEnd and have the same week and 24 hour times as $gapStart and $gapEnd.

For instance, the following results in $fillStartModified and $fillEndModified which meets that criteria.

fillStart           2019-07-23 00:15:00 Tue
fillEnd             2019-09-23 13:00:00 Mon
gapStart            2019-05-23 00:15:00 Thu
gapEnd              2019-06-23 13:00:00 Sun
fillStartModified   2019-07-25 00:15:00 Thu
fillEndModified     2019-08-25 13:00:00 Sun

I came up with the following which seems to work, but it is kind of complicated and I am not positive it will meet all edge conditions.  Any recommendations?  Thanks

function getFill(\DateTimeImmutable $fillStart, \DateTimeImmutable $fillEnd, \DateTimeInterface $gapStart, \DateTimeInterface $gapEnd)
{
    //$gapInterval = $gapStart->diff($gapEnd);  // Doesn't work 
    $gapInterval = new \DateInterval('PT'.($gapEnd->getTimestamp() - $gapStart->getTimestamp()).'S');
    if($gapStart > $fillStart) {
        //The fill is older than the gap so make the fill's endTime match the gap's endTime
        $fillEndModified = $fillEnd
        ->modify('previous '.$gapEnd->format('D'))
        ->setTime(...explode('.', $gapEnd->format('H.i.s.u')));
        if($fillEndModified->diff($fillEnd)->format('%a') >= 7) {
            $fillEndModified = $fillEndModified->add(new \DateInterval('P7D'));
        }
        $fillStartModified = $fillEndModified->sub($gapInterval);
        if($fillStartModified < $fillStart) {
            $fillStartModified=null;
            $fillEndModified=null;
        }
    }
    else {
        //The fill is newer than the gap so make the fill's startTime match the gap's startTime
        $fillStartModified = $fillStart
        ->modify('next '.$gapStart->format('D'))
        ->setTime(...explode('.', $gapStart->format('H.i.s.u')));
        if($fillStart->diff($fillStartModified)->format('%a') >= 7) {
            $fillStartModified = $fillStartModified->sub(new \DateInterval('P7D'));
        }
        $fillEndModified = $fillStartModified->add($gapInterval);
        if($fillEndModified > $fillEnd) {
            $fillStartModified=null;
            $fillEndModified=null;
        }
    }
    return [$fillStartModified, $fillEndModified];
}

 

I am trying to identify the username from a series of windows logs.  I have been using (?:User Name:|Account Name:)\s*([\S]+) and it works for examples 1-4, however I'm having problems with example 5.  Because it has two occurrences of the pattern Account Name: in the string I can only get the regex to return the first match, i.e. USER-PC$.  How can I tell regex, that if there are two Account Name: patterns in the string, or the string contains the pattern "New Logon:" then return the second Account Name: match, i.e. John.Doe?
 
eg 1 - The screen saver was invoked. Subject: Security ID: S-X-X Account Name: John.Doe Account Domain: INTERNAL Logon ID: 0xa4091 Session ID: 1
 
eg 2 - User initiated logoff: Subject: Security ID: S-X-X Account Name: John.Doe Account Domain: INTERNAL Logon ID: 0x3d95c This event is generated when a logoff is initiated. No further user-initiated activity can occur. This event can be interpreted as a logoff event.
 
eg 3 - User Logoff: User Name: John.Doe Domain: INTERNAL Logon ID: (0x0,0x458E4AB4) Logon Type: 8
 
eg 4 - Successful Network Logon: User Name: John.Doe Domain: INTERNAL Logon ID: (0x0,0x43) Logon Type: 8 Logon Process: Advapi Authentication Package: Negotiate Workstation Name: USER-PC Logon GUID: {2e483a4f-} Caller User Name: USER-PC $ Caller Domain: INTERNAL Caller Logon ID: (0x0,0x7) Caller Process ID: 4816 Transited Services: - Source Network Address: xx.xxx.xx.x Source Port: 35029
 
eg 5 - An account was successfully logged on. Subject: Security ID: S-X-X Account Name: USER-PC$ Account Domain: INTERNAL Logon ID: 0x3e7 Logon Type: 2 New Logon: Security ID: S-X-X Account Name: John.Doe Account Domain: INTERNAL Logon ID: 0xa4062 Logon GUID: {23-xx-22} Process Information: Process ID: 0x2fc Process Name: C:\Windows\System32\winlogon.exe Network Information: Workstation Name: USER-PC Source Network Address: xx.x.x.x Source Port: 0     Any help would be appreciated:)

Hello group.

I need some help with my code.

<?php
 

$a1 = array("line1"=>"1-2-3-10-14","line2"=>"1-2-3-10-34","line3"=>"1-2-7-16-35","line4"=>"1-2-3-17-19","line5"=>"2-5-11-15-32");
$a2 = array("inputnumber"=>"1-2-3-10-34");

$result = array_intersect($a1,$a2);
print_r($result);

?>

Right now, I can only search and find an exact match of all 5-Numbers. I want to code a PHP form that will take a (5-number string) as input and then compare that string against an array database of (5-number strings) to find all matching number occurrences for each “LINE 1 thru LINE 5”. 

For instance, if I were to type the 5-number string “1-2-3-10-34” as input.  The Output populated results would look like this ..

Edited February 21, 2019 by Jayfromsandiego

I'm working a membership application page for my amateur radio club. I'm currently stumped passing a variable from HTML to PHP.  The variable is called "nametag" and it's a "radio" type.

No Matter if I select 10 or 0. I still get 15 being passed to PHP. 

Any help is appreciated.

 

Thanks

-HP Garcia

Hi there im just trying to understand how to compare and output results in a table. For example lets say i have the following table:

Beans
ID
Type
Location

And say 3 records:

1
Baked
kitchen

2
Runners
Garage

3
Broad
Kitchen

I want to select only the beans that have matching locations and output the Type: Baked, Broad.

I'm trying to get my head around how to work this out, if you could nudge me in the right direction that would be excellent.

Thank you.

 

What I'm trying to do is have it match up the image file name wiht the same name as the link. Sometimes it does but sometimes obviously the image is random. Any ideas?


Code: [Select]
function spotlight($dbc){
$query = "
    SELECT
        *
    FROM
        characters
    WHERE
        characters.statusID = 1 AND characters.styleID = 1
    ORDER BY
        RAND()
    LIMIT
        1";
$result = mysqli_query($dbc, $query);
$row = mysqli_fetch_array($result);
    $shortName = $row[ 'shortName' ];
$labels = array('shortName');
    $img = array();
if($handle = opendir('images/spotlight/')) {
$count = 0;
while (false !== ($file = readdir($handle))) {
if(strlen($file) > 2){
$img[$count] = $file;
$count++;
}
}
}
echo "<a href='bio.php?shortName=" . $shortName . "'><img src='/images/spotlight/".$img[rand(0, (count($img)-1))]."' alt=Spotlight border=0 /></a>";
}

Basically i want to take an array of numbers let's say:

Code: [Select]
<?
$array1=array("1","2","3","4");
?>
Now say i reprint that same array, but the 3 is missing.

Code: [Select]
<?
$array2=array("1","2","4");
?>
How would i print what's missing from $array1 out of $array2?

Sorry if this is confusing, i'll be happy to go into details if needed.

Say i have two arrays with custom keys. What would be the easiest way to write a function that would determine if all the keys in arrayOne are in arrayTwo? The example below would return false because keys 3 and 4 are missing in arrayTwo. Any help would be much appreciate. thanks!

Code: [Select]
<?php

$arrayOne['1'] = "adg";
$arrayOne['2'] = "a4g";
$arrayOne['3'] = "346";
$arrayOne['4'] = "etwe";

$arrayTwo['1'] = "xcb";
$arrayTwo['2'] = "acbr";
$arrayTwo['6'] = "yiy";
$arrayTwo['7'] = "mmm";
?>