-
create a cms
Are you going to have multiple servers? If you just have one server it shouldn't be too much of a problem to create multiple microsites, but I know if you have a bunch of servers you will have to install the server software and cms a bunch.
-
Show tables php syntax
I am using php to show the tables in my database as part of a project. I will probably have more than one question, but for now i would like help on why my php to show the results of "show tables" isn't working. It says Resource id #3Resource id #3Resource id #3Resource id #3 on the page. Please and thank you. Here's the php <?php /* //Shows tables in plastronics. $query = "show tables"; //Execute it, or return the error message if there's a problem. $result = mysql_query($query) or die(mysql_error()); */ $sql = "show tables"; $result = mysql_query($sql); while($tables = mysql_fetch_assoc($result)) echo $result; ?>
-
Table Alignment issue
Never mind. I have a solution. I just don't have to use so many td tags.
-
Table Alignment issue
I have a table and I have different numbers of cells in different columns. I have ones, twos, and threes in different columns. Here's my code. <html> <head> <title> Transportation Request For Clinton Public Schools</title> </head> <body> <table bgcolor="#669933" border="1" cellspacing="5" cellpadding="5" style=" position:absolute; top: 0px;"> <!--Add PHP CODE FOR THIS TO WORK!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!--> <!--Begin Form Here--> <form method=\"POST\"> <!--Row 1--> <tr> <td colspan="2"><h3 align="center">Transportation Request for Clinton Public Schools</h3> <br> </tr> <!--Row 2--> <tr> <td width="600" colspan="1"><h6>REVISED 9-22-11</h6></td> <td width="433" colspan="1"><p align="right">Date:<input type="date" name="date" size="20" /></p></td> </tr> <br/> <!--Row 3--> <tr> <td colspan="2"> Submit transportation requests and/or changes ASAP. Vehicle assignments will be made on a "first come, first server basis." We greatly appreciate your cooperation in giving us as much notice as possible. Your request must be approved by the appropriate principal. </td> </tr> <br/> <!--Row 4--> <tr> <td colspan="1">Destination:<input type="text" name="destination" size="30"></td> <!--Dropdown menu. Accesses 'activities'--> <td colspan="1">Activity:<input type="text" name="activity" size="30"></td> </tr> <br/> <!--Row 5--> <tr> <!--Dropdown menu. Accesses 'school'--> <td colspan="2">School: <select name="school"> </select> </tr> <!--Row 5.5--> <tr> <td colspan="1">Departure Date:<input type="date" name=""></td> <td colspan="1">Return Date:<input type="date" name="return date"></td> </tr> <br/> <!--Row 6--> <tr> <!--Dropdown menu that will access 'organizations'--> <td colspan="1">Organization: <select name="organization"> <option value="bpa">BPA</option> <option value="ffa">FFA</option> <option value="fccla">FCCLA</option> <option value=""></option> </select> <td colspan="1">Paid for by:<input type="radio" name="district">District<input type="radio" name="other">Other</td> </tr> <br/> <!--Row 7--> <tr> <!--Dropdown menu. Accesses 'instructor_sponsor'--> <td colspan="1">Instr./Sponsor:<input type="text" name="instr./sponsor" size="30"></td> <td colspan="1">Phone No.:<input type="text" name="phone no." size="12"></td> </tr> <br/> <!--Row 8--> <tr> <td colspan="1">No. of Passengers:<input type="text" name="school" size="5"></td> <!--Check If "int" is the correct terminology for SUV(s) Bus(es) and Car(s)--> <td colspan="1"> Vehicle(s) Needed: <input type="int" name="vehicle(s) needed" size="3">SUV(s) <input type="int" name="vehicle(s) needed" size="3">Bus(es) <input type="int" name="vehicle(s) needed" size="3">Car(s) </td> </tr> <br/> <!--Row 9--> <tr> <td>State:<input type="text" name="state"></td> <td>City:<input type="text" name="city"></td> <td>Address:<input type="text" name="city"></td> </tr> <br/> <!--Row 10--> <tr> <!--Check if "time" is the correct terminology for Time Departing and Time Returning.--> <td colspan="1">Time Departing:<input type="time" name="time departing" size="6"> <input type="radio" name="time departing">AM <input type="radio" name="time departing">PM</td> <td colspan="1">Time Returning:<input type="time" name="time returning" size="6"> <input type="radio" name="time returning">AM <input type="radio" name="time returning">PM</td> </tr> <br/> <!--Row 11--> <tr> <td colspan="2"><p align="center"><input type="checkbox" name="principal approval"><strong>Principal approved this request</strong></p></td> </tr> <br/> <!--Row 12--> <tr> <td colspan="2"><p align="center"><strong><u>FOR TRANSPORTATION DEPARTMENT USE ONLY</u></strong></p> </tr> <br/> <!--Row 13--> <tr> <td colspan="1"><p align="left"><strong>Activity Drivers:Sponsors or Coaches</strong></p></td> <td colspan="1"><p><strong>Destinations</strong></p></td> </tr> <br/> <!--Row 14--> <tr> <td colspan="1">Name:<input type="text" size="40"></td> <?php $sql="SELECT * FROM employees;" ?> <td colspan="1">From:<input type="text" size="20" value="Clinton">To:<input type="text" size="20"></td> </tr> <br/> <!--Row 15--> <tr> <td colspan="1">Name:<input type="text" size="40"></td> <td>From:<input type="text" size="20">To:<input type="text" size="20" value="Clinton"></td> </tr> <br/> <!--Row 16--> <tr> <!--Dropdown menu. Accesses 'employees'--> <td colspan="2"><p>Driver's Signature<input type="text" size="175"></p></td> <!--Row 17--> <tr> <!--Dropdown menu. Accesses 'employees'--> <td colspan="2"><p>Driver's Signature<input type="text" size="175"></p></td> </tr> <br/> <!--Row 18--> <tr> <td colspan="2"><p align="center"><strong>Hourly Driver:</strong></p></td> </tr> <br/> <!--Row 19--> <tr> <!--Dropdown menu. Accesses 'employees'--> <td colspan="2"><p align="center">Name:<input type="text" size="40"></p></td> </tr> <!--Row 20--> <tr> <td><p align="center">Departure Time:<input type="text" size="6"> <input type="radio" name="departure time">AM <input type="radio" name="departure time">PM </p> </td> <td width="433" colspan="1"><p align="center">Return Time:<input type="text" size="6"> <input type="radio" name="time departing">AM <input type="radio" name="time departing">PM</td> </tr> <br/> <!--Row 21--> <tr> <!--Dropdown menu. Accesses 'employees'--> <td colspan="1"><p>Driver's Signature<input type="text" size="100"></p></td> <!--Button to submit information into 'requests'--> <td colspan="1"><input type="submit" name="submit" value="Request Trip"/></td> </tr> </form> <!--Row 22--> <tr> <td colspan="2"><p align="center">__________________________________________________________________________________________________________________________ <br> <strong>You may confirm your scheduled trip on the "Transportation Calendar" of the school website. If you do not <br/> see your trip posted on the calendar, please call 323-0580 or email <a href="mailto:stan.morris@clintonokschools.org">stan.morris@clintonokschools.org</a>. <br/> Notify us promptly if your trip is cancelled so we may use the vehicle for another trip if needed.</strong></p></td> </tr> </table> </body> </html> On the column with state, city, and address, the address part is sticking out.
-
MySQL/PHP/HTML made PDF report
The problem wasn't solved. I still need help.
-
MySQL/PHP/HTML made PDF report
I could use a link or maybe a book to look to. Anything that might be helpful really.
-
MySQL/PHP/HTML made PDF report
Thanks. I will try to remember that.
-
MySQL/PHP/HTML made PDF report
I have been working on an assignment to create a form so that you could create reports from a database my server. I already have some code, but do not know where to continue. I know I want to be able to chose the columns, id, etc by putting the information in a form. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>create_pdf_report</title> </head> <?php //tell php to log into server $con = mysql_connect("*********","******","********"); if (!$con) { die('Could not connect: ' . mysql_error()); } if (mysql_query("mysql command",$con)) { print ""; } else { echo "Error Printing Report: " . mysql_error(); } //create pdf mysql_select_db("plastronics", $con); /*I don't know what I should put in the ??? spaces.*/ $sql = "select ??? from customer ?(where)?[mult and type] ??? is ??? ( name, address, phone )"; //execute query mysql_query($sql,$con); mysql_close($con); ?> <body> </body> </html> The * are where I have information I don't really want to share. I'd like to know how to replace that to where it wouldn't show that in the source code if anyone knows how. The ? are where I want to integrate php and html to let me put in those variable into a table.
-
-
White space at top of screen
Nevermind. That fixed it. The reason it didn't work before was because I didn't have it in my server. i was just using the run function on my program. Thanks collie
-
White space at top of screen
That didn't work. This happened as soon as I added the table tag, which was not there with all of the <tr></tr> and <td></td> tags. I believe that I did something wrong with how I nested it.
-
White space at top of screen
I have created a form, and later on I realized that it didn't look too great, so I added a table. Now there is a lot of white space at the top. Would someone either help me fix the problem, or help me find a better alternative to a table. Here is the code <html> <head> <title> Transportation Request For Clinton Public Schools</title> </head> <body> <table bgcolor="#669933" border="1" cellspacing="5" cellpadding="5"> <!--Begin Form Here--> <form method=\"POST\"> <!--Row 1--> <tr> <td colspan="2"><h3 align="center">Transportation Request for Clinton Public Schools</h3> <br> </tr> <!--Row 2--> <tr> <td colspan="1"><h6>REVISED 9-22-11</h6></td> <td colspan="1"><p align="right">Date:<input type="date" name="date" size="20" /></p></td> </tr> <br/> <!--Row 3--> <tr> <td colspan="2"> Submit transportation requests and/or changes ASAP. Vehicle assignments will be made on a "first come, first server basis." We greatly appreciate your cooperation in giving us as much notice as possible. Your request must be approved by the appropriate principal. </td> </tr> <br/> <!--Row 4--> <tr> <td colspan="1">Destination:<input type="text" name="destination" size="30"></td> <td colspan="1">Activity:<input type="text" name="activity" size="30"></td> </tr> <br/> <!--Row 5--> <tr> <td colspan="1">School: <select name="school"> <option value="wilson">Wilson</option> <!--I will have to change options for the school values. I am just using these for examples.--> <option value="will rogers">Will Rogers</option> <option value="afton">Afton</option> <option value=""></option> <option value=""></option> <option value=""></option> <option value=""></option> <option value=""></option> </select> <td colspan="1">Trip Date(s):<input type="date<!--Find some way to make plural.-->" name="trip date(s)" size="30"></td> </tr> <br/> <!--Row 6--> <tr> <td colspan="1">Organization:  <select name="organization"> <option value="bpa">BPA</option> <!--I will have to change options for the organization values. I am just using these for examples.--> <option value="ffa">FFA</option> <option value="fccla">FCCLA</option> <option value=""></option> <option value=""></option> <option value=""></option> <option value=""></option> <option value=""></option> </select> <td colspan="1">Paid for by:<input type="radio" name="district">District<input type="radio" name="other">Other</td> </tr> <br/> <!--Row 7--> <tr> <td colspan="1">Instr./Sponsor:<input type="text" name="instr./sponsor" size="30"></td> <td colspan="1">Phone No.:<input type="text" name="phone no." size="12"></td> </tr> <br/> <!--Row 8--> <tr> <td colspan="1">No. of Passengers:<input type="text" name="school" size="5"></td> <!--Check If "int" is the correct terminology for SUV(s) Bus(es) and Car(s)--> <td colspan="1"> Vehicle(s) Needed: <input type="int" name="vehicle(s) needed" size="3">SUV(s) <input type="int" name="vehicle(s) needed" size="3">Bus(es) <input type="int" name="vehicle(s) needed" size="3">Car(s) </td> </tr> <br/> <!--Row 9--> <tr> <td colspan="2">Boarding Location:<input type="text" name="boarding location" size="175"></td> </tr> <br/> <!--Row 10--> <tr> <!--Check if "time" is the correct terminology for Time Departing and Time Returning.--> <td colspan="1">Time Departing:<input type="time" name="time departing" size="6"> <input type="radio" name="time departing">AM <input type="radio" name="time departing">PM</td> <td colspan="1">Time Returning:<input type="time" name="time returning" size="6"> <input type="radio" name="time returning">AM <input type="radio" name="time returning">PM</td> </tr> <br/> <!--Row 11--> <tr> <td colspan="2"><p align="center"><input type="checkbox" name="principal approval"><strong>Principal approved this request</strong></p></td> </tr> <br/> <!--Row 12--> <tr> <td colspan="2"><p align="center"><strong><u>FOR TRANSPORTATION DEPARTMENT USE ONLY</u></strong></p> </tr> <br/> <!--Row 13--> <tr> <td colspan="1"><p align="left"><strong>Activity Drivers:Sponsors or Coaches</strong></p></td> <td colspan="1"><p><strong>Destinations</strong></p></td> </tr> <br/> <!--Row 14--> <tr> <td colspan="1">Name:<input type="text" size="40"></td> <td colspan="1">From:<input type="text" size="20" value="Clinton">To:<input type="text" size="20"></td> </tr> <br/> <!--Row 15--> <tr> <td colspan="1">Name:<input type="text" size="40"></td> <td>From:<input type="text" size="20">To:<input type="text" size="20" value="Clinton"></td> </tr> <br/> <!--Row 16--> <tr> <td colspan="2"><p>Driver's Signature<input type="text" size="175"></p></td> </td> <!--Row 17--> <tr> <td colspan="2"><p>Driver's Signature<input type="text" size="175"></p></td> </td> <br/> <!--Row 18--> <tr> <td colspan="2"><p align="center"><strong>Hourly Driver:</strong></p></td> </tr> <br/> <!--Row 19--> <tr> <td colspan="2"><p align="center">Name:<input type="text" size="40"></p></td> </tr> <!--Row 20--> <tr> <td><p align="center">Departure Time:<input type="text" size="6"></p></td> <td colspan="1"><p align="center">Return Time:<input type="text" size="6"></p></td> </tr> <br/> <!--Row 21--> <tr> <td colspan="2"><p>Driver's Signature<input type="text" size="175"></p></td> </tr> </form> <!--Row 22--> <tr> <td colspan="2"><p align="center">_____________________________________________________________________________________________________________ <br> <strong>You may confirm your scheduled trip on the "Transportation Calendar" of the school website. If you do not <br/> see your trip posted on the calendar, please call 323-0580 or email <a href="mailto:stan.morris@clintonokschools.org">stan.morris@clintonokschools.org</a>. <br/> Notify us promptly if your trip is cancelled so we may use the vehicle for another trip if needed.</strong></p></td> </tr> </table> </body> </html>
-
Updating PHP and having problems with configuration
Never-mind. It turns out I already had the php version I needed. Sorry for any inconvenience.
-
Updating PHP and having problems with configuration
I am updating php so that I can install the latest moodle software, but I have run into a snag configuring it. I have Ubuntu/Linux server with apache 2.x. I have the files unpacked.
- Weird Server
-
Weird Server
Also. The servers IP address is dynamic. It doesn't always change, but i always have to get into it for it to work again.