|
Add the following code however when executing it does not show the page
<?php
session_name('10421941204desarrollocartera');
session_start();
if(empty($_SESSION['authenticated_user_roleid']) && !isset($_GET['type_auth'])){
header('Location: /desarrollocartera');
}
?>
<!DOCTYPE html>
<html>
<?php ?>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=2">
<link rel="shortcut icon" href="/desarrollocartera/themes/images/favicon.ico" type="image/x-icon">
<title>Fideicomisos</title>
<!--
<link rel="stylesheet" type="text/css" href="css/jquery-ui.css">
<link rel="stylesheet" type="text/css" href="css/elfinder.min.css">
<link rel="stylesheet" type="text/css" href="css/theme.css">
<!--
<script src="js/jquery.min.js"></script>
<script src="js/jquery-ui.min.js"></script>
<script src="js/elfinder.min.js"></script>
<style>
.elfinder{
width: 100%;
height: 99.7vh!important;
border: none;
}
body{
margin: 0px;
padding: 0px;
}
.elfinder-contextmenu-item .elfinder-button-icon-rm.elfinder-contextmenu-extra-icon,
.elfinder-contextmenu-item .elfinder-button-icon-link.elfinder-contextmenu-extra-icon{
display: none !important;
}
span.elfinder-navbar-root-trash {
<?php if($_SESSION['authenticated_user_roleid'] != 'H2'): ?>
display: none;
<?php endif; ?>
}
</style>
</head>
<body>
<div id="finder"></div>
<script>
var tipo = '<?php echo $_GET['tipo']; ?>';
var pago = '<?php echo $_GET['pago']; ?>';
var id = '<?php echo $_GET['contrato']; ?>';
</script>
<script src="config.js"></script>
</body>
</html>
|
|
|
|
|
Hi, I want to run Project laravel on an Linux server Aapnel panel and my project is api but I have a cors error and I want to know how the subdomain is defined on this panel is not the shape of other cpanel at all, its environment, thank you for your help
|
|
|
|
|
<?php
session_start();
ini_set('display_errors', 1);
error_reporting(E_ALL);
define("PRODUCTIMAGE",0);
define("PRODUCTCODE", 1);
define("PRODUCTNAME", 2);
define("QUANTITY", 3);
define("PRICE", 4);
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
if (isset($_POST['productcode']))
{
AddToCart();
}
else
{
$action = isset($_POST['action']) ? $_POST['action'] : '';
$value = strtoupper(substr($action, 0, 5));
switch ($value)
{
case "CONTI":
header("Location: "."products.html");
break;
case "RECAL":
RecalculateCart();
break;
case "CHECK":
header("Location: "."customer.php");
break;
}
}
}
function AddToCart()
{
$cart = isset($_SESSION['cart']) ? $_SESSION['cart'] : '';
$itemcount = isset($_SESSION['itemcount']) ? $_SESSION['itemcount'] : 0;
$productname = $_POST['productname'];
$extra_price = 0;
$productname = stripslashes($productname);
for ($i=0; $i < $itemcount; $i++)
{
if ($cart[PRODUCTNAME][$i] == $productname) {
$cart[QUANTITY][$i] = $cart[QUANTITY][$i] + intval($_POST['quantity']);
$_SESSION['cart'] = $cart;
$_SESSION['itemcount'] = $itemcount;
header("Location: "."cart.php");
exit;
}
}
$cart[PRODUCTIMAGE][$itemcount] = $_POST['productimage'];
$cart[PRODUCTCODE][$itemcount] = $_POST['productcode'];
$cart[PRODUCTNAME][$itemcount] = $_POST['productname'];
$cart[QUANTITY][$itemcount] = intval($_POST['quantity']);
$cart[PRICE][$itemcount] = $_POST['price'];
$itemcount = $itemcount + 1;
$_SESSION['cart'] = $cart;
$_SESSION['itemcount'] = $itemcount;
}
function RecalculateCart()
{
$cart = isset($_SESSION['cart']) ? $_SESSION['cart'] : '';
$itemcount = isset($_SESSION['itemcount']) ? $_SESSION['itemcount'] : 0;
for ($i=0; $i<$itemcount; $i++)
{
$quantity = $_POST['quantity'.($i)];
if (empty($quantity))
{
$quantity = 0;
}
else
if (($quantity < 0) || (!is_numeric($quantity)))
{
$quantity = 0;
}
$cart[QUANTITY][$i] = intval($quantity);
}
for ($j=0; $j<$itemcount; $j++)
{
$quantity = $cart[QUANTITY][$j];
if ($quantity == 0)
{
$itemcount--;
$curitem = $j;
while(($curitem+1) < count($cart[0]))
{
for ($k=0; $k<4; $k++)
{
$cart[$k][$curitem] = $cart[$k][$curitem+1];
$cart[$k][$curitem+1] = '';
}
$curitem++;
}
}
}
$_SESSION['itemcount'] = $itemcount;
$_SESSION['cart'] = $cart;
}
?>
modified 29-Apr-22 3:30am.
|
|
|
|
|
Probably by adding some numbers together. But you need to add more specific details to your question.
|
|
|
|
|
Bonjour, j'ai un soucis avec les privilèges utilisateurs (AUCUN, EDITEUR, ADMINISTRATEUR).
C'est à dire, en fonction des identifiants rentrés, on a accès à certaines liens du menu.
et malheureusement chez moi le menu ne s'affiche pas. Besoin d'aide, merci d'avance.
voici mon code :
class/Usermanager.php
class Usermanager {
private $db;
public function __construct($db) {
$this->setDb($db);
}
public function setDb(PDO $dbh) {
return $this->db = $dbh;
}
public function displayMenu($user_role_id) {
try {
$sql = 'SELECT A.name, A.slug
FROM user_action AS A
INNER JOIN user_permission AS P
ON A.actionID = P.action_id
AND P.min_role_id < :user_role_id';
$stmnt = $this->db->prepare($sql);
$stmnt->execute(array(
':user_role_id' => $user_role_id
));
while($row = $stmnt->fetch(PDO::FETCH_ASSOC)) {
$menu_data[] = $row;
}
if(isset($menu_data)) {
return $menu_data;
}
else {
return false;
}
}
catch(PDOException $e) {
echo MSG_ERROR . $e->getMessage();
}
}
public function checkUserPermission($action_slug, $user_role_id) {
try {
$sql = 'SELECT P.action_id, P.min_role_id
FROM user_permission AS P
INNER JOIN user_action AS A
ON A.slug = :action_slug
AND P.action_id = A.actionID';
$stmnt = $this->db->prepare($sql);
$stmnt->execute(array(
':action_slug' => $action_slug
));
while($row = $stmnt->fetch(PDO::FETCH_ASSOC)) {
$min_role_id = $row['P.min_role_id'];
if($min_role_id > $user_role_id) {
return $min_role_id;
}
}
}
catch(PDOException $e) {
echo MSG_ERROR . $e->getMessage();
}
}
}
process/process-display-menu.php
$username_form = isset($_SESSION['username_form']) ? $_SESSION['username_form'] : NULL;
$manager = new Usermanager($db);
$menu_items = $manager->displayMenu($username_form);
$menu_html = '';
if(!empty($menu_items)) {
foreach($menu_items as $menu_item) {
$name = $menu_item['name'];
$slug = $menu_item['slug'];
$menu_html .= '<li><a href="' . $slug . '.php">' . $name . '</a></li>' . "\n";
}
}
process/process-user-permission.php
$action_slug = substr($filename, 0, 4);
$username_form = isset($_SESSION['username_form']) ? $_SESSION['username_form'] : NULL;
$manager = new Usermanager($db);
$userPermission = $manager->checkUserPermission($action_slug, $username_form);
if($userPermission === false) {
echo 'Erreur. Cette page n\'existe pas.';
exit;
}
admin/menu.php
require('../process/process-display-menu.php');
<ul class="menu">
<?php echo $menu_html; ?>
<li><a href="../index.php">Site web</a></li>
<li><a href="logout.php">Déconnexion</a></li>
</ul>
admin/index.php
require('../include/inc-connexion.php');
require('../include/inc-config.php');
require('../include/inc-identification-user.php');
$filename = basename( __FILE__ );
require('../process/process-user-permission.php');
require('menu.php');
|
|
|
|
|
I have an input box and a search button, when someone enter some query in input box and press the button then I want to show the results from google on that page. Is it possible to do it with JavaScript or PHP or any other language?
|
|
|
|
|
i have three condition like if(isset($_POST['search']) & !empty($_POST['searchdata']) ) and if(isset($_POST['search']) & !empty($_POST['seardate']) ) and else . these are searching input text field name searchdata and searchdate and esle if empty.
when first condition is true pagination is aslo create according to is t condition similarly on both two condition pagination is created.but confusion when i click on pagination cursor goes to else condition and again all page is shown in pagination.what i can doing wrong... i want if pagination is created in first condition and i click on pagination the cursor should be goes to first condition and the pagination is created upon second condition and i click it should go to second part not to else.
|
|
|
|
|
There's a secret error somewhere in your secret code. You need to fix that.
Seriously, how do you expect anyone to be able to help you fix code we cannot see running on a server we cannot access, based solely on a brief description of the behaviour?
Edit your message and provide the relevant parts of your code, and a clear description of what the problem is, what you have tried, and where you are stuck. Remember to include the full details of any errors.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
<?php
include('includes/checklogin.php');
check_login();
?>
<!DOCTYPE html>
<html lang="en">
<?php @include("includes/head.php");?>
<body>
<div class="container-scroller">
<!-- partial:../../partials/_navbar.html -->
<?php @include("includes/header.php");?>
<!-- partial -->
<div class="container-fluid page-body-wrapper">
<!-- partial:../../partials/_sidebar.html -->
<?php @include("includes/sidebar.php");?>
<!-- partial -->
<div class="main-panel">
<div class="content-wrapper">
<div class="row">
<div class="col-lg-12 grid-margin stretch-card">
<div class="card">
<!-- start modal -->
<div id="editData5" class="modal fade">
<div class="modal-dialog modal-lg">
<div class="modal-content" >
<div class="modal-header" >
<h5 class="modal-title" >View Visitor details</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body" id="info_update5">
<?php @include("view_visitor_details.php");?>
</div>
<div class="modal-footer ">
<button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
<!-- /.modal -->
</div>
<h4 class="new-title">View Visitor details</h4>
<!-- end modal -->
<div class="table-responsive p-3" style="margin-top: -15px;">
<table class="content-table" id="dataTableHover">
<thead>
<tr>
<th class="text-center">No</th>
<th class="text-center">Full Name</th>
<th class="text-center">Card#</th>
<th class="text-center">Department</th>
<th class="text-center">Facility Visit</th>
<th class="text-center">Status</th>
<th class="text-center">Reg Date</th>
<th class="text-center" style="width: 15%;">Action</th>
</tr>
</thead>
<tbody>
<?php
if(isset($_POST['search']) & !empty($_POST['searchdata']) )
{
session_start();
$pdf_data =$_POST['searchdata'];
$_SESSION['pdf-data']= $pdf_data;
$sdata=$_POST['searchdata'];
$limit=10;
if(isset($_GET['page1']))
{
$page=$_GET['page1'];
$cnt=(($page-1)*$limit) + 1;
}
else
{
$page=1;
$cnt=1;
}
$offset = ($page-1)*$limit;
?>
<h4 align="center">Result against "<?php echo $sdata;?>" keyword </h4>
<?php
$query="select * from tblvisitor where FullName like '%$sdata%'||MobileNumber like '$sdata%'";
$sql_run=mysqli_query($connection,$query);
$num_rows = mysqli_affected_rows( $connection );
$cnt=1;
while ($row=mysqli_fetch_array($sql_run))
{
?>
<tr>
<td class="text-center"><?php echo ($cnt);?></td>
<td class="text-center"><?php echo $row['FullName'];?></td>
<td class="text-center"><?php echo $row['Cardno'] ;?></td>
<td class="text-center"><?php echo $row['Deptartment'] ;?></td>
<td class="text-center"><?php echo $row['Facility'] ;?></td>
<td class="text-center"><?php echo $row['Status'];?></td>
<td class="text-center"><?php echo date ("d-m-Y", strtotime($row['EnterDate']) );?></td>
<td class=" text-center">
<a href="#" class=" edit_data5" id="<?php echo $row['ID'] ?>" title="click to view"> class="mdi mdi-eye"></a>
</td>
</tr>
<?php
$cnt=$cnt+1;
}}
elseif (isset($_POST['search']) & !empty($_POST['date-search'])) {
echo "elseif for pagnation of data wise search is started" ;
session_start();
$sdata=$_POST['date-search'];
$_SESSION['pdf-newdata']= $sdata;
?>
<h4 align="center">Result against "<?php echo date ('d-m-Y', strtotime($sdata));?>" keyword </h4>
<?php
$limit=10;
if(isset($_GET['page']))
{
$page=$_GET['page'];
$cnt=(($page-1)*$limit) + 1;
}
else
{
$page=1;
$cnt=1;
}
$offset = ($page-1)*$limit;
$new_date=date ('d-m-Y', strtotime($sdata));
echo $new_date;
$query="select * from tblvisitor where date_format(enterdate,'%Y-%m-%d')=date('$sdata') LIMIT {$offset},{$limit}";
$sql_run=mysqli_query($connection,$query);
$num_rows = mysqli_affected_rows( $connection );
$cnt=1;
while ($row=mysqli_fetch_array($sql_run))
{
?>
<tr>
<td class="text-center"><?php echo ($cnt);?></td>
<td class="text-center"><?php echo $row['FullName'];?></td>
<td class="text-center"><?php echo $row['Cardno'] ;?></td>
<td class="text-center"><?php echo $row['Deptartment'] ;?></td>
<td class="text-center"><?php echo $row['Facility'] ;?></td>
<td class="text-center"><?php echo $row['Status'];?></td>
<td class="text-center"><?php echo date ("d-m-Y", strtotime($row['EnterDate']) );?></td>
<td class=" text-center">
<a href="#" class=" edit_data5" id="<?php echo $row['ID'] ?>" title="click to view"> class="mdi mdi-eye"></a>
</td>
</tr>
<?php
$cnt=$cnt+1;
}}
else { ?>
<?php
echo "after pagantion else if is started";
session_start();
$pdf_data =$_POST['searchdata'];
$_SESSION['pdf-data']= $pdf_data;
$sdata=$_POST['date-search'];
$_SESSION['pdf-newdata']= $sdata;
$limit=10;
if(isset($_GET['page']))
{
$page=$_GET['page'];
$cnt=(($page-1)*$limit) + 1;
}
else
{
$page=1;
$cnt=1;
}
$offset = ($page-1)*$limit;
$connection = mysqli_connect("localhost","root","","cvdb");
$query="SELECT * from tblvisitor ORDER BY id DESC LIMIT {$offset},{$limit}" ;
$sql_run=mysqli_query($connection,$query);
$num_rows = mysqli_affected_rows( $connection );
while ($row=mysqli_fetch_array($sql_run)) {
?>
<tr>
<td class="text-center"><?php echo ($cnt);?></td>
<td class="text-center"><?php echo $row['FullName'];?></td>
<td class="text-center"><?php echo $row['Cardno'] ;?></td>
<td class="text-center"><?php echo $row['Deptartment'] ;?></td>
<td class="text-center"><?php echo $row['Facility'] ;?></td>
<td class="text-center"><?php echo $row['Status'];?></td>
<td class="text-center"><?php echo date ("d-m-Y", strtotime($row['EnterDate']) );?></td>
<td class=" text-center">
<a href="#" class=" edit_data5" id="<?php echo $row['ID'] ?>" title="click to view"> class="mdi mdi-eye"></a>
</td>
</tr>
<?php
$cnt=$cnt+1;
$tot_rec=$cnt;
}
} ?>
</tbody>
</table>
<?php
if(isset($_POST['search']) & !empty($_POST['searchdata']) )
{
echo "pagntion mobile and name";
$connection2 = mysqli_connect("localhost","root","","cvdb");
$query2="select * from tblvisitor where FullName like '%$sdata%'||MobileNumber like '$sdata%' " ;
$sql_run2=mysqli_query($connection2,$query2);
$num_rows2 = mysqli_affected_rows( $connection2 );
echo $num_rows2;
echo '<ul class="pagination pagination-sm">';
if ($page>1)
{
echo '<li><a href="manage_visitor.php?page='.($page - 1).'" class="page-link" >Prev</a></li>';
}
if (mysqli_num_rows($sql_run2)>0 )
{
$total_record = mysqli_num_rows($sql_run2);
$total_pages = ceil($total_record/$limit);
for ($i=1; $i<=$total_pages;$i++)
{
if ($i == $page)
{
$active="page-item active";
}
else
{
$active="";
}
echo '<li class="'.$active.'" ><a class="page-link" href="manage_visitor.php?page1='.$i.'">'.$i.'</a></li>';
}
if ( $total_pages>$page)
{
echo '<li><a href="manage_visitor.php?page='.($page + 1).'" class="page-link" >Next</a></li>';
}
echo '</ul>';
}
}
elseif (isset($_POST['search']) & !empty($_POST['date-search']))
{
echo "pagnation date wise search " ;
$connection2 = mysqli_connect("localhost","root","","cvdb");
$query2="select * from tblvisitor where date_format(enterdate,'%Y-%m-%d')=date('$sdata') " ;
$sql_run2=mysqli_query($connection2,$query2);
$num_rows2 = mysqli_affected_rows( $connection2 );
echo $num_rows2;
echo '<ul class="pagination pagination-sm">';
if ($page>1)
{
echo '<li><a href="manage_visitor.php?page='.($page - 1).'" class="page-link" >Prev</a></li>';
}
if (mysqli_num_rows($sql_run2)>0 )
{
$total_record = mysqli_num_rows($sql_run2);
$total_pages = ceil($total_record/$limit);
for ($i=1; $i<=$total_pages;$i++)
{
if ($i == $page)
{
$active="page-item active";
}
else
{
$active="";
}
echo '<li class="'.$active.'" ><a class="page-link" href="manage_visitor.php?page='.$i.'">'.$i.'</a></li>';
}
if ( $total_pages>$page)
{
echo '<li><a href="manage_visitor.php?page='.($page + 1).'" class="page-link" >Next</a></li>';
}
echo '</ul>';
}
}
else
{
echo "else pagntion no search criterai ";
$connection1 = mysqli_connect("localhost","root","","cvdb");
$query1="SELECT * from tblvisitor ORDER BY id DESC " ;
$sql_run1=mysqli_query($connection,$query1);
$num_rows1 = mysqli_affected_rows( $connection );
echo '<ul class="pagination pagination-sm">';
if ($page>1)
{
echo '<li><a href="manage_visitor.php?page='.($page - 1).'" class="page-link" >Prev</a></li>';
}
if (mysqli_num_rows($sql_run1)>0 )
{
$total_record = mysqli_num_rows($sql_run1);
$total_pages = ceil($total_record/$limit);
for ($i=1; $i<=$total_pages;$i++)
{
if ($i == $page)
{
$active="page-item active";
}
else
{
$active="";
}
echo '<li class="'.$active.'" ><a class="page-link" href="manage_visitor.php?page='.$i.'">'.$i.'</a></li>';
}
if ( $total_pages>$page)
{
echo '<li><a href="manage_visitor.php?page='.($page + 1).'" class="page-link" >Next</a></li>';
}
echo '</ul>';
}
}
?>
</div>
<!-- <li class="page-item active" aria-current="page">-->
</div>
</div>
</div>
</div>
<!-- content-wrapper ends -->
<!-- partial:../../partials/_footer.html -->
<?php @include("includes/footer.php");?>
<!-- partial -->
</div>
<!-- main-panel ends -->
</div>
<!-- page-body-wrapper ends -->
</div>
<!-- container-scroller -->
<?php @include("includes/foot.php");?>
<!-- End custom js for this page -->
<script type="text/javascript">
$(document).ready(function(){
$(document).on('click','.edit_data5',function(){
var edit_id5=$(this).attr('id');
$.ajax({
url:"view_visitor_details.php",
type:"post",
data:{edit_id5:edit_id5},
success:function(data){
$("#info_update5").html(data);
$("#editData5").modal('show');
}
});
});
});
</script>
</body>
</html>
|
|
|
|
|
When we install Ubuntu Server all we get is terminal only access. I admit we can install necessary GUI like KDE, GNome etc.
But my concern is whether there would be any security concern to be taken care of when installing anything like this for an Ubuntu Server Azure or AWS? Because I guess with a GUI we also need to expose ports for RDP unlike Private/Public key using Putty.
|
|
|
|
|
mysqli_num_rows(): Argument #1 ($result) must be of type mysqli_result, bool given in C:\xampp\htdocs\binemorg\required\op_lib.php:689 Stack trace: #0 C:\xampp\htdocs\binemorg\required\op_lib.php(689): mysqli_num_rows(false) #1 C:\xampp\htdocs\binemorg\required\op_lib.php(277): get_multi_data('employee_attend...', Array, ' order by id de...') #2 C:\xampp\htdocs\binemorg\employee_attendance.php(8): insert_row('employee_attend...') #3 {main} thrown in C:\xampp\htdocs\binemorg\required\op_lib.php on line 689
|
|
|
|
|
Paste the start of your error message into Google, or your preferred search engine, and you will find the hundreds of times this exact question has been asked before.
The answer hasn't changed: mysql_query[^] returns false if the query fails. You need to test for that before trying to count the number of rows.
As to why your query failed, that's up to you. You haven't shown any code, nor the structure of your database, so nobody can tell you what the problem with your query is.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
need to add date in the file name into outfile caluse below please suggest
SET @outpath = "/var/lib/mysql-files/";
SET @outfile = (SELECT NOW());
SET @outextension = "_StepCount.csv";
SET @SQL := CONCAT("Select Concat(ifnull(First_Name,'')," ",ifnull(Middle_Name,'')," ",ifnull(Last_name,'')) AS Name, u.email from users",@outpath,@outfile,@outextension ) ;
PREPARE stmt FROM @SQL;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
|
|
|
|
|
$offline = $odb->query("SELECT COUNT(*) FROM bots WHERE (UNIX_TIMESTAMP()-time)>20")->fetch()[0];
$offliner $offline->fetchColumn();
|
|
|
|
|
I want to solve a PHP issue
I have a db with 2 tables: first one is "document":
id | title |
================================
1 | equations |
2 | great |
3 | painting |
second one is "pic":
id | doc_id | description
===============================================
1 | 1 | "mathematics"
2 | 1 | "physic"
3 | 2 | "litterature"
4 | 2 | "art"
the "doc_id" is a foreign key, related to the id of the table "document"
this is my question: I'm trying to print for each title, all the descriptions related to it, example:
for the title "equations" , the foreign key related to it, is "doc_id =1"
wich means for "equations" i will print "matematics" and "physic"
the final table printed using PHP and SQL, on my browser, should be:
| tiltle | description
===============================================
| equations | mathematics, physic
| great | litterature , art
| painting |
Here's my code:
<pre><?php
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "doc-pic";
$conn = mysqli_connect($servername, $username, $password, $dbname);
$sql = "SELECT * FROM pic LEFT JOIN document ON pic.doc_id=document.id";
$result = mysqli_query($conn, $sql);
$sql1 = "SELECT title from document";
$result1 = mysqli_query($conn, $sql1);
?>
<table>
<?php
if (mysqli_num_rows($result1) > 0)
while($row = mysqli_fetch_array($result1)){?>
<tr>
<td><?php echo $row["title"]; ?></td>
</tr>
<?php if (mysqli_num_rows($result) > 0 )
while($row = mysqli_fetch_array($result)){
?>
<tr>
<td><?php echo $row["doc_id"]; ?></td>
<td><?php echo $row["description"]; ?></td>
</td>
</tr>
</td>
<?php }
} ?>
thanks in advance
|
|
|
|
|
|
<pre>I have an issue while calculating the column-like bank statement. actually, I am trying to calculate Opening Balance/today In /today Out / Closing Bal in MySQL PHP. I have two tables. material_infor `IN +` entry and material_approvefor `OUT -`. I am considering my opening balance was `123`.
I am new in PHP and I am here using Union All function. Please help me to create the function for getting Opening / In today / out today/closing calculation in my code.
`table- material_in`
| id | components_key | insert_date | credit |
|------|----------------|-------------|-------------|
| 1 | 12345 | 2021-04-16 | 100 |
| 2 | 12345 | 2021-04-16 | 50 |
`table- material_approve`
| id | components_key | insert_date | debit |
|------|----------------|-------------|-------------|
| 1 | 12345 | 2021-04-16 | 30 |
| 2 | 12345 | 2021-04-16 | 2 |
<pre>I am trying the code -
SELECT
`u`.`component_key`,
`u`.`insert_date`,
`u`.`transaction_qty`
FROM
(
SELECT
`components_key` AS `component_key`,
`insert_date`,
`credit` AS `transaction_qty`
FROM
`material_in`
UNION ALL
SELECT
`components_key`,
`insert_date`,
`debit` AS `transaction_qty`
FROM
`material_approve`
) u
WHERE
`u`.`component_key` = '12345'
ORDER BY
`u`.`insert_date`
DESC
the output comes -
| components_key | insert_date | transaction_qty|
|-------------|-------------|------------|
| 12345 | 2021-04-16 | 100 |
| 12345 | 2021-04-16 | 50 |
| 12345 | 2021-04-16 | 30 |
| 12345 | 2021-04-16 | 2 |
`output will be-`
| components_key | insert_date | openbal| today_in | today_out | closebal
|-----------|-------------|-------------|----------|-----------|---------|
|12345 | 2021-04-16 | 123 | 100 | 30 | 193 |
|12345 | 2021-04-16 | 193 | 243 | 2 | 241 |
|
|
|
|
|
This is not a php issue. This is Mysql.
Where are you stuck?
|
|
|
|
|
I was using netbeans for php development before, now VSCode.
My question is why every time I run / load a page, VSCode opens a new blank window... even though VScode is already open... why!? It is true even when I am not debugging!
Even when I run the most basic code to debug,
<?php
phpinfo();
?>
it always opens a new VS Code Window (Untitled-1). Then, let say I press Reload, it again opens the same blank screen.
I am using "PHP Debug" as a extension, and my launch.json is:
{
"version": "0.2.0",
"configurations": [
{
"name": "Listen for Xdebug",
"type": "php",
"request": "launch",
"port": 9000
}
]
}
I do not want to open a new vs window each page I debug. How to fix that?
|
|
|
|
|
When you run a website from VS Code it opens the browser? Is that what you are asking about?
|
|
|
|
|
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\phs\check.php on line
|
|
|
|
|
Pasting your error message into Google gives 211,000 results where other people have asked exactly the same question:
mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given - Google Search[^]
Or you could check the documentation:
Returns false on failure. For successful queries which produce a result set, such as SELECT, SHOW, DESCRIBE or EXPLAIN, mysqli_query() will return a mysqli_result object. For other successful queries, mysqli_query() will return true.
So either your query is failing, or it doesn't return a result set.
We can't tell you which, since you haven't shown us any of your code.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
$marks2 = [
"student1" =>
[
"Physics" => 58,
"Chemistry" => 64,
"Biology" => 83
],
"student2" =>
[
"Physics"=> 68,
"Chemistry" => 84,
"Biology" => 82
],
"student3" =>
[
"Physics"=> 69,
"Chemistry" => 84,
"Biology" => 89
]];
|
|
|
|
|
What language is this supposed to be? And exactly what do you mean by "echo the numbers" ?
If it is PHP then see PHP: list - Manual[^].
|
|
|
|
|
I would to import csv products to mysql using below codes but i don't know what framework to use
the data is large more than 100000 products
<?php
namespace App\Console\Commands;
use Illuminate\Console\Command;
use PDO;
class ImportProducts extends Command
{
protected $signature = 'import:products';
protected $description = 'Imports products into database';
public function __construct()
{
parent::__construct();
}
public function handle()
{
$contents = file_get_contents('products.csv');
$lines = explode("\n", $contents);
$i = 0;
foreach ($lines as $line) {
$fields = explode(';', $line);
$pdo = new PDO('mysql:dbname=coding_challenge;host=172.0.0.1;port=3306', 'root', 'secret');
$query = $pdo->prepare("SELECT COUNT(*) AS c from products WHERE id=?");
$result = $query->execute([$fields[0]]);
if($query->rowCount()) {
$pdo->query('DELETE FROM products WHERE id = "' . $fields[0] . '"');
print('Deleted existed product to be updated.');
}
$query = $pdo->prepare('INSERT INTO products (id, name, sku,status,variations, price, currency) VALUES (?, ?, ?, ? , ? , ?, ?)');
$result = $query->execute([$fields[0], ($fields[4] ?? ''), ($fields[5] ?? ''), ($fields[6] ?? ''), ($fields[9] ?? ''), ($fields[10] ?? '') ]);
$i++;
}
die('Updated ' . $i . ' products.');
}
}
<?php
namespace App\Console;
use App\Console\Commands\ImportProducts;
use Illuminate\Console\Scheduling\Schedule;
use Illuminate\Foundation\Console\Kernel as ConsoleKernel;
class Kernel extends ConsoleKernel
{
protected $commands = [
ImportProducts::class,
];
protected function schedule(Schedule $schedule)
{
}
protected function commands()
{
$this->load(__DIR__.'/Commands');
require base_path('routes/console.php');
}
}
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
