Programming :: Check If There Is Such A Value In The Database
Feb 10, 2010
sql statement. I am trying to check if there is such a value in the database.
Code:
string NewMovie = "ww";
string queryText ;
queryText = "Select * from movie_info WHERE movie_title = '"+ NewTitle +"'";
MYSQL *conn;
conn=mysql_init(NULL);
mysql_real_connect(conn,host,username,password,database,0,NULL,0);
[Code]......
return 0; The problem i am facing is how do i check if the value is found. I read up and found that a query will return a value of TRUE if the query is a success and a FAIL if there is an error. How do i call these values and then based the check on it?
View 1 Replies
ADVERTISEMENT
May 28, 2010
Because I was getting some package errors, I ran the Repair Installed System option that shows up after boot. During System Check when earching for package databases,YaST2 is not able to find /var/lib/rpm/Filemd5s. After a while, a YaST2 box pops up and says that it Successfully rebuilt the package databaseïbut I get the same error when I run System Check again. I've chosen both Rebuild Package Database as well as Revert to Original Package Database (saved by YaST)In both cases, it saysat it was successful, but the same error occurs the next time I run System Check
View 7 Replies
View Related
May 4, 2011
I need to check with nagios an oracle database that is located on a server. There are a lot of plugins that are provided, the problem is that the database is located on a remote server (i have an hostaddress) and then i need to log on the database (i have username and pass)So i only need to have a plugin that connects to that hostaddress and logs on, but i can't find any plugin which does that
View 14 Replies
View Related
Oct 27, 2010
I'm running zoneminder on Ubuntu 9.10 Even with a UPS the power quite often fails enough that I need to drive over bring home the computer and run ( mysqlcheck --all-databases --auto-repair -p ) Then enter my user PW then my Mysql PW. Both are the same. How ever if it were possible to create a script that could run at start up I could get anyone to cycle the power and let it fix it's self.
View 6 Replies
View Related
Aug 19, 2010
I want to put check menu & check list in utility dialog.i dont know how i do this
View 1 Replies
View Related
Jan 27, 2010
What database can I use for c++?,this is my first week programming in c++.
View 14 Replies
View Related
Apr 7, 2011
How to create a database using c language it includes structures, pointers, arrays and switch..
View 4 Replies
View Related
Apr 26, 2011
I have a php scriptI want it to ping list of ips from a databse(using fping) and based on the status of the values to put them in a field(status) into the database(0 if down,1 if up)i executed tghe script and it gives me this error:Thread 1 - 17:51:01 26-04-2011 4.2.2.2 alive Couldn't execute query.I cant see what 's wrongthis is the source of the php script:
<?php
require_once("conf.php");
$connection1 = mysql_connect($h, $u, $p) or die("Couldn't connect.");
[code]....
View 1 Replies
View Related
Apr 26, 2010
I have created a database which stores students grades for different stages of a project. One of the stages of the project is the specification part. I have a simple bit of html code which is going to be used as the searching facility. I want the user to be able to enter their ID and then it will display only their results. At the moment, it is displaying the results for EVERY student because I cant seem to find the correct syntax for my statement.
Heres the HTML code
<html>
<head>
</head>
<body>
<body bgcolor="#6881bb">
<center>
[Code]....
At the moment when i click the button, no matter what I enter every students marks appear on the screen.
I think, but obviously dont know for sure because if i did i would know how to solve the problem, the code that i need to change is in green.
View 3 Replies
View Related
Aug 9, 2010
How to shorten the long URL without using database(i.e. without storing url entries in DB)?
View 2 Replies
View Related
Jan 5, 2009
I am trying to unload file from a database. Which contains few lines with the character below. Rest of the data was unloaded appropriately.
Code:
a) What does this below character means?
b) How can i remove it,
I already have
Code:
sed '/^$/d'
c) Will this effect the file by any means (If I am guessing properly, this is the eof notation)
View 5 Replies
View Related
May 12, 2011
i get some trouble setting up good environment in linux.i have problem regarding connecting php(under linux) to a sybase server(under windows)is there anyway connecting this two technologies?.
View 1 Replies
View Related
May 23, 2011
I have a (rather large) database of mp3 track information. I also have several directories of the actual mp3s. I'm trying to write a simple bash script that will check the contents of the directories against what's in the database, and upon finding a file that isn't in the database, do something.
Here's what I have so far:
Code:
The trouble I'm having (in the sample directory of "/mnt/music/B/Beatles, The/" the file "Beatles, The - Taxman.mp3" isn't in the database.) is getting it to actually trigger an error when an entry isn't in the database.
Once triggering on a non-entered file is working, any way to get it to traverse the entire /mnt/music hierarchy?
View 13 Replies
View Related
May 3, 2010
I'm trying to migrate my company server to linux, but i have a program that is designed in access what is the best way to move access tables to a mysql database so that i can program it in PHP?
View 3 Replies
View Related
Oct 12, 2010
I've just installed the Oracle Instant client using this: https://help.ubuntu.com/community/PHPOracle
The phpinfo() show me that oci8 is enable, but when I try to query that database I've got the following message:
PHP Code:
Code:
How to troubleshoot.
View 2 Replies
View Related
Apr 29, 2010
How do I do this? I wish to store the pictures via a "Browse" button on the webpage, and later display them on a particular page on the site.
View 2 Replies
View Related
Apr 13, 2011
I'm getting duplicate entries in mysql database when submitting a new item from a form. I initially loaded the database via IMPORT function in phpMyAdmin. This is my input form:
<center>
<br />
<FONT SIZE="5" ><b>Add Item Template</b></FONT>
<br />
[code].....
However, I do need to return the input form in order to keep entering new items into the database.
View 8 Replies
View Related
Feb 20, 2011
According to Wikipedia's PHP page, PHP "is a general-purpose scripting language". Does that include being suitable for duplicate files detection? More specifically, the task is collating files from workstation backups into a single place, preserving directory paths and replacing duplicates with hard links. This will be a regular task on a lot of files so performance is important; our current proof-of-concept solution uses a PostgreSQL database of file "fingerprints" to speed duplicate detection. Does PHP have PostgreSQL integration?
I am asking these questions as a follow-up on an earlier thread asking for programming language recommendations for this task. Since then I have learned that PHP skills are available locally.
View 8 Replies
View Related
Jul 15, 2009
For Perl I need to understand a few things. It's unlikely that anyone will be able to give me direct answers but if they could point outI'm trying to hack down an existing script http://eoylpac.org/source/eoy.pl. What I need to be able to do (in a nut shell):1. Open a database2. Read the values for each uniq id and execute a subroutine for each of those values. (The subroutine already exists in the above file 'do_pdf').
View 5 Replies
View Related
Jun 17, 2010
I was wondering if I can show an image on our php site if we store the path to it. For example if we get the result form my sql as:
images/example1.png and the handle the result as common html.
< img src="databaseresult" width="173" height="188" border="1" / >
is this possible? do you think theres a better way to do it?
we need to store the images locally we cant use a blob space on the table.
View 2 Replies
View Related
Sep 9, 2010
As I am Carrying out a project to Design Social Networking Databases, I need 5 tables for designing it.My frontend being php and backend being Mysql.I need to know what are the 5 tables I can have and how to implement them.
View 4 Replies
View Related
Feb 9, 2010
I want to insert values into a MySql database. The following line works fine:1
Code:
mysql_query(connection, "INSERT INTO main (NumofShows , Title) VALUES('12', 'Home')");
but if the data to be inserted is from a string... like....
Code:
string NewTitle = "Monaco";
string NumofShows = "2";
How do i edit my sql statements so variables can be inserted into the Values ( ) , and it will be able to read the variables and then store it into the database.
View 4 Replies
View Related
Apr 7, 2011
creating the below unix script to run in oracle database .I need a script which should do the following things.
1. The script should insert row count of a table from one database(A) into table (AB) in another database(B).
2. The script should update tow count of the similar table and tablespace from database (B) in to a table AB.
3. The script should update the status column of the table AB as: 'Y' if the rowcount of the table@A and rowcount of the table@B matching. or else it should update 'N'
View 4 Replies
View Related
Jul 24, 2013
I have a MySQL database running on my local server, which I currently access via laptop, desktop using HTML/PHP.I want to re-write in HTML5, I have gone through a couple of HTML5 tutorials but cannot figure out the database interface. The best match I can find is Server-Sent Events, is this the best way forward? What about writing to the database? I have found several suggestions using Web SQL database but I don't think this is suitable as my database is also accessed from Python code on the server.
View 5 Replies
View Related
Jul 19, 2010
I have set up a MySQL database which has only three fields for user-name, password and index number. But there is a LOT of data (thousands of columns) which would take too long to enter manually. I'm sure MySQL must have a file format whereby a single large file containing different data types can be successfully automatically imported and the various data elements distributed to their intended fields. Does anyone know which characters MySQL uses as field seperators for this formatting of data, or is there a program already written which can take raw data and organize it into a SQL compatible file?
View 8 Replies
View Related
Jul 21, 2011
1. i need to check whether the oracle database is running or not if it is running it will run auto mount script.nohup /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbfs_client dbfs@xxxxx -o allow_other,direct_io /u01/app/oracle/DBFS/XXXXX < /home/oracle/passwd_dbfs.txt&nohup /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbfs_client dbfs@xxxxxx -o allow_other,direct_io /u01/app/oracle/DBFS/XXXXX < /home/oracle/passwd_dbfs.txt &2. For every 1 hour i need to check above mount points is mounted or not if it is not mounted it should be mounted.
View 3 Replies
View Related
Jan 27, 2010
How to connect to remote oracle database using perl?
This is what I tried.
Code:
But I am unable to connect.
View 4 Replies
View Related
Apr 13, 2011
I have a need of a database, and the information to go into it. I know how I want to organise my data for optimal cross referencing, but what I know is merely what I know and I do not know if what I know is what is known...
Madness to say... looking at my database I see this is the best way to organise the data, but what I do not know is how the computer will respond to my methodical madness.
Is it quicker to have one table with many fields or many tables with few fields?
We've got information for 10 users with 17 idiosyncrasies.
So, would one table with 17 columns and 10 rows... or... a group of 50 tables with one column and 3 rows and one table with 4 columns and 5 rows...
Be more efficient concerning:
QUERIES...?
Searching?
Comparison?
Insertion?
Deletion?
Modification?
The queries and modifications will be daily, and constant. These numbers are really much larger but the math is easier for me to articulate on a smaller scale. I use Perl, php, and C with SQL for management.
View 14 Replies
View Related
Jun 20, 2011
i am new to python programing and i have a couple of ?'s
1- what would i do if i needed to find the closest, bigger number, from a list of numbers when the user types a number in.
2- (windows) i need a program that can compile .py files into a .exe file so that it works on a machine without python it also needs to work with python 3.2.
View 8 Replies
View Related
Apr 21, 2010
I have recently trying to build an Accounts system database for a project. When you run the program it goes in the main menu sort of like this.
Accounts System
Add a Customer With a Contract......1
Add a Customer Without a Contract...2
Display all Customers...............3
Find a Customer.....................4
Edit a Customer.....................5
Print a Statement...................6
Print an Invoice....................7
Load File...........................8
Save and Exit.......................9
When you add a customer with a contract, you add name, address, start contract, end contract, payment and email address. Now, is there a code I could write to get back to this menu. To not confuse anyone, all I just saying is supposing I accidentally push number 1 on the keyboard and suppose I didn't want to add a customer. In other words I need a code that can cancel (or stop) adding a customer to go back to the accounts system menu.
[Code]...
View 3 Replies
View Related