6,934 Topics
 | |
| | index.php code <html> <head> <meta charset="UTF-8"> <title>Our Local site</title> </head> <body> <form action="welcome.php" method="post"> <input id="t1" name="t1"type="text" placeholder="table name"><br> <input id="s1"type="text" name="skill[]"placeholder="skill or item or spec"> <input id="s2" type="text" name="skill[]" placeholder="skill or item or spec"> <input id="s3" type="text" name="skill[]" placeholder="skill or item or spec"> <input id="s4"type="text" name="skill[]" placeholder="skill or item …  |
| | Hey guys, I need example of simple site that stores registration of students and for each student shows what class can he/she go depend on what college they are registered to, so its bassicly just words and everything static. The registration page and database is not problem, but checking to … |
| | <html> <head> </head> <body> <script type="text/javascript"> function ajaxFunction(choice) { var httpxml; try { // Firefox, Opera 8.0+, Safari httpxml=new XMLHttpRequest(); } catch (e) { // Internet Explorer try { httpxml=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { try { httpxml=new ActiveXObject("Microsoft.XMLHTTP"); } catch (e) { alert("Your browser does not support AJAX!"); return … |
 | I tried updating my data like so but it doesn't work <?php require("config.inc.php");//this piece of code us for authentication and it works fine. if(!empty($_POST)) { /** the values below in the POST are valid not empty values **/ $shell = $_POST['shell']; $reporter = $_POST['reporter']; //query $query = "UPDATE `shellingdb` SET … |
| | hi i created login page using php and mssql but i got an error **"Fatal error: Call to undefined function mssql_query() "** **heres my log in code** <form name="log" action="log_action.php" method="post"> Username: <input class="form" type="text" name="name"><br /> Password: <input class="form" type="password" name="ssn"><br /> <input name="submit" type="submit" value="Submit"> </form> **log_in form** …  |
| | Hi Guys I am trying to display friends of a logged in user for my website, the user(person1 is friends with person2 and I would like this to display when either person1 or person2 log in( this should be under the hyperlink) Friends. and also to be able to see … |
| | Hi there, Thank you for accepting me within your community My name is Bernard, I'm a French-speaking Belgian citizen living and working in Thailand since December 2003. I'm not an IT expert. I've been using VBA since Excel supports it (Excel 5-1995?). I work here as a school administrator and …  |
 | i'm new learn php and mysql and i got stuck can't get better logic for my brain i want to get message from page if i type url like **index.php?user=user1** and page will show with data table and if username doesn't exist and page show no username found so this … |
| | This is the scenario: I have one table (main_tbl) with columns RECID(primary key),JOBNAME(text),STATUS(text). Now, I created an application that will query to the database and get one jobname and update the status. How can I make sure that multiple users wont get the same jobname when they executed the query …  |
| | HI, I a have inhrited administration of a work database. we currently have the ability to export data to a xls file from a customers table, but i want to add employers information from the employers table i.e employers name, address etc along with each record exported. This section deals … |
 | hello world, myself kishan kumar, iam new to web developing...my task is interrelated to edit,save & cancel....which is similar to edit button in shine.com...Iam doing in php language.the work is when user clicks on edit button he must be able to edit and after on editing he can save it … |
| | Good day, I need some advise. I have two database servers(primary & secondary) and both has installed the MS SQL Server 2008 r2. The idea is, the secondary server should setup as standby in case the primary servers down. How do I set it up? thanks in advance.  |
| | Hi guys hope your all well, I want to put a quiz into my website that I'm doing. I've found some code for a Multiple Choice-True False Quiz Here is the code, (yes I know its long and there are some reputation in it) You have to add questions by …  |
| | Please help me to connect my forms I created in Visual Studio 2010 to Sql server 2012. |
| | Anyone will help me to solve this? this is about ER diagram and some other stuff about database. This is the exercise: ----------------- "Project a DataBase to support a architectural studio which offers its customers proposals refurbishment. Each component of furniture ( table , chairs , ... ) is characterized … |
 | what i need is a single set of output for each procedures, but my this query is giving me 2-3 sets of answers, between this time period.. i need distinct set of answers.. if(isset($_POST['submit'])) { $to= $_POST['to']; $too = date("d/m/y",strtotime($_POST['to'])); $from= date('Y-m-d');; echo " <br><h2> PROCEDURE REPORTS UPTO <b>'$too' </b> … |
| | I am importing data from an excel worksheet in to a sql table, one of the columns in the table is set to nvarchar(50), the data i am importing are barcodes, but the problem i am having is the column is changing the data for example the number "5900397732209" is … |
| | I am developing a C# Windows Form Application. Now i am trying to select value from Listbox and load corresponding value in List view using the stored procedure. And this is my stored Procedure: ALTER PROCEDURE [dbo].[spPOExport] @BST_BESTELLUNG INT AS BEGIN SELECT BH.BST_LIEFERANT AS Product Name, BZ.BDT_REFNUMMER AS Unit Price, … |
| | Having problems with a malware I had to reinstall Win7 OS with recovery mgr.After I had to reinstall all my web development tools such as Visual Basic Express 2008, Visual Web Developer Express 2010, SQL server express 2008, MySql, Workbench.I cannot reinstall PHP and PhpMyAdmin no matter what I try. … |
| | Hello, I am new to C# and i am stuck when i try to fetch the data from SQL Server to Visual studio. I am writing the code as a n-tier application - Data Access, Business logic and the front end. I am fetching data in a disconnected env. I … |
 | how to edit in the post in php? i m using update query but no working? can anyone suggest me any idea and please give me suitable example |
| | Hi all, I've a problem with my insert sql..I didn'y know why. here is my insert sql $goodsDesc = $_POST['goodsDesc']; $k8goodsQty = $_POST['k8goodsQty']; $valuePerUnit = $_POST['valuePerUnit']; $sql_k8goodsIn = "INSERT INTO k8_goodsin (k8regID,goodsDesc,k8goodsQty,valuePerUnit) VALUES ( '".$k8regID."', '".addslashes(strtoupper($goodsDesc[$y]))."', '".$k8goodsQty[$y]."', '".$valuePerUnit[$y]."')"; for goodsDesc the input is like this goodsDesc = 2-1/2" suction pump … |
| | here i have 3 tables. i want to display OfferDescription,OfferImage,offerPath based on spaid.becaz offerimage and offerdescription are added by using array.so its in different table. if i add companyname and 2 offerimage and 2 offerdescription its added in this 3 tables.after i have to display based on spaid value.i tried … |
 | I have a php page which is logged in with a user account. Now i want to change my password here, also I'm getting two errors here. "Notice: Undefined variable: password in C:\xampp\htdocs\fyp\cms\cms-settings.php on line 73 Warning: mysql_affected_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\fyp\cms\cms-settings.php on line …  |
| | I'm wanting to create an sql table, when a user registers at my site. This table will eventually be used to log messages. The code follows: <?php require('../connect/kidsblogsconnect.php'); $name=trim(mysql_real_escape_string($_POST['name'])); mysql_query("CREATE TABLE '$name'('sender' VARCHAR(30), 'message' VARCHAR(300), 'dateposted' DATE)") or DIE(mysql_error()); ?> When I run it, I get: You have an error … |
| | Hi, I have created a databse using sql database "TestingSQL" using microsoft management studio 2012 and created a simple vb application as a tryout. It works well in my pc and i would be able to access remotely as well. But the problem is, it is only works with my … |
 | I found this along my way of trying to learn how to use databases 1."SELECT usname, password FROM userinfo " & 2." WHERE usname = '" & textbox1.Text & "'" & 3." AND [password] = '" & textbox2.Text & "'" I would like to know how I would execute code … |
| | for pagination i need to display number of data.here is my query but am getting error like 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 'st.state)as num from spa s left join relatedcatagories …  |
| | I have a 2 column SQL table as follows: **Product Price** Drill 20 Hammer 15 Screwdriver 5 Screws 2 Nuts 3 Bolts 6 I eventually want to embed a PHP array into a Google charts script. But first, how do I pass my SQL query into an array? My code …  |
 | HI, I have a common page (sqlhelper.cs) where i am preparing command and executing execnonquery,... But veracode addressed sql injection flaw 89 in the following code saying issue with parameters. How can skip this verification?. any extra validations i need to put in the following code? Please help. private static … |
| | Hello, I need to run a report against a database, and I am having a difficult time thinking of a way to run a particular report. What I need to do is run a report which selects students that have no course registrations for three consecutive semesters. The semester table … |
 | I have 1 or actually 2 problems. I have 2 sites, the first one generates a table with avatar, coins, and name (which links to a more detailed view like this `/stats/user/?name=<dynamic name>`. It looks like this: <table> <thead> <tr> <th>#</th> <th>Points</th> <th>Name</th> </tr> </thead> <tbody> <?php error_reporting(E_ALL); define ( … |
 | I have a bunch of insert querys running and some of them fail with a duplciate entry. I want to see a log where it says "Error: Duplicate key" and that tells me the EXACT INSERT query that fails so I can see what keys are duplicated. Thanks  |
| | Hey there. I'm trying to retrieve a date from an SQL table. The original formate of the date is as follows: 0000-00-00 00:00:00 I want to try and change the format into: Month Date, Year e.g. May 17, 2014 <?php $page_title = 'View the current users'; include('header.inc'); require_once('mysql_connect.php'); try{ $query … |
 | Hi all I need some advice making my query work properly. I already played around it a dozen of times and still can't get it work. So as my last option im here:) . what im trying to achieve is sum all amount of a particular rows and display the … |
| | I have an identity (auto-increment) column in my mssql table, which is also my primary key. I want to use these numbers on my form, such that when I open that form, the auto-increment id will already be displayed on a textbox (so I wont have to type it in … |
| | Hello Below is the schema with sample data of table es_preadmission  I am trying to get the number of male and female students from each categories (GEN, SC,ST,OBC), bpl, sgc, handi,ser_cat class wise. Example class 1 => GEN => Male = 3, class 1 => GEN => Female … |
 | I import a spreadsheet (csv) into my sqli database (keeps a track of all our firewalls) there are 10 excel columns , one for each connected network on the firewall. i would like all these columns to be imported as one entry in the database, so 1 database field would … |
| | i have 3 tables and i want to display companyname,maincategory,city,place 1.SELECT `id`,Companyname from spa 2.SELECT `id`, `mainCatagoryid`, `RelatedCatagory`, `spaid` FROM `relatedcatagories` SELECT `id`, `MainCatagory`, `name`, `size`, `path` FROM `catagorykeywords` SELECT `id`, `Subcatagory`, `MainCatid` FROM `subcatagorykeywords` 3.SELECT `id`, `city_id`, `state_id`, `spaid` FROM `city_place` SELECT `city_id`, `city`, `state_id` FROM `cities` SELECT `state_id`, … |
| | I have a table called "mytable". The columns are Time_Stamp (datetime) PK Time_stamp_ms (int) PK data1 (int) data2 (int) data3 (int) data4 (int) data5 (int) data6 (int) cycle (int) name (varstring) I want to order by Time_Stamp and Time_stamp_ms and then each time cycle reaches 1, I want to get … |
 | Hello how to connect Sql form to save and read information from Ini File?  |
| | below is the code which select value from the database and increase it by 2 and update the database with the new value. how do I lock or prevent multiple read and update at the same time? please help Dim query2 As String = "select * from " + usern … |
| | I have a Visual Studio form that is linked to a SQL database table. I am adding a query via a tool strip to search the database and I have the following text boxes the user can enter information into: Client, Project Number, Project Manager, ServerArchived, PaperArchived. The user does … |
| | i have a text field with name "date" and i want to retrieve all he records from database when user write a specific date on that text field.......I am using MS access data base......Query below is not showing any record String date=request.getParameter("OrderDate"); String query = "SELECT * FROM DoorStepRequests where …  |
| | hey so im trying to save data but i get error: `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 'WHERE event_id = '8'' at line 1` this being the line: `$sql = mysql_query("INSERT … |
| | hi there, i am getting this error while activity monitoring on sql server 2008 R2(SP2) and at the same time all the users application (i.e arround 200 users window user application) connected to the database in this server gets Hang and again starts functioning properly after 1 or 2 mins …  |
| | I want to check if txtCRCNum1 is empty or not. If it is empty, then some values from frmComm will get displayed on frmcrc (which I call the default values). If not empty, then it will execute an SQL query which will select data from the value of txtCRCNum1 and …  |
| | Hi, I have the below datatable created through my C# code: Stock TotalPrice Qty TransactionType XYZ 400 10 BUY ABC 800 20 BUY XYZ 800 20 SELL ABC 400 10 SELL I want this datatable to be processed by LINQ / LAMBDA expressions in such a way that will give … |
 | Hi Folks, I am having problem with my web design. I am making a query that involves two table but it doesnt do anything when i click submit. do i make mistake in the query ? my code is like this, <?php if ($_POST['action'] == 'show'){ $requestCompSql = "SELECT REQUEST_COMPONENT_CUTTING.PROJECT_NAME, …  |
| | I am new to Qt and I'm trying to connect a remote database. QSqlDatabase db = QSqlDatabase::addDatabase( "QMYSQL" ); db.setHostName("IP ADRESS"); // local or IP db.setPort(3306); // Default port is 3306 db.setUserName("DB USER"); // example root db.setPassword("PASSWORD"); db.setDatabaseName("DB NAME"); if( !db.open() ) { qDebug() << db.lastError(); qFatal( "Failed to connect." … |
The End.