SQL Server 2005 Driver for PHP Interview Questions 


 

SQL Server 2005 Driver for PHP Interview Questions
Hello all,

I've got a form that once submitted it stores the info to a database...it seems to work offline on my local testing server (i'm using dreamweaver by the way & EMS SQL Manager 2005 Lite for MySQL) now i want to publish it to my host....and i don't know how to do that !

I have normal html files and php files which i have published...but how do i publsh the database??? Is it as simple as just hitting publish like the way i usually do...or is there something else i should do before this? Does dreamweaver realise that the database is linked to the php files it needs to be published?

btw, my host supports php and mysql databases

>>>any websites that you can suggest that can help me are welcome too

Thanks all
Hey GISers,

I just graduate from BCIT, Canada. I am looking for a job as GIS Developer/Analyst to develop my career in GIS. However, I less network/connections to explore the hidden market in North America since I migrated to Canada from Asia.
Before I moved to Canada, I worked as a GIS developer in Singapore. Highlights of my skills and abilities include:

• Databases: Oracle 8i/9i Spatial, SQL Server 2000/2005, PostgreSQL, Access
• Languages: Visual Basic/C#.NET, C/C++, ASP.NET, PHP, JavaScrpt
• Software: ArcGIS 9.2, ArcObjects and ArcSDE, FME, PostGIS, PCI Geomatics, Intergraph Geomedia, etc.
• Strong interpersonal and problem solving skills

Thank you very much.
John
so I'm wondering if i could get a job as a web developer when i finish my studies
,because i find C sharp C++ SQL Server 2005 JAVA a little bit dull and boring for me .
. I'm quite good at HTML XHTML CSS and have basic skills at PHP I'm also good at Hardware but I've never wanted to become a sis admin or an It Technician
we do web production and management and event driven programing as well
so will that help me to get a job as a web designer/developer ?
have a look at this images.They are perfect when am uploading and
corrupt after download.i testes on sqlserver 2005 and sql server 2000.
the images are here http://erastus.paritykenya.com/
is there a setting in php.ini am missing.php.ini has most defaults.
I am currently learning SQL Server 2005 but I am also interested to learn mysql with php on my other PC. I know nothing about linux. I am 47 and hope to get a job as system Administrator or DBA next year. Do you guys think that I should learn some linux as well?
Hi, I'm looking to setup a couple of web servers (hitting SQL Server 2005 Express and using PHP) on a very small budget and can get Windows 2000 Server for very cheap.

How does the general stability compare to 2003/2008?

I don't need any of the new features in 2003/2008 server and the server(s) would be used for web only (nothing too complex), but I'd like something that is pretty stable.

If you could get 2000 Server for free (or next to it) would it be worth using or is the general stability of 2003/2008 Server far better? I realize there are some security issues which doesn't really concern me too much.

Thanks!
How long will it take me to get there? I have no degree , no certification. I need to get that done in 1 year , Is that possible or not? All I know is some html & CSS. Thx.
Should I take the linux road with mysql/php or SQL Server 2005?
I want to use SQL Server 2005 on my home PC. No networks, servers or anything. I've installed it and when I launch Management Studio, it shows a "Connect to Server" dialog.

Screenshot here:
http://img520.imageshack.us/my.php?image...

I've tried entering various terms like 'localhost', 'local', my machine name etc. in the 'Server Name' box. There is no server listed in the drop-down box as well as when i try osql -L from command-line. Is there anything wrong with my install? What do I exactly need to do to get it up and running?

Thanks for specific instructions, please.
I am thinking getting into the IT field. Was wondering if I should learn PHP/Mysql or SQL Server 2005? I am an old woman 48. I appreciate your answer. Thanks.
Ihave both on my PC and wonder which of these 2 technologies I should I learn? Job wise can I get a job faster with php/msql? I head php was easier to learn? Thx.
Yes; you work with it virtually the same way you work with MySQL server and the like. PHP has built-in MSSQL functions, just like it has built-in MySQL functions.

$link = mssql_pconnect( 'host', 'user', 'pass' ) or die( 'Cannot connect') ;
mssql_select_db( 'dbname' ) or die( 'Cannot select db' );

$query = "SELECT * FROM table";

$rs = mssql_query( $query ) or die( 'Cannot run query' );

while( $row = mssql_fetch_array( $rs ) ) {
echo $row['column']."
";
}
I know PHP can be of some use in SQL Server 2005.I want to know how can one use PHP in conjuction with SQL Server 2005.
1Showing 1 to 15 of 12