Jump to content

elcabron10

Members
  • Posts

    20
  • Joined

  • Last visited

elcabron10's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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.
  2. I managed to make it work with mssql server 2008 r2. Goodluck to me integrating it to php, any pointers from you gurus?
  3. 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.
  4. 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
  5. 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
  6. 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.
  7. 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)
  8. 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'; ?>
  9. Im totally new to this language, im stuck up on that thing. Please help.
  10. 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."); } } ?>
  11. nothing is happening, it just keeps adding data to myqsl database even if the textfields are empty
  12. Oh i didnt know that, i modified it to match the criteria of the forms of my field.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.