Jump to content

Jouatt

Members
 View Profile  See their activity

  • Posts

    11

  • Joined

  • Last visited

    Never

 Content Type 

Everything posted by Jouatt

  1. Jouatt
    Well we do have the Access database installed on there computer. We just want to get rid of the the Access front end.
  2. Jouatt
    Hi all, So here is what we are trying to accomplish. We currently have a database program run in MS access and want to migrate the front end of that to web based. We want to do this conversion in little steps since the program is big and would take forever to rewrite all the forms in html/PHP. We want to first change the home page. So far we managed to pull data from the MS access back end with PHP into a browser to populate the homepage with data like we want but we are looking for a temporary fix for the rest of the program. We would like if a button from the home page could open a specific Access form from the old front end for the rest of the program. Any ideas on how this could be done via Java Script, PHP, VBS, or anything else? Thanks
  3. Jouatt
    Hi all, I have been working on this and maybe you guys can help. All I need to do is be able to open a access form with php. I have tried a couple of diffrent things but nothing is working. What I have right now is $app = new COM("Access.Application"); $app->OpenCurrentDatabase("C:\Documents and Settings\Ian\Desktop\TestData.accdb"); $app->Application->Run("OpenAccForm"); //$app->DoCmd->OpenForm("Test Data"); //$app->Visible = "Yes"; print "Loaded Access, version {$app->Visible}\n"; Any help is appreciated. Right now It opens access but is not viable. I know it is opening access because it is in the processes tab in task manager.
  4. Jouatt
    I have a table on a page that displays info from a database and everything is working fine but I want it so if the user entered data from another page to a certain field then the row on my data display table will turn red. Right now I have a If statement in every row of my table. Is it possible to have two if statements in a row? Here is my page code with the table. <? include "include/session.php"; include "include/z_db.php"; ?> <? require "bottom.php"; ?> <!doctype html public "-//w3c//dtd html 3.2//en"> <html> </head> <!-- <body bgcolor="#339999"> --> <body bgcolor="white"> <img src="logo.jpg" width="197" height="193" align="right"><br /><br /><br /><br /><br /> <br /><br /><br /><br /><br /> <FORM> <INPUT TYPE="BUTTON" VALUE="New Tour" ONCLICK="window.location.href='http://www.integranite.net/EAToursDemo/Input.php'"> </FORM> <?php $result = mysql_query("SELECT * FROM Project"); ?> <div style="overflow:auto; height:30px; width:1650px"> <?php echo "<table border='1'> <tr> <th width='200'>School</th> <th width='200'>Teacher</th> <th>First Contact start date</th> <th>Development Start</th> <th>Development End</th> <th>Pricing Start</th> <th>Pricing End</th> <th>Marketing Start date</th> <th>Price Based On</th> <th>Trip Assigned To</th> <th>Trip Made</th> <th width='104'>Notes</th> </tr>"; echo "</table>"; echo "</div>"; ?> <div style="overflow:auto; height:400px; width:1650px"> <?php while($row = mysql_fetch_array($result)) { $checkbox = ''; if ($row['TripMade'] == 1) $checkbox = ' checked'; ?> <!--<div style="overflow:auto; height:40px; width:155px">--!> <table cellpadding="0" cellspacing="0" style="width:50px;"> <?php echo "<table border='1'>"; echo "<tr>"; echo "<td width='200'>" .$row['School'] . "</td>"; echo "<td width='200'>" .$row['Teacher'] . "</td>"; if(!strcmp($row['dtFirstContactSt']&& $row['dtMarketingSt'] , '0000-00-00' && '0000-00-00')) { echo "<td width='156'>" . "&nbsp </td>"; } else { echo "<td bgcolor=FF0000 width='156'>" .$row['dtFirstContactSt']. "</td>"; } if(!strcmp($row['dtDevelopmentSt'], '0000-00-00')) { echo "<td width='126'>" . "&nbsp </td>"; } else { echo "<td width='126'>" .$row['dtDevelopmentSt']. "</td>"; } if(!strcmp($row['dtDevelopmentEnd'], '0000-00-00')) { echo "<td width='119'>" . "&nbsp </td>"; } else { echo "<td width='119'>" .$row['dtDevelopmentEnd']. "</td>"; }; if(!strcmp($row['dtPricingSt'], '0000-00-00')) { echo "<td width='83'>" . "&nbsp </td>"; } else { echo "<td width='83'>" .$row['dtPricingSt']. "</td>"; } if(!strcmp($row['dtPricingEnd'], '0000-00-00')) { echo "<td width='76'>" . "&nbsp </td>"; } else { echo "<td width='76'>" .$row['dtPricingEnd']. "</td>"; } if(!strcmp($row['dtMarketingSt'], '0000-00-00')) { echo "<td width='142'>" . "&nbsp </td>"; } else { echo "<td width='142'>" .$row['dtMarketingSt']. "</td>"; } echo "<td width='104'>" .$row['PriceBasedOn']. "</td>"; echo "<td width='115'>" .$row['TripAssignedTo']. "</td>"; ?> <td width="72"><input type="checkbox" name="TripMade" value="Yes" <?= $checkbox ?>></td> <td><textarea name="Notes" rows="1" cols="10"><?php echo $row["Notes"]?></textarea> </td> <?php echo "<td>" . "<a href=Edit_Form.php?UniqueIdentifier=$row[uniqueIdentifier]> Edit </a></td>"; echo "</tr>"; } echo "</table>"; echo "</div>"; mysql_close($con); ?> <br /> <meta name="GENERATOR" content="Arachnophilia 4.0"> <meta name="FORMATTER" content="Arachnophilia 4.0"> </head> <body bgcolor="#ffffff" text="#000000" link="#0000ff" vlink="#800080" alink="#ff0000"> <center> </body> </html> The first IF statement is what i am trying to do but just dont know how to code it. I know its kind hard to understand but any help is appreciated.
  5. Jouatt
    Never mind. Stupid me misspelled something.. I hate when that happens
  6. Jouatt
    I have a form that the user will check off a checkbox if they finish with everything and that checkbox updates the database field "TripMade" with either a 1 if checked or a 0 if not checked. This is working fine but i wish to be able to see if the box is checked or not from another page with a checkbox. This is what i have sofar to populate the checkbox with the data from the database but it is not working. <? include "include/session.php"; include "include/z_db.php"; ?> <? require "bottom.php"; ?> <!doctype html public "-//w3c//dtd html 3.2//en"> <html> </head> <!-- <body bgcolor="#339999"> --> <body bgcolor="white"> <!-- <form action="index.php" method="post"> <br /><input type="submit" value="HOME" ;/></form><br /> --> <img src="logo.jpg" width="197" height="193" align="right"><br /><br /><br /><br /><br /> <br /><br /><br /><br /><br /> <FORM> <INPUT TYPE="BUTTON" VALUE="New Tour" ONCLICK="window.location.href='http://www.integranite.net/EAToursDemo/Input.php'"> </FORM> <?php $result = mysql_query("SELECT * FROM Project1"); echo "<table border='1'> <tr> <th>School</th> <th>Teacher</th> <th>First Contact start date</th> <th>Development Start</th> <th>Development End</th> <th>Pricing Start</th> <th>Pricing End</th> <th>Marketing Start date</th> <th>Price Based On</th> <th>Trip Assigned To</th> <th>Trip Made</th> <th>Notes</th> </tr>"; while($row = mysql_fetch_array($result)) //$TripMade = (($row['TripMade'] == 1) ? ' checked="checked"' : null); { $checkbox = ''; if ($Row['TripMade'] == 1) $checkbox = ' checked'; echo "<tr>"; echo "<td>" .$row['School'] . "</td>"; echo "<td>" .$row['Teacher'] . "</td>"; if(!strcmp($row['dtFirstContactSt'], '0000-00-00')) { echo "<td>" . "No Date </td>"; } else { echo "<td>" .$row['dtFirstContactSt']. "</td>"; } if(!strcmp($row['dtDevelopmentSt'], '0000-00-00')) { echo "<td>" . "No Date </td>"; } else { echo "<td>" .$row['dtDevelopmentSt']. "</td>"; } if(!strcmp($row['dtDevelopmentEnd'], '0000-00-00')) { echo "<td>" . "No Date </td>"; } else { echo "<td>" .$row['dtDevelopmentEnd']. "</td>"; }; if(!strcmp($row['dtPricingSt'], '0000-00-00')) { echo "<td>" . "No Date </td>"; } else { echo "<td>" .$row['dtPricingSt']. "</td>"; } if(!strcmp($row['dtPricingEnd'], '0000-00-00')) { echo "<td>" . "No Date </td>"; } else { echo "<td>" .$row['dtPricingEnd']. "</td>"; } if(!strcmp($row['dtMarketingSt'], '0000-00-00')) { echo "<td>" . "No Date </td>"; } else { echo "<td>" .$row['dtMarketingSt']. "</td>"; } echo "<td>" .$row['PriceBasedOn']. "</td>"; echo "<td>" .$row['TripAssignedTo']. "</td>"; ?> <td><input type="checkbox" name="TripMade" value="Yes" <?= $checkbox ?>> <td><textarea name="Notes" rows="1" cols="10"><?php echo $row["Notes"]?></textarea> </td> <?php //echo "<td>" .$row['Notes']. "</td>"; echo "<td>" . "<a href=Edit_Form.php?UniqueIdentifier=$row[uniqueIdentifier]> Edit </a></td>"; echo "</tr>"; } echo "</table>"; mysql_close($con); ?> <br /> <meta name="GENERATOR" content="Arachnophilia 4.0"> <meta name="FORMATTER" content="Arachnophilia 4.0"> </head> <body bgcolor="#ffffff" text="#000000" link="#0000ff" vlink="#800080" alink="#ff0000"> <center> </body> </html>
  7. Jouatt
    Awesome. Thank you
  8. Jouatt
    OK. I need to add the list/menu box, populate it with the numbers 1-75 and the user will select a number from the box. When the user finishes the edit form they click the submit button it will update the database with that number they selected. If you need anymore info just let me know.
  9. Jouatt
    anyone?
  10. Jouatt
    only one number will be selected and added into the database.
  11. Jouatt
    I am making a site and need some help. I am trying to put in a list/menu that will have the numbers 1-75 and when selecting a number and clicking on the update button it will add that number into my data base. This first bit of code is my Edit Form. The second is my page that updates the info. <body bgcolor="white"> <form action="index.php" method="post"> <br /></form><br /> <?php $con = mysql_connect("localhost","integrq9_coder","Terry421"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("integrq9_Eurotravel", $con); $UniqueIdentifier=$_GET['UniqueIdentifier']; $result = mysql_query("SELECT * FROM Project where UniqueIdentifier= ".(int)$UniqueIdentifier.""); while($row = mysql_fetch_array($result)) { ?> <form name="form" method="post" action="Saving_Data.php"> <!--<form name="form" method="post" action="index.php">--> <input type="hidden" name="ID" value="<?php echo $row["UniqueIdentifier"]?>"> <table border="1"> <tr> <td> School: </td> <td><input type="text" name="School" value="<?php echo $row["School"]?>"></td> <!-- <td> <input type="hidden" name="ID" value="<?php echo $row["UniqueIdentifier"]?>"></td> --> </tr> <tr> <td> Teacher </td> <td><input type="text" name="Teacher" value="<?php echo $row["Teacher"]?>"></td> </tr> <tr> <td>First contact </td> <td><input type="text" name="dtFirstContactSt" value="<?php echo $row["dtFirstContactSt"]?>"></td> </tr> <tr> <td> Development: </td> <td> <input type="text" name="dtDevelopmentSt" value="<?php echo $row["dtDevelopmentSt"]?>"> </td> <td> to </td> <td> <input type="text" name="dtDevelopmentEnd" value="<?php echo $row["dtDevelopmentEnd"]?>"> </td> </tr> <tr> <td> Pricing: </td> <td> <input type="text" name="dtPricingSt" value="<?php echo $row["dtPricingSt"]?>"> </td> <td> to </td> <td> <input type="text" name="dtPricingEnd" value="<?php echo $row["dtPricingEnd"]?>"> </td> </tr> <tr> <td> Marketing: </td> <td> <input type="text" name="dtMarketingSt" value="<?php echo $row["dtMarketingSt"]?>"> </td> </tr> <tr> <td> Price Based On: </td> <td> </td> </tr> <tr> <td> Trip Made: </td> <td> </td> </tr> <tr> <td> Trip Assigned To: </td> <td> <input type="text" name="TripAssignedTo" value="<?php echo $row["TripAssignedTo"]?>" maxlength="2"> </td> </tr> <tr> <td valign="top">Notes: </td> <td colspan="3"><textarea name="Notes" rows="5" cols="100"><?php echo $row["Notes"]?></textarea></td> </tr> </table> <!--Notes: <textarea name="Notes" rows="3" cols="40"><?php echo $row["Notes"]?></textarea><BR> --> <?php } ?> <br /><br /> <input type="submit" value="Update" ;/> <input type="hidden" name"customerid " value="<?php echo UniqueIdentifier?>" ;/> </form><form action="index.php" method="post"> <br /></form><br /> </body> </head> <form action="index.php" method="post"> are you sure you want to save the data? <br /><input type="submit" value="Save" ;/></form><br /> <!-- <body bgcolor="#339999"> --> <body bgcolor="white"> <?php ini_set('display_errors', '1'); error_reporting(E_ALL | E_STRICT); $con = mysql_connect("localhost","integrq9_coder","Terry421"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("integrq9_Eurotravel", $con); $School=$_POST['School']; $Teacher=$_POST['Teacher']; $dtFirstContactSt=$_POST['dtFirstContactSt']; $dtDevelopmentSt=$_POST['dtDevelopmentSt']; $dtDevelopmentEnd=$_POST['dtDevelopmentEnd']; $dtPricingSt=$_POST['dtPricingSt']; $dtPricingEnd=$_POST['dtPricingEnd']; $dtMarketingSt=$_POST['dtMarketingSt']; $TripAssignedTo=$_POST['TripAssignedTo']; $Notes=$_POST['Notes']; $UniqueIdentifier = ($_POST['ID']); $intUniqueIdentifier = (int)$UniqueIdentifier; if($UniqueIdentifier= ($_POST['ID'])) { $sql = "UPDATE Project SET School='$School', Teacher='$Teacher', dtFirstContactSt='$dtFirstContactSt', dtDevelopmentSt='$dtDevelopmentSt', dtDevelopmentEnd='$dtDevelopmentEnd', dtPricingSt='$dtPricingSt', dtPricingEnd='$dtPricingEnd', dtMarketingSt='$dtMarketingSt', TripAssignedTo='$TripAssignedTo', Notes='$Notes' WHERE UniqueIdentifier= '$intUniqueIdentifier'" ; // WHERE UniqueIdentifier= ".(int)$UniqueIdentifier." ") or die(mysql_error()); // WHERE UniqueIdentifier= '$intUniqueIdentifier'") or die(mysql_error()); mysql_query ( $sql ) or die(mysql_error()); } else { echo "<br />"."1 record updated"."<br />";} ?> <br /> <form action="Edit_Form.php" method="POST"> <!-- <input type="submit" value="Update Again">--> </form> <br /> </body> </html>
×
×
  • 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.