Server :: Use PHP To Insert/select Data From The Database?
May 29, 2010
I have a LAMP server. I know sql but I'm currently learning PHP.
Correct me if I'm wrong, but you're supposed to use PHP to insert/select data from the database, right? If so, SQL shouldn't need a port at all.
Apache uses port 80, but it's listening for connections. MySQL uses port 3306, but I've never logged into it from anywhere besides 127.0.0.1/localhost. I have mysqladmin installed and it demands that I give it an IP so I used localhost.
I'm not interested in doing anything remote, so can I block this port? When I say "block" I mean on the router, not locally through iptables. Obviously I have to foward port 80 because that's how people would connect to my server. But once they connect and send something, my server would interpret the data locally and send it back on port 80.
View 8 Replies
ADVERTISEMENT
Sep 2, 2010
my database (PostgreSQL) has ever funtioned OK, but today don't let me insert a new row in a table and the record itsn't duplicated. I did a vacuum full and reindex the database and the problem continue. I don't know what the fuck is happening
View 2 Replies
View Related
Feb 19, 2011
We purchased a new database system at work last October, ditching the old system because of a lack of support from the vendor. This is a retail Point of Sale and Backoffice database system. I am not sure what system the new one runs on, but the system we replaced was a Firebird data base. The reason I am posting is because we are now in need of the information contained in the old database which was not completely imported into the new system. Unfortunately, we parted company with the old vendor under extremely hostile conditions, and they are not a source of help for this problem, nor are the new vendors.
Basically the problem is this: The database in on a Windows XP system and I found a copy of SQL Manager Lite 2008 on the system, which after quite a bit of studying, I figured out how to extract the database into a removable file. I have this file (178MB) on a USB stick in a file called Backoffice.fbd. I can get into this database with MySQL. All I want to be able to do get into the database and create tab deliminated spreadsheet files for each of the database sections (Customers, Repairs, Sales History, stock files, etc.) Is it possible to do this with Ubuntu and MySQL and if so, can an expert suggest one or two things to get me started.
View 3 Replies
View Related
Mar 4, 2010
I have try to sync my MySQL Server database and HLDS Data on lan,one is windows server 2008 and one is Ubuntu Linux 9.10 i have try to use the remote address(192.168.0.4:3306) but can't connect and say the error code is 10060 i have check the connect is normal and ok,the accont is can let any address to contro.
View 1 Replies
View Related
Aug 17, 2010
I m trying to store the output of vmstat 1 10 into a database.I have done the necessary homework to connect bash to interact with the database.Program logic.1)storing the output of vmstat 1 10 to a file named abc.txt2)I m applying a filter to vmstat to get desired output containing cpu(user),cpu(system),cpu(idle) values.3)
Code:
# cat abc.txt | grep -vE '(procs|free)'| awk '{print $13 " "$14 " " $15}'
0 1 97
[code]....
View 3 Replies
View Related
Mar 1, 2011
I need help about the error in my website. I have the following error....
Code:
user warning: Got error 134 from storage engine query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'theme_registry:database1' in /var/www/html/web/includes/cache.inc on line 26.
View 2 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
Nov 6, 2013
I have mysql installed successfully. I can insert rows into my table using phpMyAdmin. I can successful retrieve those rows in PHP with a select statement. However, I cannot insert or update rows from PHP. I get no error messages and everything appears to be working okay, just no results in mysql table.
View 0 Replies
View Related
Apr 13, 2010
I'm trying to make a combo box which should have elements dynamically taken from a database. I've an Exam Table,and it has columns Sno,Ename,Month,year. i need the combobox to list to the elements that are present in Ename.
i read some things in the web and tried that out in the netbeans. it said to rightclick the combobox and set bind ->elements and bind->selecteditem. But i'm not sure how to set the binding expressions inorder to get the required list in the combobox.
View 1 Replies
View Related
May 6, 2011
Error: Cannot connect to the database because: INSERT command denied to user 'webuser'@'localhost' for table 'visitor'
[Code]...
View 3 Replies
View Related
Dec 13, 2010
Following is the declaration:
Code:
std :: map <QString, std :: vector <std :: pair <QString, QString> > > configFileDataVector; How should I insert data in it? All the examples which I have looked up in Google are of plain maps!
I tried this, but it failed:
[Code]...
View 4 Replies
View Related
Feb 18, 2011
I use ubuntu lucid 10.4. I would like to monitor stock prices in realtime with a web browser and generate spreadsheets. Is there a program to scrape the data from the screen and put it into an openoffice spreadsheet so that I can categorize the data appropriately? I would like to do this in realtime if possible. Perhaps a firefox addon or chrome extension. I have searched for this for a while and think I may have to write my own code, which would be okay, but I imagine that there is some open source code out there that would work or can be changed a little to suit my needs.
View 3 Replies
View Related
Apr 16, 2011
Reboot and select proper boot device or insert boot media in selected boot device and press a key. I got this error after: Reducing my Windows 7 partition by about 100gb. Creating a new partition (100gb) and copying my Ubuntu partition (10gb) to the new partition. After it was copied, and pasted, the original partition was deleted. I now had two partitions a new 100gb Ubuntu partition and a 600gb (or so) Windows 7 partition.
All of this was done using a bootable USB with Ubuntu 10.10 and GParted partition editor. Now when I boot I get the "Reboot and select proper boot device or insert boot media in selected boot device and press a key." error.
View 9 Replies
View Related
May 29, 2011
Please tell me spesification if i want buid mail server on ubuntu 10.04 with good features :
1. For MTA ??
2. For Mail Filtering ??
3. For MDA ??
3. For Webmail ??
4. For Mailling List ??
View 3 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
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
Aug 26, 2010
I have a CSV called source1 with data like:
Date12:00:00 AM12:30:00 AM01:00:00 AM01:30:00 AM02:00:00 AM02:30:00 AM03:00:00 AM ...
07/31/1051.5252.4852.6452.863.3663.8445.6 ...
08/01/1049.4449.9261.2860.1652.6449.1247.52 ...
08/02/1049.1248.9648.9650.7260.1658.0851.04 ...
08/03/1060.3260.6459.260.9637.9233.2832.8 ...
[Code].....
Also, the CSV file is updates every few hours and I need to load any new data from the file to the database without creating duplicates of data that has already been loaded to the database.
View 6 Replies
View Related
Sep 23, 2009
i wanted to capture the stdout and stdin of a child process within a parent so that any output of child is sent to the parent and any input taken from the parent. code is simple enough and i have followed all code guidlines on the internet (some guidlines do differ also) my select call either hangs if i do not give a tmeout and with a timeout it returns 0 descriptors to be written to or read from:
below is the simple code for parent:
int main(void)
{
int outfd[2];
int infd[2];
[code].....
why select hangs without a timeout ... why can it not detect that the pipe is write ready i.e parent can write to it ... if it does not detect tha read pipe as having data...
View 5 Replies
View Related
Jun 22, 2015
This is a continuation of the post in [URL].... . What has happened is that I have a huge log of 600 MB + and do not know from when the data is in there.
Code: Select all┌─[shirish@debian] - [~/.config/quassel-irc.org] - [9714]
└─[$] ll -h quassel-storage.sqlite
-rw------- 1 shirish shirish 647M Jun 22 21:15 quassel-storage.sqlite
So I need to know if there is a way to get just the first five or ten entries listed as one can do using head, tail etc. I did try just using head but it was unsuccessful. The second thing would be deleting some days, weeks or months data from the existing sqlite log. I did see URL... but in my case I am deleting old entries in the sqlite log and also do not know if sqlite makes backups of the data or not ?
View 4 Replies
View Related
Jun 12, 2010
I want to download some specific information(age of the building, value, square feet, etc.) from a county auditor's website:[url]
For every property in the county and ultimately match it to a .dbf file I already have containing geographic information for each parcel.
The website only displays information for a single address at a time in response to a query form asking for either the parcel ID# or street address. I have a table of all the county's parcel ID#'s and valid addresses-about 350,000 or so of them.
I imagine there must be some way to automatically crawl the website inputting the information from my tables into the form and gathering specific information in some sort of format that could then be matched to corresponding information in my .dbf file.
View 1 Replies
View Related
Apr 6, 2010
I have a firewall, this consists of three NIC's:
Code: eth0[192.168.0.2] eth1[192.168.1.2] and eth2[10.10.165.2]
I am trying to ping eth0 from eth2, but I am not able to succesfully get a response from pinging the device, I am using:
Code: ping 192.168.0.2 -I eth2
I have tried to insert routing data into the routing table, but it still doesn't work
View 2 Replies
View Related
Jul 8, 2011
I recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?
View 2 Replies
View Related
Jul 10, 2010
especially to ubuntu server 8.04 because it doesnt use a GUI. Now my question is on how to insert IP address in configuring DNS server using bind9. Actually i'm using this guideBut i m not sure on how to insert IP addresses on the primary master and secondary master. Should I insert the Ip address that i found when i type ifconfig ? or Should I assign a new IP address.I have set up a webserver, DNS server, File server and mail server on a virtual box. For now, at first, im working with the DNS server or should I work with the web server first?what should I do?
View 1 Replies
View Related
Nov 28, 2010
" Mark the start of the text with "v", "V" or CTRL-V. The character under the cursor will be used as the start.""With CTRL-V (blockwise Visual mode) the highlighted text will be a rectanglebetween start position and the cursor."I can mark the start with "v" or "V".But it doesn't work when I push ctrl+V.
View 14 Replies
View Related
Jan 1, 2011
Have anyone try the latest Debian 5 iso CD? I got installation problem. It is the select and install software stage. If I select only
Code:
[*]Desktop Environment[*]Standard
I want to select web server, email server, the installation fail.
View 4 Replies
View Related
Sep 24, 2010
i downloaded Ubuntu server from here, choosing 32-bit:[URL].. i burned the image to a CD. i booted it, and tried to install it. i went through a bunch of screens before it started to install. after a while i got an error message that reads: "Please insert the disc labeled: 'Ubuntu-Server 10.04.1 LTS _Lucid Lynx_ - Release i386 (20100816.2)' in the drive /cdrom/ and press enter."
i don't understand this message. when i downloaded Server there was no message to save a second file for a second CD.
View 4 Replies
View Related
Jul 27, 2011
i downloaded Ubuntu server from here, choosing 32-bit: [code]... i burned the image to a CD. i booted it, and tried to install it. i went through a bunch of screens before it started to install. after a while i got an error message that reads: "Please insert the disc labeled: 'Ubuntu-Server 10.04.1 LTS _Lucid Lynx_ - Release i386 (20100816.2)' in the drive /cdrom/ and press enter." i don't understand this message. when i downloaded Server there was no message to save a second file for a second CD.
View 3 Replies
View Related
Nov 3, 2010
I'm trying to move a mysql 5.1.50-community InnoDB database from one location to another.When starting the service I get:Starting MySQL.Manager of pid-file quit without updating file [FAILED]I've searched for a way to do this but I can only find people who describe what I've just done.
View 6 Replies
View Related
Apr 26, 2011
I have implemented a web application on Linux that I want to deploy and sell to customers. I want to sell ready systems including the hardware. The application is written in PHP/MySQL. What I am searching to achieve is :
1) Find a way so that filesystem and partitions to be encrypted but without the need to insert some code when rebooting. So that if someone gets out the hard disks and attach to another system, cannot have any access to my files or settings. And of course when rebooting (e.g. after a power failure) encryption to be applied automatically.
2) I know that there are ways to bypass root password on a Linux system. Can all these ways be unassigned ? I want the only way to have access to system, to be by using the root password and nothing else.
I have thought of using a virtual server instead of a physical one (like deploying a virtualbox server) but still would like this to be the most secure possible including not only remote but also local access to system.
View 5 Replies
View Related
Apr 15, 2010
I'm having trouble with my database server run with PHP & MYSQL; i just installed this system on a SUSE Linux Enterprise Sever; the Server its self is an HP Proliant ML370G with 4GB RAM
The system was fine for like 3 weeks until recently when it started slowing down. Apparently, eveything is normal when you are accessing the server, for example when you are browsing on the database web interface; but problem is when you start working in the database, when you try submitting into the database, its really slow on processing, i have to first restart the mysql;
Could it be RAM? or the SQL itself?
View 3 Replies
View Related
