PHP - Output Wp Shortcode In Php Page

Hello everyone.

I need help with the following PHP APP. I am running on (Version PHP 7.2.10) I am trying to have a page table form on table.php pass the input variable of “5-Numbers” to another page called table_results.php

I want that variable string of “5-Numbers” to be compared against 4 arrays and output any duplicates found within each of those 4 lists. If nothing is found, I still want some visual output that reads “None found”.

 

Lets pretend I have the following example ..

On table.php, I typed inside my table form the 5-Numbers ..

INPUT:  2,15,37,13,28

On table_results.php, the 4 arrays to be compared against my input numbers “ 2,15,37,13,28” are ..

 

$array_A = array(2,6,8,11,14,18,24); 

$array_B = array(1,2,9,10,13,14,25,28,);  

$array_C = array(1,3,7,9,13,15,20,21,24); 

$array_D = array(4,5,12,22,23,27,28,29); 

 

So my output should read as follows below ..

OUTPUT: 

 

TABLE

COLUMN 1   COLUMN 2

ROW 1 Matches Found Results ..

ROW 2 GROUP A:            2 

ROW 3 GROUP B:             2,13,28

ROW 4 GROUP ?            13,15

ROW 5 GROUP ?            28

ROW 6 5#s Input:              2,15,37,13,28

 

Please let me know if anyone has any suggestions on how to go about it. 

Thanks.

Edited January 1, 2019 by Jayfromsandiego
Wanted to include image example

Quesion: Show each movie in the database on its own page, and give the user links in a "page 1, Page 2, Page 3" - type navigation system. Hint: Use LIMIT to control which movie is on which page. I have provided 3 files: 1st: configure DB, 2nd: insert data, 3rd: my code for the question. I would appreciate the help. I am a noob by the way.

First set up everything for DB:

<?php
//connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//create the main database if it doesn't already exist
$query = 'CREATE DATABASE IF NOT EXISTS moviesite';
mysql_query($query, $db) or die(mysql_error($db));

//make sure our recently created database is the active one
mysql_select_db('moviesite', $db) or die(mysql_error($db));

//create the movie table
$query = 'CREATE TABLE movie (
        movie_id        INTEGER UNSIGNED  NOT NULL AUTO_INCREMENT,
        movie_name      VARCHAR(255)      NOT NULL,
        movie_type      TINYINT           NOT NULL DEFAULT 0,
        movie_year      SMALLINT UNSIGNED NOT NULL DEFAULT 0,
        movie_leadactor INTEGER UNSIGNED  NOT NULL DEFAULT 0,
        movie_director  INTEGER UNSIGNED  NOT NULL DEFAULT 0,

        PRIMARY KEY (movie_id),
        KEY movie_type (movie_type, movie_year)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die (mysql_error($db));

//create the movietype table
$query = 'CREATE TABLE movietype (
        movietype_id    TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
        movietype_label VARCHAR(100)     NOT NULL,
        PRIMARY KEY (movietype_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

//create the people table
$query = 'CREATE TABLE people (
        people_id         INTEGER UNSIGNED    NOT NULL AUTO_INCREMENT,
        people_fullname   VARCHAR(255)        NOT NULL,
        people_isactor    TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
        people_isdirector TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,

        PRIMARY KEY (people_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Movie database successfully created!';
?>



********************************************************************
***********************************************************************

second file to load info into DB:



<?php
// connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//make sure you're using the correct database
mysql_select_db('moviesite', $db) or die(mysql_error($db));

// insert data into the movie table
$query = 'INSERT INTO movie
        (movie_id, movie_name, movie_type, movie_year, movie_leadactor,
        movie_director)
    VALUES
        (1, "Bruce Almighty", 5, 2003, 1, 2),
        (2, "Office Space", 5, 1999, 5, 6),
        (3, "Grand Canyon", 2, 1991, 4, 3)';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the movietype table
$query = 'INSERT INTO movietype
        (movietype_id, movietype_label)
    VALUES
        (1,"Sci Fi"),
        (2, "Drama"),
        (3, "Adventure"),
        (4, "War"),
        (5, "Comedy"),
        (6, "Horror"),
        (7, "Action"),
        (8, "Kids")';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the people table
$query  = 'INSERT INTO people
        (people_id, people_fullname, people_isactor, people_isdirector)
    VALUES
        (1, "Jim Carrey", 1, 0),
        (2, "Tom Shadyac", 0, 1),
        (3, "Lawrence Kasdan", 0, 1),
        (4, "Kevin Kline", 1, 0),
        (5, "Ron Livingston", 1, 0),
        (6, "Mike Judge", 0, 1)';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Data inserted successfully!';
?>



**************************************************************
****************************************************************

MY CODE FOR THE QUESTION:


<?php
$db = mysql_connect('localhost', 'root', '000') or
die ('Unable to connect. Check your connection parameters.');

mysql_select_db('moviesite', $db) or die(mysql_error($db));

//get our starting point for the query from the URL
if (isset($_GET['offset'])) {
   $offset = $_GET['offset'];
} else {
   $offset = 0;
}

//get the movie
$query  = 'SELECT
   movie_name, movie_year
FROM
   movie
ORDER BY
   movie_name
LIMIT ' . $offset . ' , 1';
$result = mysql_query($query, $db) or die(mysql_error($db));
$row = mysql_fetch_assoc($result);
?>
<html>
<head>
<title><?php echo $row['movie_name']; ?></title>
</head>
<body>
<table border = "1">
<tr>
<th>Movie Name</th>
<th>Year</th>
</tr><tr>
<td><?php echo $row['movie_name']; ?></td>
<td><?php echo $row['movie_year']; ?></td>
</tr>
</table>
<p>
<a href="page.php?offset=0">Page 1</a>,
<a href="page.php?offset=1">Page 2</a>,
<a href="page.php?offset=2">Page 3</a>
</p>
</body>
</html>

Team

   I tried to create csv output ( every value in double quotes) in my php using below function

if($generate_csv){
    generateCSV($custom[0]['details'], date('Y_m_d_')."check".".CSV", $detail_headers);
}

function generateCSV($data, $filename) {
  $file = fopen("/local/myloc/populated/".$filename,"w+");
  $i = 0;
  foreach ($data as $line) {
    $fields = array();
    foreach ($line as $k => $v)
    {
        $fields[$k] = $v;
    }
    if( $i === 0 )
    {
     fputcsv($file, array_keys($fields) ); // First write the headers
    }
    fputcsv($file, array_values($fields));
    $i++;
  }
  fclose($file);
}

I got below output with one issue (There is a blank at the end of each value)

Date,time,Device,lable,throughput_read,throughput_write
"11/19/2020 ","00:00 ","audigysg36s6101 ","host17 ","0,00 ","0,00 "
"11/19/2020 ","00:00 ","audigysg36s6101 ","host1 ","0,00 ","0,00 "
"11/19/2020 ","00:00 ","audigysg36s6101 ","host18 ","0,00 ","0,00 "

 

Could you please help me to resolve this issue

How do I got about outputing one row that can only hold one value? Any reason why the function below doesn't work?

Code: [Select]
<?php
include "database.php";
session_start();
$name = $_session['outname'];

function output_wins(){
$sql = 'SELECT * FROM account_info WHERE username ="' . $name .'"';
$result = mysql_query($sql);
$wins = mysql_fetch_array($result);
echo $wins['win'];
}



output_wins();

?>
Is there an easier way I can output this one row?

Hi. I found a code online but unfortunately, the data is retrieved via variables. How can i convert this code to retrieve the data from database instead. Thank you in ADVANCE!

Code: [Select]
var members = [
    ['Steven B. Ayres', '1911-1913', 'New York', 'Independent Democrat', '1861-1929'],
    ['William Augustus Ayres', '1915-1921 1923-1934', 'Kansas', 'Democratic', '1867-1952'],
    ['William Hanes Ayres', '1951-1971', 'Ohio', 'Republican', '1916-2000']
];

Hi all,

Is there a simple way to log the command output of a linux console?

This command locks up my screen. It is a screen on an Aastra IP phone.

$command = 'logsave /var/www/html/aastra/test.log ls';

shell_exec($command);


Thanks!

I have a function which is listing my directories w/ files (Images) in them.
<?php
function sortDirectory($path = 'images') {  
  $ignore = array('.', '..', 'index.php');
  $folder = array();
  $dh = @opendir($path);
  while (false !== ( $file = readdir($dh) )) {
if (!in_array($file, $ignore)) {
  if (is_dir("$path/$file")) {
$folder[$file] = sortDirectory("$path/$file");
  } else {
$folder[$file] = "$path/$file";
  }
}
  }
  closedir($dh);
  ksort($folder);
  return $folder;
}

function getDirectory($folder = array(),$level = 0) {
// Set which extensions should be approved in the XML file
  $extensions = array(  'jpg', 'JPG',  'png', 'PNG',  'gif', 'GIF',  'bmp', 'BMP');
  $spaces = str_repeat('&nbsp;', ( $level * 4));
  foreach($folder as $file=>$path) {
if (is_array($path)) {
  echo "<strong>$spaces $file</strong><br />";
  getDirectory($path, $level+1);
}
else {
if ( in_array( substr($file, -3), $extensions ) ){
  echo "$spaces <a href=\"$path\">$file</a><br />";
  }
}
  }
}

getDirectory(sortDirectory());

?>
Im trying to get it to write an xml file in this fashion
Code: [Select]
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<dir1>
    <pic>
        <image>file1.jpg</image>       
    </pic>
    <pic>
        <image>file2.jpg</image>       
    </pic>   
</dir1>

<dir2>
    <pic>
        <image>file1.jpg</image>       
    </pic>
    <pic>
        <image>file2.jpg</image>       
    </pic>   
</dir2>but I cannot seem to get a grasp on this simplexml for more than 1 directory - any help appreciated.?

hello guys..!!! am new to this phpfreak community...i hav faced some problem while getting on floating point nos addition..if i use
echo (int)((0.1+0.7))*10;
i am getting output as 7. If i remove (int), i would get output as 8..which is correct...
for any other possibilities like ((0.1+0.2))*10 am getting correct output as 3..pls guys help me on this wid proper reason....waiting for solution....

I'm not getting any errors but I"m not getting the output I'm expecting. When it gets the characterIDList values if there is a value for that field it needs to take that value then explode it and get the ID and characterName of each of the values so say the value inside of characterIDList was 2,3 then for each of those values it would find the characterName and ID of the value and be able to put each of them as a LI inside the UL.  I was hoping I could have the charactersQuery separate because I use it for the dropdown.

Code: [Select]
$newsQuery = "
    SELECT
        news.categoryID,
        news.newsTitle,
        news.newsPicture,
        news.content,
        news.characterIDList
    FROM
        news
        LEFT JOIN categories
            ON news.categoryID = categories.ID
    WHERE
        news.ID = '" . $newsID . "'";
$newsResult = mysqli_query ( $dbc, $newsQuery ); // Run The Query
echo $newsQuery;
$row = mysqli_fetch_array ( $newsResult, MYSQL_ASSOC );
$characterIDList = $row[ 'chracterIDList' ];

$characterIDList = explode(',',  $characterIDList);

foreach($characterIDList as $value){
    $charactersQuery = "
        SELECT
            ID,
            characterName
        FROM
            characters
        ORDER BY
            characters.characterName";
    $charactersResult = mysqli_query ( $dbc, $charactersQuery ); // Run The Query
}

Code: [Select]
<div class="field required">
            <label for="charactersDrop">Characters Involved</label>
            <ul id="characterList" style="list-style: none; margin-left: 195px;">
            <?php
              mysqli_data_seek( $charactersResult, 0 );
              while($row = mysqli_fetch_array ( $newsResult, MYSQL_ASSOC )) {
                if ($row['characterName'] == NULL  ) { 
                    
                } else {
             ?>
                    <li characterID="<?php echo $row['ID']; ?>" characterName="<?php echo htmlentities( $row['characterName'] ); ?>"><?php echo htmlentities($row['characterName']); ?> <a href="#">Remove</a></li>   
             <?php }} ?>
            </ul>
            <select class="dropdown" name="charactersDrop" id="charactersDrop" title="Characters Dropdown" style="margin-left: 195px;">
                <option value="">- Select -</option>
               <?php
                    mysqli_data_seek( $charactersResult, 0 );
                    while ( $row = mysqli_fetch_array ( $charactersResult, MYSQL_ASSOC ) ) { 
                        print "<option value=\"".$row['ID']."\">".$row['characterName']."</option>\r";
                    }
                ?>
            </select>
            <input type="button" value="Add Character" class="" onclick="CharactersInvolved()"/>
        </div>

Hello.

I'm looking for some help to make a script.
The script should  run a .bat file, and get the output from it. (The text from the console).

Regards
Worqy

the print_r($a)'s result is



views_handle_field_node Object

(

[view]=>view Object

(
[db_table] => views_view
[base_table] => node
[args] => Array
(
[0] => My entry 1
)

[use_ajax] =>
[result] => Array
(
[0] => stdClass Object
(
[nid] => 5
[node_title] => Title of a test entry
[node_revisions_body] =>
[node_revisions_format] => 1
[node_vid] => 5
[term_data_name] => My first test term name
[term_data_vid] => 1
[term_data_tid] => 1
[vocabulary_name] => Vocabulary 1
[node_revisions_vid] => 5
)

[1]=> stdClass Object
(
[nid] => 8
[node_title] => Title of a test entry
[node_revisions_body] =>
[node_revisions_format] => 1
[node_vid] => 5
[term_data_name] => My first test term name
[term_data_vid] => 1
[term_data_tid] => 1
[vocabulary_name] => Vocabulary 1
[node_revisions_vid] => 5
..
[2]..
..





now i want to output the [nid]=>5 and[nid]=>8.....and all the nid's value.i use this, but can't work.

$views_handle_field_node->$view->$result[]->nid. what's the correct output of it.

I have created a PHP page where the contents are pulled from DB. Is there a way that I can save the file with the output and stylesheet to PDF with a click of a button. 

Edited May 5, 2020 by ZulfadlyAshBurn
Grammer

help me.
i have an index.php file in admin folder.
this is the code inside the file:
Code: [Select]
<?php
?>

Or any other code
and i get output 0 ,
but if i echo something else then i get the string has output,

help find out what is the problam please!!!

Hey folks,

I have made a cart for buying drinks. I also made an sql database. But when I click on the email button, I receive an email but only with the id of the products. I would like to have an output with the id of the product, but also the name of the product ( the name of the column in sql is also 'name')

this is my code and you can check it out on  http://fhcs.be/cart-demo3/

thanks in advance

cart.php

<?php
// Include MySQL class
require_once('inc/mysql.class.php');
// Include database connection
require_once('inc/global.inc.php');
// Include functions
require_once('inc/functions.inc.php');
// Start the session

session_start();
// Process actions
$cart = $_SESSION['cart'];
$action = $_GET['action'];
switch ($action) {
case 'add':
if ($cart) {
$cart .= ','.$_GET['id'];
} else {
$cart = $_GET['id'];
}
break;
case 'delete':
if ($cart) {
$items = explode(',',$cart);
$newcart = '';
foreach ($items as $item) {
if ($_GET['id'] != $item) {
if ($newcart != '') {
$newcart .= ','.$item;
} else {
$newcart = $item;
}
}
}
$cart = $newcart;
}
break;
case 'update':
if ($cart) {
$newcart = '';
foreach ($_POST as $key=>$value) {
if (stristr($key,'qty')) {
$id = str_replace('qty','',$key);
$items = ($newcart != '') ? explode(',',$newcart) : explode(',',$cart);
$newcart = '';
foreach ($items as $item) {
if ($id != $item) {
if ($newcart != '') {
$newcart .= ','.$item;
} else {
$newcart = $item;
}
}
}
for ($i=1;$i<=$value;$i++) {
if ($newcart != '') {
$newcart .= ','.$id;
} else {
$newcart = $id;
}
}
}
}
}
$cart = $newcart;
break;
}
$_SESSION['cart'] = $cart;
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>PHP Shopping Cart Demo &#38;#0183; Cart</title>
<link rel="stylesheet" href="css/styles.css" />
</head>

<body>

<div id="shoppingcart">

<h1>Your Shopping Cart</h1>


<?php
echo writeShoppingCart();

?>

</div>

<div id="contents">

<h1>Please check quantities...</h1>

<?php
echo showCart();
?>

<p><a href="index.php">Back to bookshop...</a></p>

<form action="mail.php" method="post">
<input type="submit" name="sendemail" value="Email" />
<input type="hidden" name="cart" value="<?= $cart; ?>" />
</form>




</div>

</body>
</html>


mail.php

<?php


session_start();
 
if($_POST['sendemail'] == 'Email')
{
 
 
  $headers = 'From: Sender <andrej13@gmail.com>';
  mail('andrej13@gmail.com', 'Subject', $_SESSION["cart"] , $headers);
  
  
  echo 'Your mail has been sent';
}
else
{
  echo 'message not sent';
}


?>


and the functions.php

<?php
function writeShoppingCart() {
$cart = $_SESSION['cart'];
if (!$cart) {
return '<p>You have no items in your shopping cart</p>';
} else {
// Parse the cart session variable
$items = explode(',',$cart);
$s = (count($items) > 1) ? 's':'';
return '<p>You have <a href="cart.php">'.count($items).' item'.$s.' in your shopping cart</a></p>';
}
}

function showCart() {
global $db;
$cart = $_SESSION['cart'];
if ($cart) {
$items = explode(',',$cart);
$contents = array();
foreach ($items as $item) {
$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
}
$output[] = '<form action="cart.php?action=update" method="post" id="cart">';
$output[] = '<table>';
foreach ($contents as $id=>$qty) {
$sql = 'SELECT * FROM products WHERE id = '.$id;
$result = $db->query($sql);
$row = $result->fetch();
extract($row);
$output[] = '<tr>';
$output[] = '<td><a href="cart.php?action=delete&id='.$id.'" class="r">Remove</a></td>';
$output[] = '<td>'.$name.'</td>';
$output[] = '<td>&euro;'.$price.'</td>';
$output[] = '<td><input type="text" name="qty'.$id.'" value="'.$qty.'" size="3" maxlength="3" /></td>';
$output[] = '<td>&euro;'.($price * $qty).'</td>';
$total += $price * $qty;
$output[] = '</tr>';
}
$output[] = '</table>';
$output[] = '<p>Grand total: <strong>&euro;'.$total.'</strong></p>';
$output[] = '<div><button type="submit">Update cart</button></div>';
$output[] = '</form>';
} else {
$output[] = '<p>You shopping cart is empty.</p>';
}
return join('',$output);
}

?>

I don't have any output after I push the button :s I dont know how
http://fhcs.be/index3.php
Code: [Select]
<?php
// Include MySQL class
require_once('inc/mysql.class.php');
// Include database connection
require_once('inc/global.inc.php');
// Include functions

session_start();
?>
<?php if (!isset($_POST['submit'])) { ?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

        <form method="post" action="<?php echo $PHP_SELF; ?>">
        <input type="submit" value="Toon Output" name="submit"/>
         

<?php
$dranken=array()   ;
$DrinkResult=mysql_query("SELECT name,price FROM products")or die(mysql_error());

      while($DrinkRow=mysql_fetch_assoc($DrinkResult)){
         $dranken[] = $DrinkRow;

      }
echo "<table>";

    foreach ($dranken as $DrinkRow) {
$optionlist = "<select name='{$DrinkRow['name']}_aantal'>";
for  ($i=0;$i<10;++$i) {
$optionlist .= "<option value='$i'>$i</option>";
}
$optionlist .= "</select>";
echo "<tr><td>".$DrinkRow['name']." ".$DrinkRow['price']."</td>\n";
echo "<td>$optionlist</td></tr>\n";
}
echo "</table>";
?>
     

    </form>

    <?php
    }
    
    
$dranken=array()   ;
$DrinkResult=mysql_query("SELECT name,price FROM products")or die(mysql_error());

      while($DrinkRow=mysql_fetch_assoc($DrinkResult)){
         $dranken[] = $DrinkRow;

      }
echo "<table>";
    

    $totaalPrijs = 0;

    foreach ($dranken as $DrinkRow) {
        $aantal = $_POST[$DrinkRow['name'] . "_aantal"];
        if ($aantal > 0) {
            $prijsperDrank = $aantal * $DrinkRow['price'];
            echo $DrinkRow['name'] . " : " . $aantal . " Prijs: " . $prijsperDrank . "</br>";
$totaalPrijs=$totaalPrijs + $prijsperDrank; }
    
}
if($totaalPrijs>0){    
    echo " totaal: " .$totaalPrijs;}
    ?>

</html>