elcabron10

begin doing the connection for php and mssql

Can you point me to the right path where to begin?

As the topic suggest, is it possible to link two database? (MsSQL and MySQL?) For example if i save something on MsSQL will it be also saved and available to MySQL? Thank You.

I managed to make it work with mssql server 2008 r2. Goodluck to me integrating it to php, any pointers from you gurus?

I will suggest that when my boss arrive. Thank you. For the ODBC account, i've already did that. Here is the screenshot. EDIT: Im installing ms server and hoping that somehow it will work. But if i can manage to make it work with mysql, ill go with mysql.

Yes, I'm pretty much 100% sure that the credentials that I'm using are all correct. In the manual that came with the software says that all i need to do is configure the username and password according to my settings which is (mysql@localhost,root,admin), and make a database named "imsdb" then If i do that correctly the software itself will make all the necessary tables for the database. and oh! they said about making an ODBC account. EDIT: I've already checked the php log, there's no recorded report saying that the software is trying to connect with mysql

what i want is to make that software use mysql database, so that i can query the data through php to make a centralized attendance system

thank you for the quick reply, but i already have xampp control panel, i also did installing the system dns on administrative tools. But no avail. Its a software bundled with our biometrics from china.

please advise me prior to this

How to make this software use mysql database instead of access database screenshot at the attachment, i cannot tell you the name of the software(company property)

Hi all, How can i get the file path of a file? For example i want to browse for a text file. I'm trying to make a payroll system through php, the attendance(time in,time out) is in a .txt file. here is the html form code. p>Payroll Management</p> <form action="TestParse.php" method="post" enctype="multipart/form-data"> <label for="name">Name of the Employee:</label> <input type="text" name="name" id="name" /><br /> <label for="file">Filename:</label> <input type="file" name="file" id="file"/> <input type="submit" value="Submit"> </form> Here is the php code, its working but its not what i want. <?php $lines = file('AGL_001.txt'); $name = $_POST['name']; $found = false; foreach ($lines as $line){ if (trim($line) == $name) $found = true; } if ($found) echo 'YES'; else echo 'NO'; ?>

Im totally new to this language, im stuck up on that thing. Please help.

The js script <!--Form validation js script--> <script> function formValidate() { var form=document.forms["myForm"]["DeptNo"].value; if (form==null || form="") { alert("Dept number missing"); return false; } } </script> the forms <table border = "1"> <tr> <td align="center">Department Management</td> </tr> <tr> <td><table> <form method="post" name="myForm" onSubmit="return formValidate();" action="<?php echo htmlspecialchars($_SERVER['PHP_SELF'])?>"> <tr> <td>Department Number</td> <td><input type="text" name="DeptNo" size="40"></td> </tr> <tr> <td>Department Name</td> <td><input type="text" name="DeptName" size="40"></td> </tr> <tr> <td>Department Type</td> <td><input type="text" name="DeptType" size="40"></td> </tr> <tr> <td>Telephone</td> <td><input type="text" name="Telephone" size="40"></td> </tr> <tr> <td>Fax</td> <td><input type="text" name="Fax" size="40"></td> </tr> <tr> <td>Address</td> <td><input type="text" name="Address" size="40"></td> </tr> <tr> <td>Remarks</td> <td><input type="text" name="Remarks" size="40"></td> </tr> <tr> <td></td> <td align="left"><input type="submit" name="submit" value="save"></td> </tr> </table></td> </tr> </table> the code for inserting data to mysql database <?php if (isset($_POST['submit'])){ //database connection mysql_connect("localhost","root","pass"); mysql_select_db("db"); $DeptNo = $_POST['DeptNo']; $DeptName = $_POST['DeptName']; $DeptType = $_POST['DeptType']; $Telephone = $_POST['Telephone']; $Fax = $_POST['Fax']; $Address = $_POST['Address']; $Remarks = $_POST['Remarks']; //insert data to database using order variable $order = "INSERT INTO tbldepartmentlist (DeptNo, DeptName, DeptType, Telephone, Fax, Address, Remarks) VALUES ('$DeptNo','$DeptName','$DeptType','$Telephone','$Fax','$Address','$Remarks')"; //declare in the order variable $result = mysql_query($order); //order executes if($result){ echo("<br>Transaction Successfull."); }else{ echo("<br>Transaction Failed."); } } ?>

nothing is happening, it just keeps adding data to myqsl database even if the textfields are empty

Oh i didnt know that, i modified it to match the criteria of the forms of my field.