11,093 Topics
 | |
 | Ok so I saw the few posts here, none do what I need mine to do, and for some reason it does not work. I upload CSV files to webserver (bank statement) 5 fields - it inserts into a MYSQL DB. Numbers dates are all formated correct etc etc. This … |
| | hey please help me actually i have used the command as part of program <?php echo "<a href= echo '$Geneprocess'>$Geneprocess</a>";?> getting a hyperlink bt when i am clicking over it it gives an error for all the hyperlink.... the error is Object not found! The requested URL was not found …  |
 | Hi need some help suggestion I am trying to search data form two date range but it seems not working properly when i search for $from_date = "2013-04-01"; $to_date = "2013-04-04"; $query = mysql_query("SELECT * FROM date WHERE Date between '" . $from_date . "' AND '" . $to_date . … |
| | I am designing my very own first web page. It's a real estate page where some users will add open house information while others can pull the info out. The code for the database and the web is very good (after two months...) and inserting and getting data is sweet. … |
 | hi i wan to add my `.xml` files into `database` and into the directory `uploads` . i have following done into the `php` if(isset( $_FILES["f_name"]) { $path = ""; if(file_exists("uploads/" . $_FILES["f_name"]["name"])) { echo $_FILES["f_name"]["name"] . " already exists. "; } else if($_FILES["f_name"]["type"]!= "text/xml") { echo "invalid type is tried … |
 | hi everuone i have website but i cant connect to database for login & register how can i connect? here my code <?php $connect=mysql_connect("184.154.164.202","ahmedhay_royal","xxxxxxx") or die("couldnt connect to data base:".mysql_error()); mysql_select_db("ahmedhay_login",$connect) or die ("couldnt find data base"); ?> |
| | Hello, I'm tring to develop a mysql news scroller for my website. The problem that i'm facing is that i need to have multiple mysql querys joing together beceuase i have multple categories like: select * from news where category LIKE '$cat1' order by id desc limit 1 select * … |
 | What kind of security measures I have to take to develop Core PHP and MySQL projects ? I used session and encruption, which are basics, there are any security technologies for Core or advanced PHP ?  |
| | am doing project in c++ using mysql api i have update query like that q2<<"UPDATE `dorder` set `ddown_status`= 1 WHERE `Machine ID`= "<<"'"<<xbx4.mid<<"'"; > but when i execute it , its says Unknown column 'ddown_status' in 'field list' but ddown_status coloumn already exisits in dorder table , so any idea … |
 | Hi would you please help my how to know my ( mysql host server)???? i used greengeeks to upload my website , i tried "local host" but it shows "couldn't find data base"...thanks <?php mysql_connect("localhost","ahmedhay_ahmed","Password") or die("couldnt connect to data base"); mysql_select_db("ahmedhay_hayman") or die ("couldnt find data base"); ?>  |
| | I have a form which is like a question paper. It has multiple text fields for entering a question and related information like marks allotted for that question, complexity level, tags in that question etc. I enter all this info into my db. **Tags are the keywords in that question**. … |
| | Basically my table Itinerary table where a record can have a parent record. so table cound have ID Parent ID which can be any ID from The same table. Other details Parent ID can be null if the record doesn't have child. and if i delete the parent record of …  |
 | Guys can I connect my vb.net program to my php website's database even if I already uploaded it in a web server, is the database that will be use by my PHP is the database that I made in my PC? please help me because this is the first time … |
| | Hi everyone I have windows form application connected to mysql database. To menage this base I use mysql.net connector. After I make some changes in datatable in my app, I use rowChanged handler to store changes in mysql. Here is code I use in handler: cmdBuilder = New MySqlCommandBuilder(dataAdapter) dataAdapter.Update(datatable) … |
| | |
| | Hello, I would first like to explain my current setup. 1) Nginx Server (A) which is the front-end proxy 2) Apache/MySQL (B) Serves the normal traffic and holds the databse. 3) Apache servers (x) x-servers are used to help shed the load. (nginx will channel the apache load to both …  |
 | Hi there, I have a classified website, built with custom PHP code. The problem is that the title of the entire site is the same. Attach files **index.php** and **pOffers.php**. Please give ideas on how to call from database the title of the listing. Tell me if you need more …  |
| | Dear Friends. When i going to UPDATE data of the database using UPDATE function in PHP, following message displays, What should I do? You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':_If_Any_01='Test', History_/_Remarks=NULL, … |
| | there is no file zf.bat in zend frame work2 like in the previous version ............ please any one can tell how to install it easy way and in windows |
| | Hello All! I have a MySQL database with 4 items, id (numerical), group_name, employees, and surveys. I need to in my select calulate the percentage of 'employees' who my the number in 'surveys' have taken the survey. This is the statement I have now: SELECT group_name, employees, surveys, COUNT( surveys …  |
 | I'm working on a design for a calibration management system but, i'm stuck with designing a table or tables to accomodate this data as desscriped in the picture below.  all the numeric data in the picture should be entred by the user but, the correction is calsulated automatically … |
| | I'm trying to get to grips with this create view thingy, but can't see it. This creats my view mysql_query("CREATE VIEW list AS SELECT AlbumId,Title FROM album, LEFT JOIN artist ON album.artistId = artist.ArtistId ORDER BY album.Title")or die ("no dice pal ".mysql_error()); that works, and creats it fine. But when … |
 | Hope this is the correct place to put this question. i am new to linux and am runnning ubuntu 12.04. I just installed Netbeans 7.0.1 and xampp 1.8.1, both running on ubuntu. i would like to make a c++ program that uses the MySql database that comes with xampp. I … |
 | Hi Experts, I need your valuable suggestions for research topic in mysql. Topic should have practical implemenatation part. Thanks |
| | Hi, I'm having trouble getting the information I need from my mysql db. I need to write a query that gets me: 1. A list of all combinations of answers from 8 columns and the frequency of them. Every row contains answers from 1 person from a survey and I … |
 | <form name="form1" method="POST" action="#" onSubmit="return check();"> <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("shg", $con); $result = mysql_query("SELECT * FROM consumer"); $email=$_POST['myusername']; $password=$_POST['mypassword']; $query="select * from consumer where email='$email' and password='$password'"; $result=mysql_query($query); if(mysql_num_rows($result)==1) { $count=mysql_num_rows($result); // If result matched $myusername and $mypassword, table …  |
| | Hi everyone, I am having some trouble with a mysql select query not working correctly. The query I am trying to run is "SELECT * FROM cards2 WHERE cardid NOT LIKE '".$_SESSION['clubsId'][0]."' " I have also tried mysql_query(" SELECT * FROM cards2 WHERE NOT (cardid =".$_SESSION['clubsId'][0]." || ".$_SESSION['clubsId'][1]." Would appreciate … |
| | Hi all gud morning > I try in to implement table with pagination. Am using Jquery data table. In data table i have problem loading all data from database so time dealy more. so i want to implement in Ajax, jquery, Mysql. kindly gudience to me. |
| | what I am trying to do is use this php script to load the data being submitted in the html form into my database and then populate the database into an excel (csv) file and then e-mail it to my address. Everything works great it populates into the database and … |
| | i am still learning,pls i need help,i want each and everytime i submit to database all the html tables with value should relect in database,i mean all the table should show in the database this my posting only display one table ............help thanks $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction … |
| | im trying to submit data from my form into a database. After validating everything the code to insert the data is: $qry = "insert into users(id, name, surname,email, password,date) values (id,'$name','$surname','$email','$password','$date')"; On testing the code i get an error that says:"error: unkown column 'geek' in field list". geek corresponds to … |
| | This is what I am tring to do... I have a table with 4 items: id (primary key) group_name employees surveys What I need to do is display all the data on a html table in input boxes, and allow a end user to update each field. I have tried … |
 | $query = "SELECT encounter,amount1,amount2,posted1,posted2 FROM payments WHERE pid='$patient_id'"; $res = mysql_query($query); $max =25; $num_rows=mysql_num_rows($res); $x_count=0; while($row=sqlFetchArray($res)){ $encounter_id=$row['encounter']; //$method=$row['method']; $amount1=floatval($row['amount1']); $amount2=floatval($row['amount2']); $posted1=floatval($row['posted1']); $posted2=floatval($row['posted2']); $total_amount_paid=floatval($amount1+$amount2+$posted1+$posted2); for($x_count=0;$x_count<$num_rows;$x_count++){ //$encounter_id[$x_count]=$encounter_id; $query = "SELECT date,SUM(fee) AS totalcharges FROM billing WHERE pid='$patient_id' AND encounter=$encounter_id"; $res = mysql_query($query); while($row=sqlFetchArray($res)){ $date_fee=$row['date']; $total_charges=floatval($row['totalcharges']); $balance=floatval($total_charges-$total_amount_paid); $pdf->SetFillColor(254,254,254); $pdf->Ln(); $pdf->SetX(10); $pdf->Cell(50,4,$date_fee,1,0,'L',1); $pdf->Cell(40,4,$encounter_id,1,0,'L',1); $pdf->Cell(40,4,$total_charges,1,0,'L',1); … |
 | Hello to everyone, I´m having problems on retrieving data from mysql to a textfield in html, the data appears with queston marks inside of a "black diamond"! I researched and followed the steps like putting the database charset utf8, the table too! When I insert for example Alimentação its goes … |
| | Hi, Can you set auto increment in phpmyadmin to be 2? So that it goes 1, 3, 5, 7etc? Thanks............... |
| | I have written a code which used to send data that was saved in my mysql database, through ethernet using UDP protocol, everything worked fine until i sent fewer data(25 rows), when i started sending data in huge amount(100 rows) it used to display Java Result: -1073740791 and would stop … |
| | Hi friends! I got one puzzle. I wonder if there is a way I can create a table but get a table name from a value of the textbox/combo box control. Does anyone have an idea? I mean something like "CREATE TABLE (TextBox1.Text) (".....)" I wonder if that is really … |
| | Ok I am working something that I have seen others do and that is to echo out a form table and what I am trying to do is to get the data that is not assigned to a user and allow the admin to assign it to the user. I … |
| | [CODE] $query1 = "SELECT tblpatient_pass.RelationMR_no, tblpatient_pass.username, tblpatient_pass.password, tblpatient_pass.email_address, tblpatient_info.lastname, tblpatient_info.firstname, tblpatient_info.mname FROM tblpatient_pass INNER JOIN tblpatient_info ON tblpatient_pass.RelationMR_no=tblpatient_info.MR_no "; $numrows = mysql_num_rows($query1); if ($numrows!=0) { while ($row = mysql_fetch_array($query1)) { $username = $_SESSION['username']; $query = mysql_query("SELECT * FROM tblpatient_pass WHERE username =".$username); $result = mysql_query($query) or die(mysql_error()); while ($patient = …  |
| | Hello, Could you please assist me i want to deploy this application as an executable file with the MYSQL database embedded. I have clean and build the application, the jar file is there but nothing happens. The database is stored on local host. Thank you  |
| | hi... i have 1 jsp form. my form includes 6 text boxes and 8 dropdowns. I want to insert the data of these textboxe and dropdown to Database. I am using mysql server 5.1.The problem is that when I insert, a blank screen appears. (Data in dropdown is retrieved from … |
| | hello, ive recently created a login in and register page for a website im working on and when using the register.php page to sign up, then entering the details into the login.php page all the login page seems to be doing is refreshing and removing the entered information and not … |
| | trying to buld gllery.php page. where i want to print all user image with 4 cols. and infity rows. all in one page gallery.php <?php session_start(); include("connect.php"); $user = $_SESSION['username']; if($user) { $user_id = $_SESSION['user_id']; //get user_id who ever is loged in $image = mysql_query("SELECT * FROM image WHERE user_id … |
| | Hello to everyone, im having trouble getting the value of a combobox in HTML to php! Frist I import data from a mysql collum into the combobox, being this the value of the combobox! I want to be able to get the selected value when I submit my form. I … |
| | Hi I am running phpMyAdmin 5.6. I have created a table as described in a tutorial. This table is supposed to have a null value in a text field, I cannot do it, I tried everything.The examples on the web refer to older versions and I keep getting error.I even … |
 | Hello, I have been making an employee timeclock and have run into a bump in the road. Here's what my setup is like when an employee (who is not an Admin) loggs on they get a simple screen telling them the current time current date and two button that allow … |
 | hi i am trying to, on a button click, display data retrieved from mysql database in a text area but having no success. Below is the code i used. All help given is appreciated [CODE] print "<center><TEXTAREA NAME=news ID=news COLS=70 ROWS=10>".$news."</TEXTAREA></center>"; if(isset($_POST['show2'])){ $cn = connect_db(); $cn_sql = "SELECT message from … |
| | hi, i was wondering is someone could give me an example of how i could do this in sql query. basically the application has a product table and when they are inserting they have the option to select monthly payments. put in the start date so say 30/3/2013 what i …  |
| | I have two fields in table, (i) section_from & (ii) section_to, both fields has Date datatype, these fields tells us that this law section is enforced From(section_from) this date To(section_to) this date. The problem is, the latest law sections (active law) which are issued by the government has no specific … |
| | I am using a java program to read lines from csv and insert them into mysql database. Whenever i run my program i discovered i could not insert values into a date field insert mysql if the value comming from the file is null. However if i change the field … |
The End.