Forum Topics Tagged [php]

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!

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.

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 …

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 …

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 …

<?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**

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 …

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 …

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;  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 …

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 …

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

$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];

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 …

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

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 = …

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 …

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 …

i want to display the stored image in fdpf.

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"), …

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;

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

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!"); }}

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 …

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???

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 …

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>

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>

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" ); …

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 …

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 …