PHP - Format Specific Words Within A Query???

Dear All,

I would like to create a json a below format

{
    "data": [
        {
            "datetime": "2021-05-12",
            "history": [
                {
				"name": "ABC",
				"feel": 1,
				"cough": 0,
				"fever": 1,
				"headache": 1,
				"tired": 0,
				"appetite": 0,
				},
				{
				"name": "DEF",
				"feel": 1,
				"cough": 0,
				"fever": 1,
				"headache": 1,
				"tired": 0,
				"appetite": 0,
				}
            ]
        },
		 {
            "datetime": "2021-05-13",
            "history": [
                {
				"name": "ABC",
				"feel": 1,
				"cough": 0,
				"fever": 1,
				"headache": 1,
				"tired": 0,
				"appetite": 0,
				},
				{
				"name": "DEF",
				"feel": 1,
				"cough": 0,
				"fever": 1,
				"headache": 1,
				"tired": 0,
				"appetite": 0,
				}
            ]
        },
		 {
            "datetime": "2021-05-14",
            "history": [
                {
				"name": "ABC",
				"feel": 1,
				"cough": 0,
				"fever": 1,
				"headache": 1,
				"tired": 0,
				"appetite": 0,
				},
				{
				"name": "DEF",
				"feel": 1,
				"cough": 0,
				"fever": 1,
				"headache": 1,
				"tired": 0,
				"appetite": 0,
				}
            ]
        }
		
    ]
}

But I need to select database 2 time because information need to group by date

so my PHP like below

 $myArray = array();
   
    $stmt = $conn->prepare("SELECT survay_date FROM tb_feedback WHERE app_ID = ? GROUP BY CAST(survay_date AS DATE) ORDER BY survay_date DESC");
    $stmt->bind_param("s", $data->{'app_id'});
   
    $stmt->execute();
    $res = $stmt->get_result(); 

    if($res->num_rows==0){
      
      header('Content-Type: application/json');
	  $json = array();
	  $myArray['data'] = $json;
       echo json_encode($myArray);die();
    }

    while($row = $res->fetch_array(MYSQLI_ASSOC)) {
        $myArray['data'][] = array_push($row,array("A","B"));
		
		$statement = $conn->prepare("SELECT tb_register.firstname,tb_feedback.feel,tb_feedback.cough,tb_feedback.fever,tb_feedback.headache,tb_feedback.tired,tb_feedback.appetite,tb_feedback.swelling FROM tb_feedback INNER JOIN tb_register ON tb_register.id = tb_feedback.user_id WHERE tb_feedback.app_ID = ? AND tb_feedback.survay_date = ?");
		$statement->bind_param("s", $data->{'app_id'});
		$statement->bind_param("s", $row['survay_date']);
	   
		$statement->execute();
		$result = $statement->get_result(); 
		
		while($infor = $result->fetch_array(MYSQLI_ASSOC)) {
			
			$myArray['data'][] = $infor;
			
		}
		
	}
	
    header('Content-Type: application/json');
    echo json_encode($myArray);

So, How can I create the json format like that?

Hey everyone, I'm pretty new to this, not my full time job, but just something I thought I'd give a shot...

I have a database, in postgres, in which I make my query and I go fetch all the info I need.
What I need to do next is the tricky part for me.

For each line of results received, I have to output to a text file (.txt) but I have to respect a format that was given to me from the person requesting the info.

Example:
Character 1 must be G or N.
Character 2 to to 11 will be a result from my database search, which is a 10 digit string.
Character 12 to 14 must be spaces.

Another rule is:
start at character 78: input a value from my database search but it must not exceed 20 characters and if it is less then 20 character, fill the remaining with spaces.


If anyways has a code I can copy and work off of I would really appreciate it....thanks!

I have the following query:
 $getVideos = mysql_query("SELECT catergory, COUNT(catergory) as 'catCount' FROM videos GROUP BY catergory"); 

Using this in PHPMyAdmin returns the correct results of:
catergory | catCount
   0 

  |    7
   1 

  |    1
   10     |    2

How would get those results into a PHP array or what not...I have done this before but along time ago and cannot for the life of me remember how to do it.

Hopefully someone can point me in the right direction?

Regards, PaulRyan.

Hey all,

When someone clicks a link, link looks like this:

http://site/homes/edit/1?image=true

Now on the same page, I have another link, which posts to the edit method as well, but no query string passed:

http://site/homes/edit/1

I want to check if image key is set to true and basd on that, determine which view to render for the user, that is, whether to display the edit form to edit post or the image form to edit image. But by using the get array to try to grab query string:

Code: [Select]
if($_GET["image"]=="true"){


I get the following error:

Message: Undefined index: image

It appears that $_GET is not successfully grabbing the parameter.

Thanks for response.

Hi. I have an input field where a date is entered, format dd-mm-yy. I need to query the database to see if this date exists. How can I convert the date to yyyymmdd before the query?

Thanks

OK, Here is the code

$sql = "SELECT
TrialListing.listingID AS Trial, TrialClass.classID AS Class, place.place_name AS Place,
CONCAT_WS(
' ',
pedigree.pretitle,
pedigree.`Name`) AS Hound,
CONCAT_WS(
' ',
ped2.pretitle,
ped2. NAME
)AS Sire,
CONCAT_WS(
' ',
ped3.pretitle,
ped3. NAME
)AS Dam,
pedigree.Breeder,
pedigree.`Owner`,
CASE
WHEN placement.place_id < 5 THEN
TRUNCATE(TrialClass.number_of_entrants / placement.place_id,2)
WHEN placement.place_id  = 5 THEN
''
ELSE
0
END

AS Score
FROM
TrialListing
Left Join TrialClass ON TrialListing.listingID = TrialClass.listingID

JOIN placement ON placement.event_id = TrialClass.trialClassID
JOIN pedigree ON pedigree.PedigreeId = placement.hound_id
LEFT OUTER JOIN pedigree AS ped2 ON pedigree.SireId = ped2.PedigreeId
LEFT OUTER JOIN pedigree AS ped3 ON pedigree.DamId = ped3.PedigreeId
LEFT JOIN place ON place.place_id = placement.place_id

WHERE
TrialListing.listingID = 11
ORDER BY Class, FIELD(place.place_id, '1', '2', '3', '4', '0')


";      // Database Query  

$result = mysql_query("$sql");  // Database Query result

$num_rows = mysql_num_rows($result);





// Starts the table
echo "<table class=\"clubList\">\n
<tr>
<th>trialID</th>
<th>ClassID</th>
<th>Place</th>
<th>Hound</th>
<th>Sire</th>
<th>Dam</th>
<th>Score</th>

</tr>";

// Create the contents of the table.
for( $i = 0; $i < $row = mysql_fetch_array($result); $i++){




echo "<tr>\n"
        ."<td>".$row["Trial"]."</td>\n" 
        ."<td>".$row["Class"]."</td>\n" 
        ."<td>".$row["Place"]."</td>\n"  
        ."<td>".$row["Hound"]."</td>\n"  
        ."<td>".$row["Sire"]."</td>\n"                
        ."<td>".$row["Dam"]."</td>\n"
        ."<td>".$row["Score"]."</td>\n"  
        ."</tr>";}



echo "</TABLE>";


Here is the output, I added the TrialID & ClassID for informational purposes, they do not need to be displayed in the live table.

trialID ClassID Place Hound Sire Dam Score 11 1 1st Eaton Brook Tug Hill Tatonka Eaton Brook Hickety Hawk Eaton Brook Gunner's Beulah 43.00 11 1 2nd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 21.50 11 1 3rd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 14.33 11 1 4th Rail Road Spike VI Elwell's Mike Elwell's Hannah 10.75 11 1 NBQ FC Fish Creek Spike Fish Creek Bull II Fish Creek Susie [H849395] 11 2 1st Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 32.00 11 2 2nd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 16.00 11 2 3rd Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger 10.66 11 2 4th FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 8.00 11 2 NBQ FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka 11 3 1st Bojangle V Lee Otworth Half Acre's Cocoa Candy 23.00 11 3 2nd Gay Doll Gay Roll II Gay Idol 11.50 11 3 3rd Bruce's Blue Lady FC Kilsock's Blue Creek Bart Bishopville's Zippy 7.66 11 3 4th FC Pearson Creek Barbin FC Pearson Creek Barbarian FC B-Line Stubby 5.75 11 3 NBQ Sims Creek Cricket Ronnie Joe Sims Creek Tiny 11 4 1st FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 26.00 11 4 2nd FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka 13.00 11 4 3rd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 8.66 11 4 4th Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 6.50 11 4 NBQ Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger
Below is what I would like to generate. How do I word or nest the proper PHP code/loops to accomplish this?

ClassID

Place Hound Sire Dam Score 1st Eaton Brook Tug Hill Tatonka Eaton Brook Hickety Hawk Eaton Brook Gunner's Beulah 43.00 2nd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 21.50 3rd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 14.33 4th Rail Road Spike VI Elwell's Mike Elwell's Hannah 10.75 NBQ FC Fish Creek Spike Fish Creek Bull II Fish Creek Susie [H849395]

ClassID

Place Hound Sire Dam Score 1st Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 32.00 2nd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 16.00 3rd Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger 10.66 4th FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 8.00 NBQ FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka

ClassID

Place Hound Sire Dam Score 1st Bojangle V Lee Otworth Half Acre's Cocoa Candy 23.00 2nd Gay Doll Gay Roll II Gay Idol 11.50 3rd Bruce's Blue Lady FC Kilsock's Blue Creek Bart Bishopville's Zippy 7.66 4th FC Pearson Creek Barbin FC Pearson Creek Barbarian FC B-Line Stubby 5.75 NBQ Sims Creek Cricket Ronnie Joe Sims Creek Tiny

ClassID

Place Hound Sire Dam Score 1st FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 26.00 2nd FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka 13.00 3rd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 8.66 4th Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 6.50 NBQ Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger

Hello All, 
  Need an advise in finishing this task please. 
 

function convertTimeFormat($time12Hour) {
// Initialized required variable to an empty string.
		$time24Hour = ""; 

// Used explode() function to break the string into an array and stored its value in $Split variable. 
		$Split = explode(":",$time12Hour); // print_r(explode (":", $time12Hour)); => Array ( [0] => 09 [1] => 50 [2] => 08AM )

// Retrieved only "hour" from the array and stored in $Hour variable. 
		$Hour = $Split[0];   

    $Split[2] = substr($Split[2],0,2);

// Used stripos() function to find the position of the first occurrence of a string inside another string.	
		if($Hour == '12' && strpos($time12Hour,"AM")!== FALSE) {
			// Code here 
		} elseif(strpos($time12Hour,"PM")!== FALSE && $Hour != "12") {
			// code here
		}
		return  $time24Hour;
	}
	$time12Hour = "09:50:08AM";
	$result = convertTimeFormat($time12Hour);
	print_r($result); 

/*
Input : "09:50:08AM";
Output : "21:50:08PM";
*/

 

Hi all,

I am currently making a website that has e-custom functions and a back end for the client.

I want them to be able to upload images - but they need to be transparent. I do not want to leave this in the hands of the client, so I am looking at ways of using the GD library to make the change

I got no issue with the png/gif type for upload/resize function since this type already transparent background but my major problems is how to deal with jpeg/jpg image type which is their background was not a transparent...so is it possible I can change/ convert to png/gif type upon successful of uploading image...so the new final image will be png/gif type with transparent background...is it doable...I am not even sure it is possible...?

Thanks for any help..

I use the Wholesale Suite Premium Prices plugin with WooCommerce. I have 6 specific wholesale roles out of 15 that I wish to hide two specific shipping methods from being selected for the 6 exceptions. I'm just trying this on my staging server at this time using a code snippet example that I found and modified for my specific conditions. Would the following work for this purpose?

/* Hide specific shipping methods for specific wholesale roles */
add_filter( 'woocommerce_package_rates', function( $shipping_rates ) {
// User role and shipping method ID to hide for the user role
    $role_shipping_method_arr = array(
    'ws_silvia_silver' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_pst_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_tax_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_silver' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_pst_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_tax_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_gold' =>    array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_pst_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_tax_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_gold' =>    array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_pst_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_tax_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    );

    // Getting the current user role
    $curr_user = wp_get_current_user(); 
    $curr_user_data = get_userdata($current_user->ID); 

    // Wholesale Suite Roles 
    if (isset($current_user) && class_exists('WWP_Wholesale_Roles')) {
        $wwp_wholesale_roles = WWP_Wholesale_Roles::getInstance();
        $wwp_wholesale_role = $wwp_wholesale_roles->getUserWholesaleRole(); 

// Loop through the user role and shipping method pair
    foreach( $role_shipping_method_arr as $role => $shipping_methods_to_hide ) {

// Check if defined role exist in current user role or not
    if( in_array( $role, $current_user->roles) ) {

// Loop through all the shipping rates
    foreach( $shipping_rates as $shipping_method_key => $shipping_method ) {
$shipping_id = $shipping_method->get_id();

// Unset the shipping method if found
    if( in_array( $shipping_id, $shipping_methods_to_hide) ) {
unset($shipping_rates[$shipping_method_key]);
}
}
}
}
}
    return $shipping_rates;
});

Any insights as to how to accomplish this would be greatly appreciated. Lyse

: : NEW Problem

I want to replace bad words which someone has inputted into my HTML textarea, with something like [CENSORED].
Here's what I've got so far:
note: $review is the posted textarea name.
Code: [Select]

$words_text = 'badwords.txt';
$bad_words = file($words_text);
               
$good_words = str_ireplace($bad_words,'[CENSORED]',$review);
         
echo $good_words;


The thing is, if I type bad words in the textarea, I still get bad words when I echo $good_words.

I don't know why I'm getting this, any ideas

Hello dear friends,

I've an idea so let us say we have paragraph with bad words 

Code: [Select]
$para = "Hello shit oh shit what the hell this is shit day";
Now let say we create textarea

Code: [Select]
<textarea id="badword" name="badword">
</textarea>
and let us say we have database table as following

Code: [Select]
CREATE TABLE `banned` (
 `id` varchar(50) NOT NULL default '',
 `badwords` text NOT NULL,
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

consider we have connetion and can update mysql table badwords

1- now how we can enter word per line in this textarea

example we entered in this textarea per line
shit
hell
die
death

then by click on submit it stored in an database table 'banned' as

INSERT INTO `banned` VALUES ('1', 'shit,hell,die,death');


2- if we called `badwords` from table 'banned' how then can put 'shit,hell,die,death' into array so we can exclude it from $para

 
can someone please help me in this , how to store textarea per line as sperated words in database table and how then call it back as array to exclude it form our paragraph

Or

it there any other simple way doing the same 

thank you

hi,

now i have something like this:

$pizza  = "piece1 piece2 piece3 piece4";
$one_word = explode(" ", $pizza);

but i want to get 2 words together, like that:

$two_words[0]='piece1 piece2';
$two_words[1]='piece3 piece4';
$two_words[2]='piece2 piece3';
$two_words[3]='piece1 piece4';

if it's impossible with explode, then it's fine if you use some other function, i don't care as long as it works.

thank you, tastro

Hi, having a really strange problem, i have a form like this:

<form method='post' action='addcart.php'>
echo $name //prints both parts of name separated by space
<input type='hidden' value='$name' name='na'

and then in the addcart.php
echo $_POST['na']   //only prints first half of name

So for example, if $name was "Product One" when i print the value in first script it prints Product One fine but when i print in the other script it only prints "Product".  This then leads onto only half the name being copied into a database. 
I'm sure this was working fine before, not sure what the problem here is...

I'm pretty sure the problem is starring me in the face, but I can't seem to locate it.


function filter($string)
{
//swear words pulled from bannedwordlist.com
$f = fopen('../badwords.txt', 'r');
$bad_words = fread($f, filesize('../badwords.txt'));
$bad_words = explode('\n', $bad_words);

$input = strtolower($string);

foreach($bad_words as $value)
{
$string = str_replace($value, '****', $input);
}

return $string;
}


UPDATED CODE

function filter($string)
{
//swear words pulled from bannedwordlist.com
$f = fopen('../badwords.txt', 'r');
$bad_words = fread($f, filesize('../badwords.txt'));
$bad_words = explode('\n', $bad_words);

$input = strtolower($string);
$string = str_replace($bad_words, '****', $input);

return $string;
}


I've already echoed out $value in the foreeach loop, and it does correctly retrieve the bad words and put them into an array. My only problem is, the returned string is still in strtolower() form, and the words aren't censored. :/

I'm trying to pull in data using a particular word from a mysql db (it's like a search facility).

But this code only picks if the db has got the exact same word.
E.g. if fincom = "DALLS" it pulls the data only when "searchwords" has DALLS. It ignores if "searchwords" has BARBIE DALLS. How can I fix this. I need to pick all records which contains the search word 'fincom' anywhere in  searchwords.

Hope this makes scene.

$SomeVar = $_POST['fincom'];
$query = "SELECT * FROM  news_home WHERE searchwords = '".$SomeVar."' ORDER BY timestamp DESC";
$results = mysql_query($query);