September 2008

September 28, 2008

MySQL - Install

alttablib posted video:


Screencast of the installation of MySQL on a local PC to run on a local installation of Apache for a home test environment.

Filed under Travel by administrator

Permalink Print 11 Comments

How to code a simple php dynamic dropdown form feild from mysql?

mysql
techgeek asked:


I been struggling with this all morning.
I am tiring to create a dynamic form field that uses data from a myself database but cannot seem to get it to work.
Anyone know how to code a simple php code for a single dropdown field form that pulls data from a table field on a mysql database.

Filed under Programming & Design by administrator

Permalink Print 3 Comments

September 27, 2008

How do I make a website with php and mysql?

mysql
thekidzonehome asked:


I am trying to make a website that makes it easy for me to edit the layout, menus etc. and I thought that I might use PHP for the website and use to load the content of each page from the mysql database into the PHP.

But then I thought that I might be able to do it the other way: create each page and load the menus and layout into each PHP page. How do most people do it? Which way is better, and which way should I use?
So should I create a main php page and load the content into it or should I create multiple php pages and load the menus into it?

Filed under Other - Internet by administrator

Permalink Print 3 Comments

Is Mysql table locking dependent on how many users will access the database at one time?

mysql
Hello asked:


My database is accessed;
-When form data is submitted.
-When i approve profiles one at a time.
-When users are rating(accessed twice in same script action)
-When users select hyperlinks which display database content in a web page.

Filed under Programming & Design by administrator

Permalink Print 2 Comments

How do you import data from an oracle database into a mysql database?

mysql
nikki asked:


3 tables from oracle are to be copied to and merged in mysql. Can it be done manually? Also, is it possible to make a program to transfer the needed data from one database to the other?

Filed under Programming & Design by administrator

Permalink Print 1 Comment

2008 New Year’s Resolution

jabcreations posted video:


Learn MySQL and meet a decent girl.

Filed under People by administrator

Permalink Print 8 Comments

How do I make mysql automatically add a timestamp when an entry is made to a table?

mysql
Carbonbased Lifeform asked:


When a visitor fills out a form, I want to know when the form data was submitted. So how do I make MySQL automatically add a timestamp on the data so that when I pull the data back up, I will have the submitted data in one column and the time the data was submitted in another column?

Filed under Programming & Design by administrator

Permalink Print 3 Comments

September 26, 2008

How do i build a interface to WRITE to my mysql database?

mysql
Eljacko876 asked:


I have been able to read data from my mysql database, However i find it hard to find documentation on creating an interface to write back to your Mysql database. Can u point me to a source with that specific info, or just give me general advice.

Filed under Programming & Design by administrator

Permalink Print 2 Comments

What is best way to store resumes in mysql?

mysql
Krakowiak asked:


I’d like to be able to upload resumes into a mysql database, be able to search them by keywords, and retrieve them when needed. Is saving them as Blob the best way? If not, which format should they be saved as? I currently have them saved as blobs, but can’t retrieve them, or search through them. I’d like to build a generic Applicant Tracking System using PHP and mysql.

If you can, please help.

If you will advise me to buy an ATS system, save your energy on typing. That wouldn’t be the answer to my question. I am considering buying an ATS if this becomes too complicated…

Thanks!

Filed under Programming & Design by administrator

Permalink Print 3 Comments

How do you specify the relationship type in mysql?

mysql
tom4annak asked:


I want to be able to specify the relationship type between my tables in mysql when i create them. (e.g. whetherthey are 1-to-many, many-to-1, 1-to-1, etc). How do i do this if im creating the database via the command line?

Filed under Programming & Design by administrator

Permalink Print 1 Comment