10,946 Topics
 | |
| | I attempted to get the records from the MySQL database and display it on a Grid View but nothing appeared. The code is below: MySqlConnection myconn = new MySqlConnection("server=localhost;user id=root;password=db;database=workers;"); // myconn.Open(); string strSQL = "select * from details"; MySqlDataAdapter mydata = new MySqlDataAdapter(strSQL, myconn); MySqlCommandBuilder cBuilder = new MySqlCommandBuilder(mydata); … |
 | SELECT * FROM onlinepg as pg, pg_rooms as rooms WHERE pg.pg_id=rooms.pg_id and pg.status=0 AND ( rooms.roomtype='Sharing Basis' ) How I can write above query in PHP.. so that I can run successfully on mysql. |
| | #MySQL TABLES CRASHED BUT STILL WORKING WHEN RESTORED TO MySQL ON ANOTHER SYSTEM, WHY ???# Hi everyone, I'm a software developer and just started my professional career life, question here i want to ask is ... that few days ago i was at client site to resolve some issue in … |
| | Hi, I have a database called my_db1 which contains 3 tables. Out of the 3 tables one table is being populated 24*7. My hosting provider (i.e godaddy) provides 25 Mysql databases 1 GB each. What should I do if the database exceeds the 1 GB size limit? Is there a … |
| | hello, i'm currently working on a website for my team fortress 2 server, and am now getting to the premium part. i would like to make a page where people select either a subscription or a one-time payment and then pay it. when the payment is done, they would be …  |
| | I am using mysql server 2012 and visual studio 2012 C#, i created a database and i can read the data from my database. The problem is that i cannot insert data into my database. Although the return value of the execution is 1, i dont see any changes in …  |
| | Hi! I am just starting PHP. I am learning to sanitze my data. I found this exmaple from the web. It displays the sanitized data, but... it does not insert the sanitized data. :( What shouuld I do to make that happen? <?php $filters = array( "firstname" =>array("filter"=>FILTER_VALIDATE_INT, "flags"=>FILTER_FLAG_ARRAY|FILTER_NULL_ON_FAILURE, "options"=>array("min_range"=>0, … |
| | Hello guys. I have a form in which i have some dynamically generated input fields like this: <input value="March" name="month[March]" type="hidden"> <input value="April" name="month[April]" type="hidden"> <input value="May" name="month[May]" type="hidden"> . . . How do i add the input data for each month to mysql? Thanks! |
| | Hi all, In the section of the order confirmation mail: $get_cart_info, when I include this theres is somehow a syntax error, as I keep getting this error after mail has tried to send: Catchable fatal error: Object of class mysqli_result could not be converted to string in /home/www/ebm-fashion.dk/views/betaling_accepteret.php on line …  |
| | Hey all.. i wan't make project with vb6 and database using mysql. did i've use mysql odbc connector ..??? i need some refrences.. Help me plizzz... |
| | Hello there, I am a newbie in MySQL and I am extremely confused about one thing. I am currently creating four tables. There's a primary key I have specified for the first table which is a foriegn key in the second table. Now the problem is that I want the …  |
| | Hello, I'm having a problem using the jTable plugin. I'm fairly new to using jquery. Here is my problem: I have an database name reg and has fields (fname, lname.....avatar). What i want is to show the contents of the database using jTable. Now, I don't know how to display … |
| | I have text being loaded onto the page from a MySQL database. When the text is clicked, using JavaScript the element is replaced with a textbox displaying the text. I want to be able to use a MySQL update query to change what is in the textbox and so it …  |
| | okay...seem to be experiencing some problem here....in my pc, the web application is running perfectly....but when i run it from my handheld, its showing error... this is my code <?php session_start(); //starting session $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="test3"; …  |
| | <table> <tr><td>Date</td><td>Job_id</td><td>Active</td>/tr> <?php while ($row = mysqli_fetch_assoc($rs_total)) { ?> <tr> <td><? echo $row["Date"]; ?></td> <td> <?php echo "<a href='work.php?ID=".$row['Job_id']."'>".$row['Job_id']."</a>"; ?></td> <td><? if($row["Active"]==0) echo "Active"; else if ($row["Active"]==2) echo "Completed"; else echo "Not active"; ?></td> </tr> <?php }; ?> </table> in this code i want to transfer the id on pop … |
| | Hi, I am vishnu kumar. I knew the basics of Java but this is the first time i am building a project based on java (Java Swing actually). This is my final semester project and for last two months, i am doing my project. I initially thought the database(along with … |
| | I have four database tables locality table: localityid, locality. jobtype table: typeid, type. applywork table: id, userid, applyfor applicationsent, jobtypeid, vacancyseenon companyname, doorno buildingname, street, localityid, postcode, telephone, website, email, notes users: id, role, name, surname, gender, username, password. I have a page to edit selected field from applywork. I … |
 | |
 | Hello. :) So I am creating a grading system where users can compute student's grades on selected ID Number. The problem is after clicking the COMPUTE button, an "Error!" message display. So far I can save the grades in database but I can't compute it. I'm sorry I'm new to … |
| | I have a live update system for a football team, which I input the following: Date, Score, Event (Goal, Red card, Yellow Card, none), Details So 4 columns. At the top of the page, I want to display the latest score, so bascially I want to grab whatever the current … |
| | I want a Jquery Popup Form which will appear on Page Load but only one time (for newsletter purpose). After filling form.. I want to store values into a table. |
| | Hello guys, well... I want to create an HTML-JScript that will store some values in DB (Like Visitors IP) Because blogspot.com dont give DB, we just can have a html/js gadget, i sayd to use a DB wich is hosted in other server, is that possible? 1) will be 1 … |
| | I want a Jquery Popup Form which will appear on Page Load but only one time (for newsletter purpose). After filling form.. I want to store values into a table. |
| | I have developed a web application and it works very well in the localhost. but when i put it to the web server the relationships in the table doesn't work. for example when a parent row is deleted all the child rows associated with it should be deleted. but it … |
| | I have a table ... Ratings (userid, movieid, ratings, time) where ... select count(*) from ratings where userid = X; (No of ratings of a particular user) Here, X ranges from 1-6040! How should I get the count of each user and then store it in another table 'Users' in …  |
| | i want to display data from mysql database in table form on the web page . Ex. - If there are 100 entries in the database then only 10 entries can be displayed i should be able to use 'next' and ' previous' buttons to display consecutive data tables containing … |
| | Hi I have imported a number (500+) posts into Wordpress from another CMS (Expression Engine). On a number of posts I have a problem with the way paragraphs are being displayed and I can trace this back to the post data that has been copied across. For example, when the … |
| | Hi all, I have a table 'table 1' which has a primary key. Now I want to create two other tables with a composite key in each one, composed by primary key and a foreign key both referencing table 1 's primary key. However I can only do it with … |
| | I have a table which has a foreign key that links to a primary key in another table. That id has information on it in which I want it to show while having a sum on the information. Is there a way to do it? To clarify here's a code … |
| | I thinking about a project to build up a web based application. I am not able to understand what should be structure of the database. [B][COLOR="Red"]Problem:-[/COLOR][/B] Data is in bulk which is of a big general store, and they have 50,000 transaction minimum each day. They store all data and … |
| | Hi everyone! I am sorry I'm new to PHP and MySQL. So, I am creating a form for user to update their details and compute student's grade but the updating part doesn't work. Here is code: [B]COMPUTE.PHP[/B] [CODE]<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <title>Compute Grade</title> </head> <body> … |
 | error msg: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'mon'@'localhost' (using password: YES) in C:\xampp\htdocs\project\include\connection.php on line 7 Could not Connect ///my connection.php code <?php define("contype","localhost"); define("user","mon"); define("passwd","affinity"); define("db","project"); $con=mysql_connect(contype,user,passwd) or die('Could not Connect'); $dbcon=mysql_select_db(db); ?> //here's my scenario. i add new USER to my mysql in phpmyadmin and its … |
| | Hi all, I'm working on a webpage with 2 dropdown menu and a submit button. both the dropdown menu has a default value="" selected. I am trying to figure out a way to filter mysql query. Here is the drop down menu <form action="showJobs.php" method="post"> <select name="Locations"> <option value="" selected="selected">All … |
| | I am trying to create a form that exports my mysql database , and can also reimport the mysql database using like a form. I am trying to do this in PHP any ideas on how it can be done or if it''s already been done? I know there is … |
| | Dear all, The first query works while the second doesnt, am not able to figure, can u please help me out. 1) // $query3="insert into ttrough(am,pm) select ttam.subject,ttpm.subjectpm from ttam,ttpm where ttam.class != ttpm.classpm limit 1";// this one actually takes two columns from different tables and checks whether they are … |
| | So I'm trying to create a PHP and MySQL program where users can add, update, delete, view and search records. But the problem is I can't update records whenever I click update button. Here's my code --> [CODE] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <title>Update Record</title> </head> … |
| | I have three table that are linked like this. Each content is linked to a category and each category is linked to a section. Like this sections_table -section_id -section_name categories_table -category_id -section_id -category_name contents_table -content_id -category_id -content_title -content_description I want to write a query to display only content from a … |
| | Hi everyone! So, I'm trying to create a program which users can add, update, delete, view, and search records but I am having a hard time about updating records in my database. In my Update form, I've got 1 dropdown menu or option that contains ID number and when I … |
| | I'm using int type in my database, what I should put in order to catch the input data by users? mysql_real_escape_string is not working because I think he can cater only the string values. here is my codes. [CODE]<?php /* NEW.PHP Allows user to create a new entry in the … |
| | Hey everyone, I am trying to develop an addon for my admin area to send a text to my clients. I am trying to populate a select menu that will list clients that have added their mobile phones. I am using the following tables. [LIST] [*]tblclients [*]tblcustomfields [*]tblcustomfieldsvalues [/LIST] At … |
 | Any tips on how to connect them? COmments are highly appreciated. Thanks! |
| | Hi can anyone tell me how I add a row to a database table (gamescores) that will record a userID and the number of points they have gained. I also have to update two session variables and use them to update values that appear on the screen by adding code … |
| | How to get last auto number? I've got 2 tables I.e. booking and booking membership One person is the leader of a booking, but many people can be members of that Still, when I inse the booking I want to also do an insert into the bookingmembership table. The booking … |
| | Hi guys! I have company website created using PHP and mysql database. I am not a programmer but know few things about ftp transfer etc. We happen to change our web server and for that had to transfer the file to new location. All the files are intact and even … |
| | When People are trying to insert an sql inection, that time mysql errors displays the table name with the column names, how can I turn off this, My site is built in MVC framework, and this is how developers have queried the database, [CODE] $offset=0; if(isset( $_GET['offset'])) $offset=$_GET['offset']; $array_list=$DB->q("select *,users.user_list_id … |
| | Hi was just wanting to know that if your using variables do you write it like this: INSERT INTO table_name VALUES ($name) or do you leave the $ out? |
| | Hello Everyone, I am having a very basic problem in PHP MYSQL. My requirement is to add images in MYSQL through PHP along with the username. I have managed to store images in MYSQL but I dont know how to store username along with that image uploading query. Just like …  |
 | Hello, how to create mysql database and grant privileges via php code I need to created a new database with new user and to set privileges for this user within my php script, how can i do this? Regards, TitoSd |
| | Good Afternoon, I have a bit of a dilema, maybe 2 or 3... I have a members table in MySql, that includes a field called join_date which is designated as DATE type field I have 7 position tables named position_1 thru position_7 These each have a field called create_date which … |
| | Dear all, Am half way through my computer lab management project. to generate the timetable automatically i've written an algorithm. and for it to work i need an sql query that can : table-> ttprofile: id lab_name subject_name. now i looked every where, is there a command to take the … |
The End.