rjusman90

here is the normal rows coming  i want to show the group by product name with the count of store as the below picture  here are mysql query SELECT i.barcode, i.name, u.company_name, COUNT(i.id) AS IQTY, COUNT(U.id) AS UQTY FROM inventory i, USER u

How to create a new column in wordpress woocommerce orders page where I can edit really fast (without opening a new page or anything) and write a personal note about that order. See the attachment to understand more. I need it fast

One additional primary search function. One other feature that we would like to include – if it can be done relatively easily - is that if someone enters in any location description (Zip, City Name, State Name) right after the main USMarriage.org URL name and a forward slash (such as …

> this is php code for get value while ($row = $activeRiders->fetch(PDO::FETCH_ASSOC)){ $rider_name = $row['RiderName']; $longitude = $row['CurrentLongitude']; $latitude = $row['CurrentLatitude']; $locations[]=array( $rider_name, $latitude, $longitude ); } $markers = json_encode( $locations ); > Jquery function $(document).ready(function() { $('#map').height($('.page-container').height()); $( window ).resize(function() { $('#map').height($('.page-container').height()); }); <?php echo "var markers=$markers;\n"; ?> > …

I am quite new to JS and AJAX and I am having a hard time understanding what the other person has implemented and how I can get it to function properly. this is my login CI code that is working perfectly, but now i want to do it with ajax …

i am doing this in all my Controllers for Menu But i want to do that i give it once in core folder of CI Any Suggestion ? $data['cms_menus']=$this->database_model->GetRecords('cms_menus',false, array('FKMenuID'=>null)); foreach ($data['cms_menus'] as $key => $datas){ $data['cms_menus'][$key]['childs']=$this->database_model->GetRecords('cms_menus',false, array('FKMenuID'=> $datas['PKMenuID']));} `

<ul class="sf-menu"> <?php $menu_query ="SELECT * "; $menu_query .="FROM `menu`"; $menu_query .="WHERE `Status` = 'Enabled'"; $menu_query .="AND `ParentMenuID` = '0'"; $menu_result = mysqli_query($connection,$menu_query); while($row = mysqli_fetch_array($menu_result,MYSQLI_ASSOC)){ $PageID=$row['PageID']; $ID=$row['ID']; $LW=$row["LinkWidth"]; $menu_qry_for_page ="SELECT * "; $menu_qry_for_page .="FROM `page`"; $menu_qry_for_page .="WHERE `ID` = '$PageID'"; $menu_qry_for_sub ="SELECT * "; $menu_qry_for_sub .="FROM `menu`"; $menu_qry_for_sub .="WHERE …

<?php echo "<form action='' method=\"post\">"; echo "<table border='1'> <tr class='' > <th> P.Name </th> <th> P.Size </th> <th> P.Quantity </th> <th> P.Price </th> <th> P.Delete </th> </tr>"; $query ="SELECT * FROM `order_detail` WHERE `orderID` = $viewID "; $result=mysqli_query($connection,$query); while($row=mysqli_fetch_array($result,MYSQL_ASSOC)){ $Id=$row['ID']; echo "<tr>"; echo "<td> <input type=\"text\" name=product_name value=\"$row[prodName]\"> </td>"; echo …

want to minus the quantity when click delete if cart qty is more then 1 //remove item from shopping cart if(isset($_GET["removep"]) && isset($_GET["return_url"]) && isset($_SESSION["products"])){ $product_code = $_GET["removep"]; //get the product code to remove $product_s = $_GET["removes"]; //get the product size to remove $return_url = base64_decode($_GET["return_url"]); //get return url foreach …

update code if(isset($_POST["type"]) && $_POST["type"]=='add') { $product_id = (int) $_POST["product_id"]; $product_qty = (int) $_POST["product_qty"]; //product code $product_size_id = $_POST["product_size"]; //product size $prosize=mysqli_query($connection,"SELECT * FROM size where SizeID = $product_size_id"); $prosizename=mysqli_fetch_array($prosize,MYSQLI_ASSOC); $product_size=$prosizename['Name']; if(isset($product_size_id)){ $product_size=$prosizename['Name']; }else{ $product_size="default"; } $return_url = base64_decode($_POST["return_url"]); //return url //MySqli query - get details of item from db …

<?php require_once("../includes/session.php");?> <?php require_once("../includes/connection.php");?> <?php require_once("../includes/function.php");?> <?php confirm_logged_in();?> <?php require_once("../includes/validation_functions.php");?> <?php if(isset($_POST['submit'])){ //process the form // often there are form values in $_POST $product_name = mysql_prep($_POST["product_name"]); $product_amount = (int) $_POST["product_amount"]; $visible = (int) $_POST["visible"]; foreach($_FILES['files']['tmp_name'] as $key => $tmp_name ){ $file_tmp =$_FILES['files']['tmp_name'][$key]; $uploaded_dir = "images/"; $filename = $_FILES['files']['name'][$key]; $path = …

this is my login code <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <?php session_start(); $year = time() + 31536000; if(isset($_POST['remember'])) { setcookie('remember_me', $_POST['email'], $year); setcookie('remember_me2', $_POST['pass'], $year); } elseif(!isset($_POST['remember'])) { if(isset($_COOKIE['remember_me'])) { $past = time() - 100; setcookie(remember_me, gone, $past); } } ?> <head> <link rel="stylesheet" href="css/validationEngine.jquery.css" …

this is my SESSION code i want to make function of it is this posible? i am new in php i want your help please guide me <?php include "connection.php"; $result = mysql_query("SELECT * FROM new WHERE Email='" . $_POST['email'] . "' and Password = '". $_POST['pass']."'"); $row = mysql_fetch_array($result); …

I HAVE ONE FORM IN THIS I AM INSERTING AND UPDATIONG BOTH, I WANT TO RETAIN the value of combox box when php validations occurs <td>Page Id</td> <td><select name='pageID' class="select"> <option value='0' >select any page</option> <?php $sql10 = "SELECT ID,Title FROM page"; $val=$PageId?:''; $rs = mysql_query($sql10) or die(mysql_error()); while($row = …

<?php include"header.php"; if(empty($_SESSION['UserName'])){ header("Location: login.php"); exit;} $start=0; $limit=5; $page=''; $tbl_name="menu"; $targetpage = "menu.php"; //your file name (the name of this file) if(isset($_POST['fullname'])){ $term=$_POST['fullname'];} if(isset($_GET['page'])){ $page=$_GET['page']; $start=($page-1)*$limit; } { if(isset($_POST['Submit'])){ $query=mysql_query ("select * from $tbl_name where MenuName like '%$_REQUEST[fullname]%' LIMIT $start, $limit"); $search_num_rows = mysql_num_rows($query); echo "<div class='main'>"; echo"Found " .$search_num_rows. …

want to hide insert and edit form while show all date and if we do edit/insert hide date which are showing this is my code i am the beginer so i want your help <?php include 'header.php';//caling header if(empty($_SESSION['UserName'])){ header("Location: login.php"); exit;} $start=0; $limit=10; $page=''; $tbl_name="users"; $targetpage = "users.php"; //your …

<?php session_start(); ?> error_reporting(E_PARSE); include "connection.php"; $User_ID=$_SESSION['UserId']; $query = mysql_query("SELECT * FROM Users WHERE UserID='$User_ID'"); $row = mysql_fetch_array($query); $filename=$row['PicUrl']; $username=$row['UserName']; $fName=$row['FirstName']; if(isset($_SESSION["UserName"])){ if(!empty($filename)){echo '<img src="'.$filename.'" align="left"width="150px" height="100px"/>';} echo $fName; echo"<li><a href='logout.php'>Click here to Logout.</a></li>"; echo"<li><a href='user_update.php'>edit your account detail</li>"; } if(empty($_SESSION['UserName'])){ echo"<li><a href='login.php'>login</a></li>"; echo"<li><a href='register.php'>Sign Up</li>"; } ?> </li> </ul> …

$newq=mysql_query("SELECT * from userrights WHERE UserId=$Id"); $array=array(); $r1=mysql_fetch_array($newq); $menuid=$r1['MenuId']; <select name="page[]" multiple="multiple" size="5" > <option disabled="disabled" value="">Choose one</option> <?php $query1=mysql_query("SELECT * FROM adminmenu"); while($row1=mysql_fetch_array($query1)){ $selected = ($menuid == $row1['MenuId'] ? 'selected="selected"' : ''); echo"<option value='$row1[MenuId]' $selected >".$row1['MenuName']."</option>"; } ?> </select>

<html> <body> <div id="content"> <style> .current { padding: 2px 5px 2px 5px; margin: 2px; border: 1px solid #000099; font-weight: bold; background-color: #000099; color: #FFF; } li { display:inline-block } </style> <?php include"connection.php"; $start=0; $limit=5; $page=''; if(isset($_POST['fullname'])){ $term=$_POST['fullname'];} if(isset($_GET['page'])){ $page=$_GET['page']; $start=($page-1)*$limit; } { if(isset($_POST['Submit'])){ $query=mysql_query ("select * from users where FirstName …

this code search all data not from current pagination page <html> <body> <div id="content"> <style> .current { padding: 2px 5px 2px 5px; margin: 2px; border: 1px solid #000099; font-weight: bold; background-color: #000099; color: #FFF; } li { display:inline-block } </style> <?php include"connection.php"; $start=0; $limit=5; $id=''; if(isset($_GET['id'])) { $id=$_GET['id']; $start=($id-1)*$limit; } …

please help me out by giving a very easy code

<td>Upload your pic</td> <td><input type="file" name="1234" value=""></td> <?php $img =$_POST['1234']; $sql="UPDATE users SET FirstName='$FirstName' , LastName='$LastName', UserName='$UserName' $sql_pass,Email='$Email' , Gender='$Gender',PicUrl='$img' WHERE UserId='$User_ID'"; ?> want to save in image folder also

<?php include"header.php"; if(empty($_SESSION['UserName'])){ header("Location: http://localhost:1234/city"); exit;} $result = mysql_query("SELECT * FROM menu"); echo "<td><a href='http://localhost:1234/city/menu_update_insert.php'> <img src='images/create.png'>Add New Record</a> </td>"; echo "<table border='0'> <tr class='tableheader'> <th>PageName</th> <th>MenuName</th> <th>ParentMenuId</th> <th>LinkWidth</th> <th>OtherUrl</th> <th>Status</th> <th>CreatedDate</th> <th>OnMainMenu</th> <th>FooterMenu</th> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr class='tablerow'>"; $rpId=$row['PageID']; $result1=mysql_query("SELECT * FROM page WHERE ID=$rpId "); …

<?php $picurl=$row['PicUrl']; >? <td><input type="file" name="userfile" ></td>

<td>Upload your pic</td> <td><?php if(!empty($picurl)){echo '<img src="'.$picurl.'" align="left"width="50px" height="50px"/>';}?> <input type="file" name="userfile" ></td> </tr> <tr class="tableheader"> <td colspan="4" class="last"><input name="submit" type="submit" class="button" value="Update"/></td> </tr> </table> </form> <?php if (isset($_POST["submit"])){ if($_FILES['userfile']['type']=="image/jpg" or $_FILES['userfile']['type']=="image/jpeg" or $_FILES['userfile']['type']=="image/gif" or $_FILES['userfile']['type']=="image/png"){ echo "Error number: ".$_FILES['userfile']['error']."<br/>"; //$_Files is a global array,its 2 dimen if(file_exists("image/".$_FILES['userfile']['name'])){ echo "file …

<?php $User_ID=$_SESSION['UserId']; $query = mysql_query("SELECT * FROM Users WHERE UserId='$User_ID'"); $row = mysql_fetch_array($query); $filename=$row['PicUrl']; if(isset($_SESSION["UserName"])){?> <img src="images/<?php echo $filename?>" align="left"width="50px" height="50px"/> <?php echo $_SESSION["UserName"]; echo"<li><a href='logout.php'>Click here to Logout.</a></li>"; echo"<li><a href='user_update.php'>edit your account detail</li>"; } ?> if pic url is empty then hide img scr

if(isset($_GET['Id'])){ $Id=$_GET['Id']; $query = mysql_query("SELECT * FROM page WHERE ID='$Id'"); $row = mysql_fetch_array($query); $PageId=$row['PageId']; $MenuName=$row['MenuName']; $ParentMenuId=$row['ParentMenuId']; $LinkWidth=$row['LinkWidth']; $OtherUrl=$row['OtherUrl']; $Status1=$row['Status']; $OnMainMenu=$row['OnMainMenu']; $FooterMenu=$row['FooterMenu']; } ?> <form style="width:100%" action="" method="post" id="form1"> <table class="viewjob" align="center" > <tr class="tableheader"> <td align="center" colspan="4"> Update </td> </tr> <tr class="tablerow"> <td>Page Id</td> <td><select name='PageId' class="select"> <option value='0' >select …

$query1= mysql_query("select PageId FROM page"); $result = mysql_query("SELECT * FROM page"); echo "<td><a href='http://localhost:1234/usman/page_update_insert.php'> <img src='IMG/create.png'>Add New Record</a> </td>"; echo "<table border='0'> <tr class='tableheader'> <th>PageName</th> <th>MenuName</th> <th>ParentMenuId</th> <th>LinkWidth</th> <th>OtherUrl</th> <th>Status</th> <th>CreatedDate</th> <th>OnMainMenu</th> <th>FooterMenu</th> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr class='tablerow'>"; echo "<td>" . $row['PageId'] . "</td>"; echo "<td>" . …

<tr class="tablerow"> <td>Page Id</td> <td><select name='PageId' class="select"> <option value='0' >select any page</option> <?php $sql10 = "SELECT Id,Title FROM abc"; $rs = mysql_query($sql10) or die(mysql_error()); while($row = mysql_fetch_array($rs)){ echo "<option value='".$row["Id"]."'>".$row["Title"]."</option>"; } mysql_free_result($rs); ?> this done show all title from table but when i update form i want that the tile …

$abc =$_POST['LinkWidth']; $link = $abc; echo $link; if ( $link == "page" ){ die('inputbox validate[required]'); } else if ($link =="otherlink"){ die('inputbox validate[required]'); return; }