Posts Tagged ‘mysql database’

Im planning on a new setup for our office, a Linux server that will have the mySQL database, all other terminals have windows OS like WIn98, Win2000 and tey will need to access the database from the Linux server how to do it?

I know how pull data from the database but I have stored within the a mysql field some text data. Within that that text I have put in some php variables. The problem is that when the browser renders the data that pulled from my sql, the variable stays as $user for example rather than changing to what I needed to. Is there any way to have the server process the php code stored within the mysql database?

I’m making a php script that will get a user-inputted number and then search a MySQL database for that ID then read all the information off of that row. I’m sure there is a function that does this since looping through thousands of entries is so inefficient. I’m just not sure what it is.

I’d like to be able to run/test my PHP programs on my desktop, instead of constantly uploading them to my server to run, and have to deal with constant use of phpMyAdmin. So how can I run a php environment and mySQL database on my Windows Vista desktop? (Free programs, if possible.)

I have a news system and I only want to display 4 or 5 posts when the script gets all the post information from the database. Is there a way I can do this right in the initial database query, or do I have to do it in php after the results are returned and how can I do this? Thanks.

I have a fairly detailed plan of the content and features of a website project I will be doing. How do I plan my php mysql database layout?

i am trying to set the date and time (DateTime stored in mysql database) to a php DateTime object, one way is to override the class some how to make that happen, but is there any easier way than that?

e.g.
$date = new DateTime();
$date->setDate($mysql_resultset['date_time']);

and then format that date according and display it.

I have a MySql Database and I am looking for a good easy to understand script in php that will interact with my Database and pull the information to a new Microsoft Excel file.

Please attach any good links you know of. Thanks!

I have a huge PHP array that I would like to turn into a database. I was wondering if anyone knew of a could way of doing this or a place online that has good instructions. Thank you for any advice you can give.

2 database called Database2009 and Database2010, How to display both with same record in one line having the same ID Name, Address but different columns in Year2009 & Year2010 in one row as comparative report using PHP MySql….