Hi all at Daniweb, I'm quite new to PHP and I'm banging my head over this... query 1 WORKS: **$query = "CALL procedure_is_a_great_way_to_let_db_do_some_work('1','6')";** //both 1 and 6 are IN parameters! query 2 DOESN'T WORK: $id_pictures = 1; $id_names = 6; **$query = "CALL procedure_is_a_great_way_to_let_db_do_some_work('".$id_pictures."','".$id_names."')";** //both 1 and 6 are IN parameters!

Member Avatar
Member Avatar
-1 forum 2

How important is Unit Testing taken by employers, is it something that every developer should have as one of their skills, do some jobs require it more than others or is a simple test like handing out a piece of software to be used by friends family etc sufficient enough.

Member Avatar
Member Avatar
+0 forum 4

Hi, I have been trying to code an timetable which allows timeslots to be booked. What I am finding difficult is the schedule settings. So three things, "schedule settings", "find common slots" and "make booking". The "find common slots" and "make booking" seems to almost work. But "schedule settings" is more difficult. The idea: The timetable is a typical one with days of the week on the top and hours of the day on the left side. Ofcourse bookings should be possible by choosing month and year also. There are three paricipants. Two of these have a schedule. The third …

Member Avatar
Member Avatar
-1 forum 10

Hello, I'm quite nub in web development, so be gentle please. If this place is wrong for such problems point me to a more appropriate resource please. To became more familiar with web-programming I found good (as I thought) area for self-improvement. One of my friends owns web project. This project was developed during last 15 years with one programmer who seems to be slightly tired and probably is needed for backup. I've tried (for the very beginning) copy all stuff to the new development environment and found that project consists of several tens of sites: site1.domain.name, site2.domain.name, etc. So …

Member Avatar
Member Avatar
+0 forum 1

I am using magento for sending mail with condition, My code: <?php class Gta_MerchantNotification_Model_Observer { public function merchantremainder($Observer) { $order = $Observer->getEvent()->getOrder(); $order_details = $order->getAllVisibleItems(); $itemData = array(); foreach ($order_details as $list) { $incrementid = $order->getIncrementId(); $sku = $list->getsku(); $name = $list->getName(); $price = $list->getPrice(); $Qty = $list->getQtyOrdered(); $extra = $order->getIncrementId(); $message = " <tr> <!-- <td>$incrementid</td> --> <td>$sku</td> <td>$name</td> <td>$price</td> <td>$Qty</td> </tr>"; $itemData[$list->getId()] = $message; } $finalMessage = " <p>Order Id : $incrementid</p> <table border='1'> <tr> <!-- <th>Id</th> --> <th>Sku</th> <th>Product name</th> <th>Price</th> <th>Qty Ordered</th> </tr>"; if (!empty($itemData)) { foreach ($itemData as $data) { $finalMessage .= $data; } $finalMessage …

Member Avatar
Member Avatar
+0 forum 1

<?php include 'ProcessDAO.php'; $dest=""; if(isset($_POST['login'])){ session_start(); // i get an error in this line !! $_SESSION['status']='online'; $_SESSION['breadcrumb']='home'; $pro = new ProcessDAO(); $dest = $pro->LogIn($_POST['username'],$_POST['password']); }else{ session_start(); $dest ="Location: ../index.php"; session_destroy(); } header($dest); ?> guyss can you help me out because in my Login.PHP file when i login i always get this error . >** Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\xampp\htdocs\IPMS\process\ProcessDAO.php:1) in C:\xampp\htdocs\IPMS\process\login.php on line 5**

Member Avatar
Member Avatar
+0 forum 8

Hi all, this is my first post and would appreciate some insight as to where im going wrong. I have the following form that successfully registers a new user to my mysqsl database via PHP - with the following $sql INSERT Function The problem im having is sending the activation \ confirmation email to the new users email address. [code] //email function ini_set("SMTP", "smtp.server.com");//confirm smtp $to=$email; // Your subject $subject="activation required"; // From $header="from: test email <Test@test.com>"; // Your message $message="Your Comfirmation link\r\n"; $message.="Click on this link to activate your account\r\n"; $message.="You can not login to your new account until …

Member Avatar
Member Avatar
+0 forum 8

I am working on an app where a user registers and its passed to the server where there information is added to the database. It passes various checks along the way but ails to add the user. Code below: <?php $con = mysqli_connect('localhost', 'root', 'root', 'eat4lessaccess'); //check connection if(mysqli_connect_errno()) { echo "1: Connection Failed"; //Error code 1 = connection failed exit(); } $username = $_POST["username"]; $password = $_POST["password"]; $name = $_POST["name"]; $email = $_POST["email"]; $phone = $_POST["phone"]; //Check username exists $usernamecheckquery = "SELECT username FROM useraccounts WHERE username='" . $username . "';"; $usernamecheck = mysqli_query($con, $usernamecheckquery) or die("2: Username Check …

Member Avatar
Member Avatar
+0 forum 2

I need help on a new problem. On my women’s golf club web site I have a Members Directory page which consists of a table, 5 columns in width, and enough 2 rows sets to hold the members photo in the odd numbered rows with the members name in the even numbered rows. Visually it looks like; ![table1.jpg](/attachments/large/4/d2d953554cd2e5f4daecf07677c9cd88.jpg) We currently have around 53 members which means the table contains 22 individual rows (11 sets of 2 rows). The directory is sorted by last name, so when ever a new member joins a laborious cut and paste process takes place to …

Member Avatar
Member Avatar
+0 forum 1

Hi, I can show data from the database using query [CODE=php] <?php $con = mysql_connect("localhost","root","root"); if (!$con) { die('Could not connect: ' . mysql_error()); } $a= $_POST["SiteId"]; mysql_select_db("abc", $con); $result = mysql_query("SELECT * FROM sitepinfo WHERE SiteId='$a'"); echo "<table cellpadding=2 cellspacing=2 width=100% > <tr> <th bgcolor=#5D9BCC>SiteID</th> <th bgcolor=#5D9BCC>Maintained By</th> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td bgcolor=#FEE9A9>" . $row['SiteId'] . "</td>"; echo "<td bgcolor=#FEE9A9>" . $row['MaintainedBy'] . "</td>"; echo "</tr>"; } echo "</table>"; mysql_close($con); ?> [/CODE] Now It shows for example 5 results , I want an Approve, Edit, and Delete button like image I Attached, please tell …

Member Avatar
Member Avatar
+0 forum 11

I have table i wish to count how many times a value appears in all column the table structure id Subject1 Subject1score subject1grade Subject2 Subject2score subject2grade 1 English 100 A Mathematics 100 C HERES MY PREVIOUSLY TRIED CODE <?php $subject1grade='A'; $subject2grade='A'; $subject3grade='B'; $a=array("$subject1grade","$subject2grade","$subject3grade"); print_r(array_count_values($a)); ?> THE RESULT Array ( [A] => 2 [B] => 1 ) I NEED THE CODE TO DISPLAY You made 2A(s), 1B(s) I want to count how many A's and C's

Member Avatar
Member Avatar
+0 forum 3

$strSPQuery = "SELECT * FROM `san_pham` where ma_san_pham=".$arrMa[$i]; $resultSp= mysqli_query($conn,$strSPQuery); $rowsp = mysqli_fetch_array($resultSp); $tong += $rowsp["gia"]*$arrSl[$i];

Member Avatar
Member Avatar
+0 forum 3

I am thinking of moving to ecommerce development. There is just so much out there so much so that I find myself at a loss as to where to start. I do front end development but I understand backend equally well. Ideally I would like to find a suitable e-commerce system that I can work with, tweak and customise. So if a client needs an ecommerce site my task would be to build a custom interface and hook it up with this system. If some changes are necessary to make this work that would be done. What are the best …

Member Avatar
Member Avatar
+0 forum 5

i need to pop a bootstrap modal but from inside will need to make queries from a PHP variable that will vary depending on where the pop originated from. so i have this in my file : <a href="#" class="btn btn-md btn-success" data-toggle="modal" data-target="#editUser" id="User" data-id="UserID123"> update </a> How can I put the value UserID123 in a php variable once in the modal so I can use it for queries ... I've been looking around but haven't seen the solution ... some suggest AJAX but i could figure out to adapt it here thanks

Member Avatar
Member Avatar
+0 forum 8

With this php code, I send a request for payment with Paypal sandbox account. However when I go to the submit page I cant see what amount I am paying: https://i.imgur.com/iTra1SQ.png -> here in the red shoulld be displayed - 10.00(amountPayable). How can I send it so it's showed? use PayPal\Api\Amount; use PayPal\Api\Payer; use PayPal\Api\Payment; use PayPal\Api\RedirectUrls; use PayPal\Api\Transaction; require 'bootstrap.php'; $payer = new Payer(); $payer->setPaymentMethod('paypal'); // Set some example data for the payment. $currency = 'GBP'; $amountPayable = 10; $invoiceNumber = uniqid(); $amount = new Amount(); $amount->setCurrency($currency) ->setTotal($amountPayable); $transaction = new Transaction(); $transaction->setAmount($amount) ->setDescription('10 GBP payment') ->setInvoiceNumber($invoiceNumber); $redirectUrls = …

Member Avatar
Member Avatar
+0 forum 1

Can anyone help me with my search engine. I need filter search in the system using PHP. The problem with the code: All the provided fields must be filled up..unless it will not work There were 6 fields such as Remark Status: Industry: Position: Location: Age Range: Min and Max I have to use these fields as the filters,but eventually all the fields must be filled up before it works..How if i provide just one field, let say i fill the position as HR Manager so i did not specify its age and location...Please Help me on this,,, if(isset($_GET['advance_searching'])){ if …

Member Avatar
Member Avatar
+0 forum 14

I am working on a project for drag and drop items in a shopping cart. For an item dropped into the cart, I am trying to implement jQuery $.ajax. The result back from the PHP is pre-pended with '`' and I can not figure out why. This is the javascript: $('#target').droppable({ drop: function(event,ui) { var id = $(ui.draggable).data('id'); var aisle = $(ui.draggable).data('aisle'); $.ajax({ url : base_url+'/index.php/groceries/jquery_append_to_list', cache : false, type : 'post', data : { 'id' : id, 'aisle' : aisle }, success : function(data) { $('#target').append('<p data-id="'+id+'" data-aisle="'+aisle+'" class="draggable">'+data.item+'</p>'); } }) } }); This is the PHP script: function …

Member Avatar
+0 forum 0

i want to display the stored image in fdpf.

Member Avatar
Member Avatar
+0 forum 40

Receiving error - Warning: Missing argument 4 for Get_All_Orderlines_Range(), called in /home/download/domains/1ecommerce.com/public_html/dev/_cms/list_orders.php on line 184 and defined in /home/download/domains/1ecommerce.com/public_html/dev/_cms/list_orders.php on line 161 Line 161: function Get_All_Orderlines_Range($id, $all = "", $from_date, $to_date){ $sql = "SELECT * FROM orders"; $sql .= " INNER JOIN orderline on orders.OR_ORDER_NO = orderline.OL_ORDER_NO"; $sql .= " WHERE OR_CUSTOMER_ID = '$id'"; if($all != "ALL"){ if($from_date != "" and $to_date != ""){ $sql .=" AND (orders.OR_DATE_CREATED BETWEEN '" . $from_date . "' AND '" . $to_date . "')"; } } $sql .= " ORDER BY orderline.OL_ORDER_NO"; //echo $sql; return FetchSqlAsObjectArray($sql); } Line 184: $orderlines = Get_All_Orderlines_Range($printed, pack_calendar_date($from_date, "from"), …

Member Avatar
Member Avatar
+0 forum 6

How I can get current date and 15 days back date from current date in 'Y-m-d' format ?? e.g. if current date is 2011-06-21 then $currentdate=2011-06-21 and $dateback=2011-06-06;

Member Avatar
Member Avatar
+1 forum 9

hi, i have installed XAMPP, but i would like to run my localhost from another computer..

Member Avatar
Member Avatar
+3 forum 16

I'm a novice in PHP and I would like to know on how exactly could I define said row. Any helps/tips are appreciated. Thank you in advanced! function add_review() { if(isset($_POST['add_review'])){ (THE UNDEFINED ROW) **$product_id = $row['product_id'];** $review_name = escape_string($_POST['review_name']); $review_email = escape_string($_POST['review_email']); $review_content = escape_string($_POST['review_content']); $review_created = date("Y-m-d H:i:s"); $rating = escape_string($_POST['rating']); $review_query = query("INSERT INTO reviews(review_id, product_id, review_name, review_email, review_content, review_created, rating) VALUES('NULL', '$product_id', '$review_name', '$review_email' , '$review_content' , '$review_created' , '$rating')"); confirm_query($review_query); set_message("Thank you for the feedback!"); }}

Member Avatar
Member Avatar
+0 forum 1

Hi all, I am very new to PHP and MYSQL and have a class assignment I need help with. I am trying to make a page with an HTML form that will update my MYSQL database. You can view my pages online here: [URL="http://baileyjumper.aisites.com/Scripting-Week7/homework4/exercise-five.php"]http://baileyjumper.aisites.com/Scripting-Week7/homework4/exercise-five.php[/URL] I need help with the "Edit" section, if you look online. Here is the code for my Edit page: [CODE=PHP] <?php $hostname = "localhost";//host name $dbname = "baileyjumper_imd203";//database name $username = "baileyjumper_imd";//username you use to login to php my admin $password = "chris4ever";//password you use to login //CONNECTION OBJECT //This Keeps the Connection to the Databade …

Member Avatar
Member Avatar
+0 forum 21

Got Client with need of **"online print shop"** Client is providing paper printing (like business cards, flyers), printing on cloths, office stationary, logo embroidery on any type of clothing. Client provided some examples. **Links** * [rockdesign](https://www.rockdesign.com/) * [moo](https://www.moo.com/ca/) * [readyprint](https://www.readyprint.ca/) * [vistaprint](https://www.vistaprint.ca/) * [printshop](https://printshop.ca/) * [printvenue](https://www.printvenue.com/) **Where do I start?** Which platform should I choose? 1. CorePHP 2. Wordpress 3. WooCommerce 4. Magento 5. Prestashop 6. WordPress Is there any plugin or script that should I go for???

Member Avatar
Member Avatar
+1 forum 14

I have predefined value like shipping_weight = 10$, my form consisting two dropdown list, if the dropdown selected based on the selection how to return my ajax value, Index.php : <tr> <th>I have : </th> <td> <select id="old" name="i_have"> <option value = "select_option">Select Option</option> <option value = "three_compact">3 Compact</option> <option value = "three_regular">3 Regular</option> <option value = "three_triple">3 Triple</option> <option value = "five_compact">5 Compact</option> <option value = "five_regular">5 Regular</option> <option value = "five_triple">5 Triple</option> <option value = "seven_compact">7 Compact</option> <option value = "seven_regular">7 Regular</option> <option value = "seven_triple">7 Triple</option> <option value = "nine_compact">9 Compact</option> <option value = "nine_regular">9 Regular</option> <option …

Member Avatar
+0 forum 0

I have a search form, and I want to change the url from: https://www.example.com/search?search=term+term to: https://www.example.com/search/term+term I know how to use htaccess, but I don't know how to send user to friendly URL after he submit the form. Here is my form: <form action="search" method="get"> <input type="text" name="search" id="Searchx" placeholder="Search Marketplace" /> </form>

Member Avatar
Member Avatar
+0 forum 2

Hello i have this form and my php code skills not very good if someone make change password I would be glad thank you <div class="col-lg-9"> <div class="nk-box-3 bg-dark-1"> <form class="change-password" method="post" action=""> <input type="password" class="form-control input-change-password" name="opass" id="opass" placeholder="Old Password"> <div class="nk-gap-1"></div> <input type="password" class="form-control input-change-password" name="npass" id="npass" placeholder="New Password"> <div class="nk-gap-1"></div> <input type="password" class="form-control input-change-password" name="cnpass" id="cnpass" placeholder="Repeat New Password"> <div class="nk-gap-1"></div> <button type="Update" class="nk-btn link-effect-4 ready"><span class="link-effect-inner"><span class="link-effect-l"><span>Change password</span></span><span class="link-effect-r"><span>Change password</span></span><span class="link-effect-shade"><span>Change password</span></span></span></button> </form> </div> </div>

Member Avatar
Member Avatar
+0 forum 12

I am required to change ip adress everytime this function gets executed I am trying this code below .But I am completly confused.How can I do this function getData($domainName, $ext) { $proxy = array( 1 => array( '88.255.101.247', '8080' ), 2 => array( '176.53.2.122', '8080' ), 3 => array( '37.123.96.237', '8080' ) ); shuffle($proxy); $servers = array( "biz" => "whois.neulevel.biz", "com" => "whois.internic.net", "us" => "whois.nic.us", "info" => "whois.nic.info", "name" => "whois.nic.name", "net" => "whois.internic.net", "tv" => "whois.nic.tv", "ru" => "whois.ripn.net", "org" => "whois.pir.org", "com.tr" => "whois.nic.tr", "gen.tr" => "whois.nic.tr", "web.tr" => "whois.nic.tr", "k12.tr" => "whois.nic.tr", "org.tr" => "whois.nic.tr" ); …

Member Avatar
Member Avatar
+0 forum 1

I have to take over a php project and I am totally new to php. I have this webpage that displays all packages sent to a customer and I want them to be able to click on the tracking number to do UPS website tracking. The code: <?php $result = mysqli_query($conn, $sql); if (!$result) { exit(); } else { if (mysqli_num_rows($result) > 0) { while ($row = mysqli_fetch_assoc($result)) { echo "<tr>"; echo "<td><strong>"; echo $row['trackingno']; echo "</td>"; echo "<td>"; echo $row['date_shipped']; echo "</td>"; echo "<td>"; echo $row['desc_reference2']; echo "</td>"; echo "<td>"; echo $row['status']; echo "</td>"; echo "<td>"; echo $row['date_delivered']; echo …

Member Avatar
Member Avatar
+0 forum 1

So here's a little background to help with what I'm trying to accomplish (be mindful I'm also fairly new to MySQL): I'm creating a dynamically built navigation for a website using PHP and MySQLi. I've created a class called *Database* where I've got helper functions, such as connect() for connecting to the database, and the like. Then I have another class called *Navigation* which extends *Database*, and there I'm creating helper functions to do specific things for the database that holds my navigation links, such as selecting and inserting and so on. Now, the following code works flawlessly when working …

Member Avatar
Member Avatar
+0 forum 9

The End.