11,093 Topics
 | |
| | id name class marks 1 H 1 60 2 H 2 50 3 S 1 70 4 S 2 60 5 V 1 55 6 V 2 80 7 K 1 60 8 K 2 70 This is my table structure. I want mysql query to get result like id …  |
| | How to connect MySQL database in Eclipse on android application?  |
| | I have website that enables user to select favourite websites, date of visiting the website, comments like how satisfied with the website they visited on that day. Initially there are four rows are hard coded and inserted into the mysql database. Then there is a add button enabling user to … |
| | |
| | I have two tables in my database.Users table and contact table,i want to use the ID that was generated from Users table to contact table.Below is the script for Users and contact. <?php // If the values are posted, insert them into the database. if (isset($_POST['username']) && isset($_POST['password'])){ $username = …  |
| | Got this type of errors: Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\OpenServer\domains\Test.loc\PHP\Shop Cart\index.php on line 7 Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\OpenServer\domains\Test.loc\PHP\Shop Cart\index.php on line 8 Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in C:\OpenServer\domains\Test.loc\PHP\Shop Cart\index.php on …  |
| | Hi guys I am attempting to get data entered in an HTML form through PHP then converting this data into a JSON object which will be saved on a server and retrieved to the form incase someone wants to edit entries. Please help and advice on an alternative if you … |
| | I work for a small company made up of a salesman, a graphic artist, and an engineer. The engineer writes and maintains all of his own software to run a network of interactive kiosks around the globe. As artist, I use his tools to maintain and update the network content. … |
| | Hi all I'm trying to set my mysqli connection to my database as outlined in http://php.net/manual/en/mysqli.quickstart.connections.php , with one difference - I'm trying to put my connection parameters in an include file outside of my root folder, to try to secure my DB password. $mysqli = new mysqli("DBServer", "DBUsername", "DBPassword", … |
| | I'm trying to do something like this $level=0; if($a=="x"){ $level=1; } Else{ $level=2;} How I can use the new value of $level outside the scope of IF Statement |
| | Hi, i have had made in the past a php file to download a supplier list in xml format, import it to a temp database with a datestamp then the file will check to see if product exists or not, has been removed from the file since last time or … |
| | Hi all! I have just developed an application on VB.NET with mysql. I then need to deploy this to clients workstations. The plan is to install mysql server on one computer and have all other clients connect to this. What do I need to install on the server and what … |
| | I import excel file and show on datagridview I want insert all row datagridview to mysql. But i receive error: Incorrect date value:'11/14/1991 12:00:00 AM' for column 'Ngaysinh at row 1. Mysql : i using date : yyyy/mm/dd datagridview show : mm/dd/yyyy. i don't know error: '12:00:00AM ' ???? column …  |
 | While it is not showing any errors that I can see, my input from an HTML form is not working. I copied part of the script from Visual QuickPro Guide book on PHP 6 and MYSQL 5. I only had one input , so I modified the script for my … |
| | I have images generated by while loop php based on how many course user have when user press on one of those images it will send him to that course page but all images send to one course page this my php code in** home page ** <?php $con=mysqli_connect("localhost","FYP","123","FYP"); $sql= … |
 | I have a small issue with following code am inserting a new room into mysql using query and then I want it to auto join the room once its made but the problem is when room is in process of being made it will call the GoTo procedure and it … |
| | Hi, i want to change format of date . This code i add in my register page.... if(!empty($_POST['dob'])&& !empty($_POST['mob'])&& !empty($_POST['yob'])) { $yob = mysqli_real_escape_string($con,$_POST['yob']); $mob = mysqli_real_escape_string($con,$_POST['mob']); $dob= mysqli_real_escape_string($con,$_POST['dob']); $date = mysqli_real_escape_string($con,"$yob-$mob-$mob"); $addtothedb="INSERT INTO login (Dateofbirth) VALUES ('". $date . "')"; $result=mysqli_query($con,$addtothedb); and when i get back data from db … |
| | Hello, I was wondering if the following mysql query can be constructed in a much more efficient way? SELECT distinct(cr.email), m.fname, m.lname, m.email, (SELECT count(*) FROM campaignRecipts where email=cr.email )as ttlsent, (SELECT count(received) FROM campaignRecipts where received='yes' and email=cr.email )as ttlreceived, ((SELECT count(received) FROM campaignRecipts where received='yes' and email=cr.email )/(SELECT … |
| | Using the below code i am getting the data from database(mysql) and displaying it in the textbox that is in the form of table(textbox inside the table data). Now I can edit the data(td) on browser(table) but the problem is updating it to database upon changing( onChange option ) data … |
| | hello PHP tycoons, i beg for help in giving me a way forward to write php script which will solve the problem i'm facing now. currently i'm developing basic student information system but in php knowledge i'm not that good, thus why i'm asking for help.so what i want to … |
| | I'm trying to make average consumption of fuel in my db. But I do not know how to do it. This is an little explanation: I have 2 tables: Tabe CONSUM: ID CARID LI KM DATETIME ------------------------------------------------ 6 9 70.17 174857 2015-02-10 10:58:51 5 5 51.00 154785 2015-02-09 19:11:19 4 … |
| | Hi, How to calculate no of days working of an employee and no of days absent in a current month. |
| | I am getting id's 3 times. count will be 3 but i am getting 9. i dont know where i did mistake. any body help me $result = mysql_query("SELECT * FROM candidate where user_id ='$username' and password='$password' and status='0' " ); $num=mysql_num_rows($result); if($num>0) { $row1=mysql_fetch_array($result); $cand_id=$row1['cand_id']; $f_mobile=$row1['f_mobile']; $d2=mysql_query("select * from … |
| | I'm trying to create a webpage to help teacher determine CLO and PLO for exam questions First user will type the keyword in text box and select the chapter CLO() function will start the AJAX the result should be a CLO Number in CLO column and PLO options in PLO … |
| | I need your suggestion on something. I want to display a 'message notification' on my menu bar. I want it to be like the Facebook message notification. When I have a new message, '1' should show close to the message menu e.g. 'Message 1' (I can use CSS to style …  |
 | Hi all, Is it possible to ignore temporary tables in mysqlbinlog file for replication.  |
| | I have a question about inserting images into a product page. I have 5 images (saved as longblobs in my products table) and would like to put them in my table like the id, name, quantity and price.... any idea of how i would do this? I have this so … |
| | $result = mysqli_query($con,$addtothedb); $cur = "USERS/"; echo $des = $cur.$email.'/'; if($result){ if ( mkdir($des,0777) ) { //http://pastebin.com/7J0BM5fD echo "<br/>"; echo "<br/>"; echo $file_name = $_FILES['file']['name']= 'mfix.png'; echo "<br/>"; echo "<br/>"; echo $file_tmp =$_FILES['file']['tmp_name']= 'mfix.png'; echo "<br/>"; echo "<br/>"; move_uploaded_file($file_tmp, $des.$mfix); echo "<img src='<?php echo $mfix ;?>' alt='Image' style='width:100px;height:100px'>"; /*echo "<img … |
| | i am new to php i need to create php code for automate monthly wise uploads files 2014 under sub category like months january(2014) under this uploads are grouped january month for example http://www.journalijdr.com/past-issue |
| | <?php $con=mysqli_connect("localhost","root","","uplod"); if (mysqli_connect_error()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } else{ echo work $sql ="UPDATE tea SET name = ' 8req' WHERE id = '3 ' "or die ("cant update" . mysql_error()); if($sql) echo"working"; } ?> Who can tell me which is error is the … |
| | Hello I have an SQL query that i want to concatenate the fields and display it in a way that those concatenated fields will be displayed first row will have 4 columns,second row will also have 4 columns....etc. for instance the query `SELECT imageurl, caption, template FROM template; The Result … |
 | Hi All I use MS Access to import information from Excel, check for duplicates and post it to an Access data table. The amount of data is making this process extremely slow. I am attempting to move the data tables to MySQL and then running a Stored Procedure to do …  |
| | This is a novice question and I hope some one can help. So far I have written 2 forms and a 3rd file. The first pulls every record from a table where the user can choose to modify a particular record. On the second form the user modifies the record … |
| | I’m trying to patch a routine and I finally found the problem. I am given the following string: [code] $query = "SELECT title, DATE_FORMAT(event_date, '%Y-%c-%e') AS event_date FROM $dbTable WHERE event_date LIKE '$year-$month%'"; [/code] In the month variable at the end, for the months January through September I am returned … |
| | I am looking for help to write a query. I have a database with an ID a Date_Field and a Description. I want to find out two things What Date_Field and Description and Description are the same? {duplicate records} [code] SELECT * FROM TIME_TABLE t1 WHERE EXISTS ( SELECT * … |
| | I the found the link below when I was researching how to get a random record for a database. This article is about speed in retrieving a random record and I found in my test that speediest solution brought about the most duplicates. [url]http://akinas.com/pages/en/blog/mysql_random_row/[/url] I am hoping some one has … |
| | I have created a vendors page where I want to show how many vendors exist in the database. I have succcssfully done but main problem is that how do i show that which vendor contains how many products There are 2 tables I have created 1 is products 2nd is … |
| | Hi all, I am trying to populate text on my website from data stored in a MySQL database. I have this script before the <head> of my HTML to establish the connection: <?php $username = "USERNAME"; $password = "PASSWORD"; $hostname = "127.0.0.1:3306"; //connection to the database $dbhandle = mysql_connect($hostname, $username, … |
| | Dear Sirs, I have two tables (Clients and Country), my below php code is for creating a new client with a dropdown box from country to insert the id_country into clients table. When click add new nothing added to table clinets: any help please: <?php $jsFile = 'newClient'; // Add … |
| | Hi!, Need a little help... thanks in advance!!!! Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/exponentialprofi/public_html/affiliates/topreferrals.php on line 22 (code in question) <?php $dsplynumreftop="5"; $qryreftop = "SELECT usrnam, (usrpoints + usrpointsindirect) AS maxpoints FROM scraffiliateusr ORDER BY maxpoints desc"; $rslreftop=mysql_query($qryreftop); //$arrreftop = mysql_fetch_row($rslreftop); $nreftop = … |
| | if ($count == 1){ $suc= move_uploaded_file($file_tmp, $destin.$file_name); echo"<br/>"; $query = mysqli_query($con,"INSERT INTO login ( profile_img) VALUES ('$file_name') WHERE useremail='".$_SESSION["sess_useremail"]."'") or die("can t still upload ".mysql_error());} |
| | I have the followiing data in my database(mysql) [img]http://i.imgur.com/jy3ryVk.png[/img] i want to represent then in a simple bar chart row after row with 2 sec interval(looks like dynamic).I am using jsp for my website.Code appreciated. |
 | <?PHP include('config.php'); function cleanData(&$str) { $str = preg_replace("/\t/", "\\t", $str); $str = preg_replace("/\r?\n/", "\\n", $str); if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"'; } // filename for download $filename = "Piante_" . date('Ymd') . ".xls"; header("Content-Disposition: attachment; filename=\"$filename\""); header("Content-Type: application/vnd.ms-excel"); $flag = false; $result = mysql_query("SELECT * … |
| | below, I have created 4 tables using oracle sql. I want to change the code so that when deleting a student will delete all enrollments for that student. any idea how can I do this? # COURSES table # CREATE TABLE COURSES (COURSE VARCHAR(6), DESCRIPTION VARCHAR(60), CREDITS INT, CONSTRAINT pk … |
| | |
 | I posted earlier today about converting my MySQL to MySQLi - Upon further research I came across the following, Prepared Statements. It seems that this may be a good way to go but I am a bit confused about how to implement it. I am simply taking User-entered data from … |
| | Hi, I want to create a SP in mySQL to insert records and return the Primary Key. But when I try and create the SP I get error: mysql said #1064, You have an error in your SQL Syntax, Check the manual that corresponds to your MySSQL server version for … |
| | I'm using pure php for the moment and I'm having a problem on what to do next using the command `DESCRIBE` calls all the header of my database but I cannot call those datas under the headers I have to manually put it. What I want to know is: * … |
| | hello everyone, i had to make a new system for practicum student system this is coding for view student that has been registered. first of all sorry fpr the keywprd that you dont understand cause i am Malaysian `<!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"> <head> <meta … |
| | i want to create a image gallery,i want to insert multiple files at a time,that should be stored in a database,and i want to display that in my profile.php as a gallery. |
The End.