10,942 Topics
 | |
 | function total_price (){ $total = 0; global $db; $ip = getIp(); $sel_price = "select * from cart where ip_add='$ip'"; $run_price = mysqli_query($db,$sel_price); while ($p_price= mysqli_fetch_array($run_price)){ $product_id = $p_price['p_id']; $product_price = "select * from product where product_id='$product_id'"; $run_pro_price = mysqli_query($db,$product_price); while ($pp_price= mysqli_fetch_array($run_pr0-_price)){ $product_price = array($pp_price ['product_price']); $values = array_sum($product_price); $total …  |
 | Select quray is working but delete query not working. <table border="1", align="center", width="98%", margin="auto", cellpadding="auto"> <caption><h2>View News</h2></caption> <tr> <th><input type="Submit" name="" value="Delete"></th> <th> S.No. </th> <th> Title</th> <th> Description</th> <th> Delete</th> <th> Edit</th> </tr> <?php $sel="select * from add_news"; $exe=mysql_query($sel); while ($fetch=mysql_fetch_array($exe)) { ?> <tr> <td><input type="checkbox" name=""></td> <td> <?php … |
 | Hello all, I am having a bit of an issue with a problem in my Web Dev Class. I am unable to get my "localhost" to pull up, it keeps giving me an error of; Parse error: syntax error, unexpected '<', expecting end of file in C:\xampp\htdocs\xampp\Chap19\Fig19_9.php on line 19. … |
 | |
 | how to upload and download the Folder zip file in php??? |
 | Whenever i execute this, only the last row of the loop gets inserted even if i click on the first row or any row. What i need is: if i click register, the entire selected row must store in another table Whats wrong here? Please help me.. <table class="table table-striped …  |
 | hi frinds. hope you are well. as i writte this writting im thinking about a my [site](http://Iraniantranslate.com) .... how can i introduce my site to other people? and how can i popular it in google search? best regards,  |
| | Hi, I have problem to count a multiple condition in one query. Usually i have to select count it one by one just like this : SELECT COUNT(kod_urusan) as num1 FROM customer_info WHERE kod_urusan = '0001' SELECT COUNT(kod_urusan) as num2 FROM customer_info WHERE kod_urusan = '0002' SELECT COUNT(kod_urusan) as num3 … |
| | I know how to do a fetch array to create a while loop as well as the mysql query in ASC order. What I'm trying to sort out is how I might be able to make it create the ASC order but to ignore the initial words "The" or "A" … |
 | I have done master master replication . I want to do multi master master replication. I research and found mostly master master replication in circular topology. But I want to do one supermaster who reads and update other masters. Is it possible? Is anybody did this? |
| | Hi I am new in PHP. I have used dropdown to bind with my sql data. It is ok But I could not insert data into table only from dropdown. Other controls like text can be inserted. I have given code below. Pls advise me. Maideen <?php require_once '../inc/header.php'; ?> … |
 | how to fix this? Port 3306 in use by ""C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" MySQL57"! |
 | Hey everyone, I have been going over this in my head and can't seem to figure out the solution. I've got a database table called brands and in my form I'm trying to get it to where when I edit a brand, I can't edit it into an already existing … |
| | Hi. can someone help me with my problem regarding search function, i have hard time knowing where to insert my if(isset($_POST['search'])).................and so on codes within my phpfile. here is my code, (pagination working) <?php $sql = "SELECT COUNT(user_id) FROM view_onse_officers"; $query = mysqli_query($db_conx, $sql); $row = mysqli_fetch_row($query); $rows = $row[0]; …  |
 | Hi Dynamic Dependent Select Box last one not working Bank,State,District is working branch ont working please check below code Please help. index.php <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <style type="text/css"> .select-boxes{width: 280px;text-align: center;} select { background-color: #F5F5F5; border: 1px double #FB4314; color: #55BB91; font-family: Georgia; font-weight: bold; font-size: 14px; height: 39px; … |
| | I have a login session where it checks the user name and displays it to the form (it displays FirstName LastName). That username is also being used as a variable to pull up data in db. Now I also have another page where user's can update the db, I dont …  |
 | HI,everyone , I m stum in this question for long time, could somebody help me out, my output is success ,but the arrange in table is wrong. below is my code.. <?php $no_pensyarah=$_SESSION['no_pengguna']; $tahunsemasa =date('Y'); include '../includes/dbconnect.php'; $sql_rekod = "SELECT a.*,b.nama_subjek,c.nama_kursus FROM info_subjek_pensyarah as a, subjek as b,kursus as c …  |
 | I am looking for a mysql query to search and list most common pairs with their IDs and number of occurence. Thanks. |
 | Hi all, I am working on program that will connect to MySQL database, colect data from table and show them in grid. Where user can edit cell, and then on enter key changes will bi save directly into database table. Curent problem is that I am stuck at importing data … |
 | My scripts are doing a lookup of transactions in table B. Each transaction contains an integer which is an ID of the business for each transaction. I also want the name (a varchar) of the business in the original transaction. My solution was to do a 2nd lookup for each …  |
| | Hi, not very familiar with mysql. I have here a mysql statement: table customer: [CODE]CREATE TABLE Customer (SID integer, Last_Name varchar(30), First_Name varchar(30), PRIMARY KEY (SID));[/CODE] table orders: [CODE]CREATE TABLE ORDERS (Order_ID integer, Order_Date date, Customer_SID integer, Amount double, Primary Key (Order_ID), Foreign Key (Customer_SID) references CUSTOMER(SID));[/CODE] My question is, …  |
| | I am trying to retrieved data from database and update a single column. column1 | column2 | column3 value1 | value1 | ------- value2 | value2 | ------- <=== this column3 rows does not have value in database yet so it will be blank when I retrieved the data Now …  |
 | [Click Here](http://www.acchajob.com) if (isset($_POST['createresume'])) { $university = $_POST['university']; $frommon = $_POST['frommon']; $tomon = $_POST['tomon']; $lavel = $_POST['lavel']; $courtitle = $_POST['courtitle']; $eduinfo = $_POST['eduinfo']; $typeskill = $_POST['typeskill']; $lavelskill = $_POST['lavelskill']; $skilldetails = $_POST['skilldetails']; $langskill_1 = mysqli_real_escape_string($con, $_POST['langskill_1']); $langskill_2 = mysqli_real_escape_string($con, $_POST['langskill_2']); $langskill_3 = mysqli_real_escape_string($con, $_POST['langskill_3']); $langskill_4 = mysqli_real_escape_string($con, $_POST['langskill_4']); $langskill_5 = … |
 | **USE SELECT...WHERE FOR TEXT FIELDS IMPOSSIBLE** I use SELECT search with WHERE fieldsname by VARCHAR imposible. But good use with INT fields. Why's that. Please tell me about it . My code as : <?php mysqli_select_db($connect ,'simple_login'); $sql = 'SELECT * FROM table where username= hai ' ; $retval = … |
 | my page ain't loading.. i think it its from the my comment querires .. pls some one help out <?php require_once 'dbconnect.php'; //select full thread from thread table $selFull = "SELECT * FROM frthreads WHERE threadId=".$_GET['threadId']; $selFullChck = mysqli_query($con, $selFull); $commentquery = "SELECT * FROM frcomments WHERE threadId =3"; $commentQuery …  |
 | I want to display records from my database in div and in a grid format using php. I want to set it to display 3 items in a row and then create another row and then display another 3 items continuously until the set limit but unfortunately only one item … |
| | Hi, i have installed prestashop 1.4.8.2 & i need a report of first order date for each customers, please help me to create mysql query. i need below columns information from database. id_customer, firstname, lastname, first order date thanks, Ritesh  |
| | Hi, i have installed prestashop 1.4.8.2 & i need a report of last order date for each customers, please help me to create mysql query. i need below columns information from database. id_customer, firstname, lastname, email, last order date. or is there any way i can export in active customers … |
| | i am getting this error when i process this form Notice: Undefined index: image in C:\xampp2\htdocs\trail\auction_upload.php on line 10 Notice: Undefined index: image in C:\xampp2\htdocs\trail\auction_upload.php on line 13 <?php session_start(); $_SESSION['message']=""; $mysqli = new mysqli('localhost', 'root', '','auction'); if ($_SERVER['REQUEST_METHOD'] == 'POST') { $item_name = $mysqli->real_escape_string($_POST['item_name']); $item_description = $mysqli->real_escape_string($_POST['item_description']); $item_image = … |
| |
The End.