Interview Question in php |
|
|
|
i installed XAMPP on my windows XP . but i have a problem. i have already installed Visual Studio .NET 2003 and now when i type http://localhost , firefox asks for username and password and since i donot knw the password and username , it redirects to http://localhost/localstart.asp.. and in Internet Explorer the Internet Information Services IIS comes ... instead of the XAMPP screen. am new to this . how can i fix this and do php and mysql projects ? should i remove .NET from my PC?
|
|
|
|
|
|
I am new to visual studio 2005 and an intermediate dreamweaver cs3 professional. I am planning to use asp.net , how do i integrate my design from dreamweaver to visual studio to be able to use the asp.net language? Is asp.net just like php wherein you just copy the source code and paste it on the page and it will work?
|
|
|
|
|
|
|
|
|
|
|
|
I'm looking for a web based application for tracking products that people have ordered from us. We need something that's web based (php with mysql preferably, or cgi could also work), can track order and shipping dates, multiple serial numbers of the various components and customer contact information (name, address, phone, email). Its for internal use for warranty tracking and contacting customers about updates. And looking for something free/open source as we don't have a budget for this.
I have tired several CRM's, none of them have serial number tracking abilities, plus they seem to be overkill, we don't need the account aspect end.
Thanks for the assistance!
|
|
|
|
|
|
|
I've been told by Sugar CRM that I need to downgrade php to 5.1.4. I currently have ver 5.1.6. How would I go about doing this? I currently have centos 4, and I'm using centosplus packages.
|
|
|
|
|
|
|
do mysql has GUI feature like sql server 2000? Where can I create database in mysql?
|
|
|
|
|
|
Thats pretty straighforward..
Connect to the server using mssql_connect ( servername, username, password)
However, read this note from php manual:
______________________________________...
If you use PHP on Windows with Apache as a web server, you may get problems with authentication to MS SQL Server even when you supply all valid credentials.
Check your php.ini file:
; Use NT authentication when connecting to the server
mssql.secure_connection = On
If you have secure_connection = On, make sure that you provide valid credentials in the properties for Apache service in the System Services box. Then you should not send DB username and password from your script to MSSQL Server.
If you want to use specific credentials from a PHP script, then set mssql.secure_connection = Off in your php.ini
____________________________________
If you explicitly state the problem you are facing (error messages), people can help you better.
|
|
|
|
|
|
I copied ntwdblib.dll 2000.80.194.0 from MS Sql and pasted in php.
Added the following to php.ini file
sql.safe_mode = On
mssql.allow_persistent=1
mssql.max_persistent=-1
mssql.max_links=-1
mssql.min_error_severity=10
mssql.min_message_severity=10
mssql.compatability_mode=0
mssql.connect_timeout=5
mssql.timeout=60
mssql.textsize=-1
mssql.textlimit=-1
mssql.batchsize=0
mssql.datetimeconvert=1
mssql.max_procs=-1
msssql.secure_connection = On
and uncommented
extension=php_mbstring.dll
Then I wrote the following code
$myServer = "ITDEPTCOMP2";
$myUser = "sa";
$myPass = "password";
$myDB = "Northwind";
while(!$connection){
@$connection = mssql_connect('ITDEPTCOMP2','sa','passwo...
}
echo "connect";
$db = mssql_select_db('Northwind',$connection) or die("Error selecting the database");
But it is not working.
|
|
|
|
|
|
Hi I am expert .NET developer (SQL server 2000) with over 8 years experience, my fee is just $500/week and i{m looking for freelancer/offsite work anywhere in the US.
My Skills are asp.net, vb.net, sql server 2000, php, mysql, flash, web design. I am interested in projects or long term relationships with consulting companies all over US. Thanks :)
Please forward answers to princesoftConsulting@gmail.com :)
|
|
|
|
|
|
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
|
|
|
|
|
|
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?
|
|
|
|
|
|
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?
|
|
|
|
|
|
Database Snapshots : create a read-only copy of your database that can be used for reporting, auditing or recovering data.
The primary goal of database mirroring is to increase data availability and allow failover in case a server hosting the database becomes unavailable (e.g as the result of hardware or network failure).
http://www.databasejournal.com/features/...
Log shipping is one of the failover solutions offered by SQL Server 2000. In this context, failover means substituting primary server with a backup (sometimes also referred to as standby) server if the primary hardware becomes unusable. Failover solutions can also be used to provide close to 100% uptime—during primary database or server maintenance and during software upgrades you could use the standby server to continue serving your customers.
http://www.informit.com/articles/article...
Database replication is the creation and maintenance of multiple copies of the same database.
In most implementations of database replication, one database server maintains the master copy of the database and additional database servers maintain slave copies of the database.
I use :
Database snapshot : to make rollback point if some series of query fails.
Database mirroring : I use backup harddisk to make 'life' backup of my database just in case one harddisk is damage.
Log shipping : it's too expensive for my clients, i've never use it.
Database Replication : to move my database to a higher version of database server or to change my database server to another database server eg. from SQL server to MySQL
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
Well you can use a php script
e.g
<?php
$db = mysql_connect("localhost","USERNAME","PA...
if (!$db)
{
die('Unable to connect: ' . mysql_error());
}
// Add the code in here.
mysql_close($con);
?>
or this code:
<?php
mysql_connect("localhost", "USERNAME", "PASSWORD") or die(mysql_error());
echo "Connected to Database!
";
?>
You're also able to do it manually.
|
|
|
|
|
|
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.
|
|
|
|
|
|
|