427 Topics
|
|
Hi, I have these methods in my user class which check whether a username already exists and if not, inserts it into the database: //This function checks to see if the username entered already exists Private function check_user_exists() { $stmt = $this->_db->prepare('SELECT * FROM client_login WHERE Username = ?'); $stmt->execute(array($this->_username)); … |
|
I am trying to insert data into the database. It is a text area from html which looks like this where is says description. Everything else works fine. <table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC"> <tr> <form name="form2" method="post" action="uploadmachine.php" enctype="multipart/form-data"> <td> <table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF"> <tr> <td … |
|
i' saved the key names as column names in database.so i want to insert i all the values in database.with out mentioning the column names in the database. <html> <body> <form action="#" method="post"> Firstname: <input type="text" name="name"> Lastname: <input type="text" name="lname"> Age: <input type="text" name="age"> <input type="submit"> </form> </body> </html> … |
|
I have 2 tables: tblUser: +------+-----------+ | id | Name | +------+-----------+ tblItems(this table accepts multiple checkbox value depending on how many user selected): +------+-----------+---------------+ | id | items | name_id | +------+-----------+---------------+ `name_id` will get the value of `id` in `tblUser` I use this code to get the value … |
|
My linq query won't insert my data. What am I doing wrong? class Query { musicEntities db = new musicEntities(); public bool findArtist(string artist) { bool status = db.Artists.Any(w => w.Name.Contains(artist)); return status; } public void insertArtist(string artist) { if (findArtist(artist) == false) { Artist art = new Artist { … |
|
Hey all, iam new at PHP and i have a question. I do a select-query in mysql. $sql = "SELECT name, street, city, y,m,d, email FROM player WHERE `name`= '".$name."' or `city`= '".$city."' or `y`= '".$y."'"; The result i paste in a table like this. while($row = mysql_fetch_array($result)) { .... … |
|
A lot of code here. Basically I'm making an auction type site. This segment of code is for a user to upload a product: I'm pretty sure there isn't anything wrong with addproduct.php but for completeness I feel like I should post it. addproduct.php: <?php require_once('checklogin.php'); require_once('validate.php'); if(!isset($_SESSION['user'])) { //die("redirect"); … |
|
Hello Everyone... Can someone tell me what am not doing right here? Because am trying to insert a record into a database through a VB.net 2012 windows form into a MSsql satabase. Problems: When I write the codes without the insert statement, it will work well and open the connection. … |
|
hi friends, here is my problem i'm designing a page with no. of checkboxes but not able to insert its value in mysql... here is my php code: **<?php $host="host"; // Host name $username="root"; // Mysql username $password=""; // Mysql password $db_name="packtest"; // Database name $tbl_name="test"; // Table name // … |
|
Can someone help me... I am new to vb.net with sql connection and I can't fix this error : variable name '@date' has already been declared. Variable names must be unique-- I need this to be fixed "ASAP" Im running out of time here because of the error here is … |
|
Hi guys! I'm currently making an integration of 2 different web apps. I would to ask if is it possible to restrict adding duplicate data in your table. for Example i have two different tables from two different databases. App1_Invoice (from Web App 1 database) e.g. transno name amount App2_Invoice … |
|
i have a MySQL table with the following columns: employeeID, firstName, lastName, gender, salary. whenever i insert a new record for this table i want to be able to retrieve the employeeID of that record. how should i write the commands in VB.Net |
|
1.I have a MySql DB called 'scheduled' and table called 'messagelist'. The first field msgID is int(10). Rest all are varchar(20). 2.broadcasttext.php <form name="frmText" method="post" action="addScheduled.php"> 3.addScheduled.php <?php $host="localhost"; // Host name $username="scheduledUudk8"; // Mysql username $password="KeszRXqXo.)-"; // Mysql password $db_name="scheduled"; // Database name $tbl_name="messagelist"; // Table name $i = … |
|
I am trying to insert new records into an Access DB and getting some weird stuff. I get the data from a DBF table and load that into a dataset table and DataGridView with no problems. Then I loop through the ds.table and insert it into the DB with this … |
|
Hi friends! I have a piece of code that I think should be working just fine, but I wonder why it doesn't work, and I get an "Syntax Error in INSERT statement" error message. Here is the code to affect a table called "Users" in my Access database. Dim cmd … |
|
when new row inserting into mysql, then i want to dislplay some popup notification for few seconds in some page. so pls help me anyone ? thanx in advance :) |
|
Hi all! I have a problem - surprise. I want to swap the content of my <div> (with the ID "content"), when the user press a bottom. I have tried using these, but with no result: document.getElementById("content").innerHTML = "<script src=\"js/demo.js\" language=\"javascript\" type=\"text/javascript\"></script>"; $("<script src=\"js/demo.js\" language=\"javascript\" type=\"text/javascript\"></script>").appendTo('#content'); I can insert <p> … |
|
I need help!! What I want is when I add a new teacher, it will search the tblteacher_info. If there is already a record of that teacher, it will just update his/her record. If there is no record of that teacher, it will add his/her info in the tblteacher_info. I … |
|
hey, i need to insert a row into datagridview meanwhile it has to be updated in the database(backend) using oledb. thanks inadvance |
|
I got the insert and Delete Data/Row working for my DBMS. The deleteRow method finds the row that contains the same primary key from the database, passed on to the method, and deletes the row. With using the insertRow method, the data I added shows on up on the last … |
|
I have one table as movie. In that i have one field as 'image' in which i want to store the images. In my mca project, I m trying to make admin panel. For this when administrater is going to add movie details, at that time i want to store … |
|
Hi all, In the program I'm working on, I am making a form that submits data to an Access 2007 database. I can connect to the database fine and run a select query, but when I try an insert query I get an error: "statement contains the following unknown field … |
|
hi everyone. I have just started to program in php. I tried to develop a php code to retrieve data from a form and insert into a table created in Mysql. Here is my php code. This code gets executed when the user submits the form. <html> <body> <?php $con … |
|
Hi All, I have intermediate knowledge in VB.Net coding. I have searched the web to find help with my issue but to no avail. I mean I can't find one that is helpful though there are some in Web based applications. I have an urgent issue where I want to … |
|
Hello, Can we perform bulk insert for SQL data? I have the complete SQL data in text files. There are multiple tables and the corresponding text files. I tried to do the bulk insert but always got some new error. Please help me to get an answer. My code Imports … |
|
A Example for OLE DB I Compiled. Put back together for fun maybe. # Someone convert this to ASP.Net plz with a splash screen. # # Required Materials # 1. a vb.net compiler(visual studio vb.net express perhaps?) 2. Libzplay dll(your search engine will help) Imports System.Data Imports ESO.libZPlay Imports System.Data.OleDb … |
|
This is really hard to explain but I am going to try me best, I have an html page which displays a video player named brosweplayer.html, the code is this, <!DOCTYPE html> <html lang="en"> <head> <title>Untitled Document</title> <meta charset="utf-8"/> </head> <body> <video src="$name" controls="controls"> </body> </html> Now, I also have … |
|
what is the problem of my code...when i view it in browser and click the button insert there is an error message saying **"Syntax error in INSERT INTO Statement** Dim myConn As OleDbConnection Dim cmd As OleDbCommand Dim sqlString, BookingDate, CheckInDate, CheckOutDate, RoomNo As String BookingDate = txtBDate.Text CheckInDate = … |
|
Hi there, Just wondering if there is a way of inserting tuples into a table without specifying the primary key id. insert into myTable (username, password) values (value1, value2); Ok. When I use the above mentioned statement, it complains about duplicate keys. Anyone know why? shouldn't the key be generated … |
|
Im trying to get transaction details of a paypal account, which I was successful in doing so, but I get this long (what i assume is an array) but I need to insert the details into a mysql database. I've tried several foreach methods but apparently I am doing something … |
The End.