PHP - Creating A Form With Table Or With Div ?

Hi there, trying to create a function more out of lazyness an timesaving than anything
im sure it has to do with something combining the use of INSERT and x++ in an array, but im failing at figuring out the right way of doing it to achieve the right combination of effects.

in simple

need to create a 600x600 grid of co-ordinates where x starts at 1, ending in 600 with y starting at 1 and ending in 600

so basically a cubed set of entrys, (360,000 rows) not even sure thats possible lol..

the table only needs to contain the colums of id, x , y , ownerid (where id is auto inc)

any suggestions, as you can tell its a pain-staking long case of affairs to create with a manual VERY long sql statement, trying to figure out a better way of doing this.
help please?

Thanks

I am trying to create something similar to a bar chart, using a html table based on the values stored in an array.  However, I cannot seem to get the next column to begin after printing the number at the bottom.  I can get it going horizontal, but I would like to create a vertical version.  If anyone can provide me with help I would greatly appreciate it.

Code: [Select]

<?php

$month = date("n");     //numeric representation of month (1-12)
$year = date("Y");      //4 digit representation of year
$day = date("d");   //numeric representation of the day of the month


// constant variable to determine how many days alive according to the current date
define('DAYS_ALIVE',(($year - 1902) * 365.24) + (($month - 1) * 30.5 )+ ($day - 1)); 
$divident = 100000; // variable for modulus
$divider = 10000; // variable to shrink the divident

for($i = 0; $i <= 4; $i++) // for loop to fill the array with days alive 
{
$daysArray[$i]= floor((DAYS_ALIVE % $divident)/$divider); //calculates the single digit to store in array

$divident= $divident/10; //after every iteration the divident is decreased
$divider= $divider/10; //after every iteration the divider is decreased
}

echo "<table border='2' width='100%'>"; 

$arraySize = count($daysArray); //variable for the array size

for($k=0;$k<=$arraySize-1;$k++)
{

echo "<tr>";

for($j=1;$j<=$daysArray[$k];$j++)
{

echo "<td> * </td>";

}

echo "<td>$daysArray[$k]</td>";


}


echo "</table>";
?>

What I want is something like this.

Hello,    I have this very frustrating problem 

I'm trying to make a dynamic table with only 5 columns per row. So every 5 items, I need a new row.   I have tried many different examples with no success. What is the best way to approach this?   Here is what I am working with, this doesn't show what I have tried, just what I am working with at the moment which of course, just outputs it one column per row. http://www.mesquitew.../inc-legend.php

// Lets parse the data
$entries = simplexml_load_file($data);
if(count($entries)):
    //Registering NameSpace
    $entries->registerXPathNamespace('prefix', 'http://www.w3.org/2005/Atom');
    $result = $entries->xpath("//prefix:entry");

    foreach ($result as $entry):
        $event = $entry->children("cap", true)->event;

// Set the alert colors for the legend
include ('../inc-NWR-alert-colors.php');

// Lets creat some styles for the list
$spanStyle = "background-color:{$alertColor};border:solid 1px #333;width:15px;height:10px;display:inline-block;'> </span><span style='font-size:12px;color:#555;";

 $legend .= "<table>";
 $legend .= "<tr>";
 $legend .= "<td> <span style='$spanStyle'> $event</span></td>";
 $legend .= "</tr>";
 $legend .= "</table>";

         endforeach;
endif;

echo $legend;

-Thanks!

HI. Im new to database. I didnt know how to use bridge table. In my bridge table i have SubjectID and studentID, PK from student table and subject table. In my subject table have SubjectID, SubjectName and SubjectLecturer while in my student table have studentID,,studentName,IC,studentFac,studentPhone, studentEmail,pswd,studentAddress. I didnt know where is the wrong part because when i click my form which is enroll button, this enroll page blank Can someone check my coding ? Help ?               <!DOCTYPE HTML> <html> <head> <?php
error_reporting(0);
session_start();
if (!isset($_SESSION['studentID']))
{
$_SESSION['studentID'] = $_POST['studentID'];
$_SESSION['pswd'] = $_POST['pswd'];
}

include("connect.php");
$sql = "SELECT * FROM student WHERE 
studentID='".$_SESSION['studentID']."' AND 
pswd='".$_SESSION['pswd']."'";

$result = mysql_query($sql);
$row = mysql_num_rows($result);
if ($row == 0)
{
echo "Login fail Try again <a href='http://bytes.com/'>here</a>";
?> <meta http-equiv="refresh" content="0;userlogin.php" /> <?php
}
else
{
$row = mysql_fetch_assoc($result);
}
?> <meta charset="UTF-8"> <title>E-Education portal</title> <link href="http://bytes.com/style.css" rel="stylesheet" type="text/css"> </head> <body> <div id="header"></ div> <?php

if(isset($_POST["submit"]))
{
session_start();
include("connect.php");

$SubjectID = $_POST['SubjectID'];
$SubjectName = $_POST['SubjectName'];
$SubjectLecturer = $_POST['SubjectLecturer'];


$Subject= "SELECT SubjectID
FROM Subject
WHERE SubjectID='$SubjectID'";

$queryssubject=mysql_query($subject) or die(mysql_error);
$record=mysql_num_rows($querysubject);

if($record==1)
{
header ('Location: studentSubject.php');
}
else if($record<1)
{
if(substr($subjectID))
{

$insertIntoSubject= "INSERT INTO Subject ('SubjectID', 'SubjectName', 'SubjectLecturer') VALUES ('$SubjectID','$SubjectName','$SubjectLecturer')";

$result1=mysql_query($insertIntoSubject) or die(mysql_error());

$insertIntobridge="INSERT INTO `bridge`(`SubjectID`, `studentID`)
VALUES ('$SubjectID', '$studentID')";
$result2=mysql_query($insertIntobridge)or die(mysql_error());

$insertIntostudent="INSERT INTO student (`studentID`, `studentName`, `IC`, `studentFac`, `studentPhone`, `studentEmail`, `pswd`, `studentAddress')
VALUES ('$studentID', '$studentName', '$IC', '$studentFac', '$studentPhone', '$studentEmail', 'abc123', '$studentAddress')";

$result3=mysql_query($insertIntostudent)or die(mysql_error());



if ($result1 && $result2 && $result3)
{
header ('Location: studentSubject.php');
}
}
else echo 'insert error';
}

else
{
echo "<script type='text/javascript'>
alert('Data Updated!')
location.href='homestudent.php'
</script>";

}
mysql_close($conn);
}
?>

Can someone five me the correct code or format to use that will allow my TINYINT columns to carry TWO decimal places when creating my table?  I have a script for creating the table and columns, but only recently learned that I need to ADD the TWO decimal place FUNCTION in order to get whole dollar values to display WITH the trailing zeros (ie.:2.00).  I don't expect to need any values greater than xxx.xx in my columns, I'm just not clear on how to get the desired script when running the initial CREAT script.

Thanks

I made a table that gets the rows from a mysql table and lists them with the information on each row. What i need is an edit button at the end of the row so i can click it to change the data. What i want it to do is pop up a new window (child) that i can easily change the data by a text box, drop down menu, etc. and click submit to update it on the table. What i also need is a second button that will completely remove the data from that row in the table. I am still learning php and html and have no knowledge of javascript so any help would be appreciated!

I'm in the process of creating a webage that shows latest scores and an updated league table for soccer/football matches like the bbc sports website does.

I have the database set up with a form to update and display latest score all work well apart from if i update a score like the following

teamA  1  teamB  0   it updates table to give  teamA 3 points based on the current score however if teamA score again
teamA 2 teamB 0 it updates table again  but gives teamA another 3 points which is not correct so i need a way to stop it happening.

thought about it for a while and only thing i can come up with is some maths to compare the values of score for each team and add/remove points as dependent on current score.


Anyone got something similar to this

I need php code that creates pdf file with table inside.

ok, I'm not sure I know how to ask this question, but I've created a table that allows the user to add rows. The problem is, upon submit only the last row creates variables. How can I make sure every cell in every row sets a different variable?

This is going to be a purchase order system.

Here is my code:
Code: [Select]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Insert Table Row using DOM</title>
<script language="javascript">
function addRow()
{
var tbody = document.getElementById("po_table").getElementsByTagName("tbody")[0];
var row = document.createElement("TR");
var cell1 = document.createElement("TD");
var cell2 = document.createElement("TD");
var cell3 = document.createElement("TD");
var inp1 =  document.createElement("INPUT");
inp1.setAttribute("type","text");
inp1.setAttribute("name","quantity");
cell1.appendChild(inp1);
var inp2 =  document.createElement("INPUT");
inp2.setAttribute("type","text");
inp2.setAttribute("name","description");
cell2.appendChild(inp2);
var inp3 =  document.createElement("INPUT");
inp3.setAttribute("type","text");
inp3.setAttribute("name","unit_cost");
cell3.appendChild(inp3);
row.appendChild(cell1);
row.appendChild(cell2);
row.appendChild(cell3);
tbody.appendChild(row);
//alert(row.innerHTML);
}
</script>
</head>
<body>
<form method="post" action="review_po.php">
<table id="po_table" border="1">
<tbody>
<tr>
<th bgcolor="#c1c1c1">Quantity</th>
<th bgcolor="#c1c1c1">Description</th>
<th bgcolor="#c1c1c1">Unit Cost</th>
</tr>
<tr>
<td><input type=text name="quantity"></td>
<td><input type=text name="description"></td>
<td><input type=text name="unit_cost"></td>

</tr>
</tbody>
<tfoot>
<tr>
<th bgcolor="#e0e0e0">1</th>
<th bgcolor="#e0e0e0">Shipping</th>
<td><input type=text name="shipping"></td>

</tr>
<tr>
<th bgcolor="#e0e0e0">1</th>
<th bgcolor="#e0e0e0">Tax</th>
<td><input type=text name="tax"></td>

</tr>
</tfoot>
</table>
<input type="button" value="Insert Row" onClick="addRow();">
<input type="submit" value="Review" name="review_po">
</form>


</body>
</html> 
right now it goes to this page:

Code: [Select]
<?php

//convert to variables
$quantity = $_POST['quantity'];
$description = $_POST['description'];
$unit_cost = $_POST['unit_cost'];
$extended_cost = $_POST['extended_cost'];
$shipping = $_POST['shipping'];
$tax = $_POST['tax'];

?>

<?php echo $quantity; ?><br>
<?php echo $description; ?><br>
<?php echo $unit_cost; ?><br>
<?php echo $extended_cost; ?><br>
<?php echo $shipping; ?><br>
<?php echo $tax; ?><br>

here is the page:
http://po.shopphgmag.com/create_po.html

Thanks for looking

Yes, I am going to be one of those guys today. I have never done XML anything, besides past 2-3 hours or so, and I am getting frustrated. I have learned how to create simple XML files and save them. I am however having hard time figuring out how to create and XML file when trying to access an table from databse. I am looking to export from "registered_users" table all "registrations" and include "first_name", "last_name" and "age"   Sample:   <registered_users>    <registration>       <first_name>Bob</first_name>       <last_name>Smith</last_name>       <age>36</age>    </registration>    <registration>       <first_name>Jack</first_name>       <last_name>Miller</last_name>       <age>45</age>    </registration> </registered_users>   It would be nice if the file would be saved as spearate "all_users.xml"   Any help would be appreciated

Hello I've registered here last March and I'm just lurking around reading threads about php.

Yesterday I've started to self studied php and today I've test some basic codes and I'm having difficulties on creating a table rows and columns.

Here's my code.

Code: [Select]
<?php

echo "<table width=\"100\" border=\"1\">";



$text = 'php';
$mac_var = 1;
$mac_plus = 4;




while ($mac_var < $mac_plus)
{
echo "<tr>";
{
while ($mac_var < $mac_plus)
{
echo "<td>". $text . "</td>";
$mac_var++;
}
}
echo "</tr>";
$mac_var++;
}
 


echo "</table>";

?>


what I want is, it should have 3 columns and 3 rows.

But I'm getting only 3 columns and 1 row only.

I wonder what is the problem?


Sorry for my ignorance as I'm on the 1st basic phase of using php codes. TIA! 

PHP code:

Code: [Select]
<?
//login variable
$username = $_POST ['username'];
$password = $_POST ['password'];
$database = $_POST ['database'];
//table variable
        $table = $_POST ['table'];
//stats variables
        $name = $_POST ['name'];
        $force = $_POST ['force'];
        $armor = $_POST ['armor'];
        $strength = $_POST ['strength'];
        $value = $_POST ['value'];

mysql_connect ("localhost","$username","$password");
@mysql_select_db ($database) or die ("no database name");

$query = "INSERT INTO `$database`.`$table` ('name', 'force', 'armor', 'strength', 'value')
VALUES ('$name', '$force', '$armor', '$strength', '$value')";

mysql_query ($query);

if (mysql_query($query))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added<br>";

echo "<br>variable $name test";
echo "<br>variable $force test";
echo "<br>variable $armor test";
echo "<br>variable $strength test";
echo "<br>variable $value test";


mysql_close();

?>


HTML files code:

Code: [Select]
<form action = "datainput.php" method = "post">



<div align="center">Item Submission Form</div><br><br>


<br>
<div align="center"><input type="text" name="table" value="head neck back or chest" size="32" maxlength="32"></div>
<br>
<br>
<div align="center"><input type="text" name="name" value="Type Name Here" size="32" maxlength="32"></div>
<br>
<br>
<div align="center"><input type="text" name="force" value="Type force number" size="32" maxlength="32"></div>
<br>
<br>
<div align="center"><input type="text" name="armor" value="Type armor value" size="32" maxlength="32"></div>
<br>
<br>
<div align="center"><input type="text" name="strength" value="Type strength value" size="32" maxlength="32"></div>
<br>
<br>
<div align="center"><input type="text" name="value" value="Type cost Here" size="32" maxlength="32"></div>
<br>
<br>
<br>
<div align="center"><input type="text" name="username" value="username here" size="32" maxlength="32"></div>
<br>
<div align="center"><input type="text" name="password" value="password here" size="32" maxlength="32"></div>
<br>
<div align="center"><input type="text" name="database" value="database Here" size="32" maxlength="32"></div>
<br>

<div align="center"><input type="submit" name="Submit_button" value="Submit"></div>

</form>

What is funky is the page seems to work, it says it writes a record but the record never appears in the database.
I did verify MIME types were correct for HTML to be allowed to write as php if needed, any idea why it wouldn't create a record?

hi i am not sure if i should be posting this problem hear.. so please direct me to the right place if i am.

I am trying to create a application form, for people wanting to apply for a apartment. I managed to connect to the database set up table, even make the actual form. Know that everything  is done i wanted to make it a little more interactive.

I want the form to automatically show the price per month and the size of the apartment if the applicant choses apartment 1 on the form, or if he chooses apartment 2.

a managed to tweak around with a filtering system by jquery but i am lost and tired, i wanted to know if there was something simple out there that could help me. Thank you so much for the help.

this is what im looking to incorporate on my site   http://www.cpifl.org/signup.cfm   can someone help me get something like this up and running? or recommend a form i could download and edit....   thanks trey    

Hello guys,   I was just wondering what I was doing wrong here, I've 'created' a website form in PHP but when I click my submit button it doesn't seem to fetch:    php.php?s=1   or    php.php?s=2   which is then used to print either Success or Failure.   Here's my code:

<html>
<head>

  <title></title>
  <meta charset="utf-8" /> 
  <link rel="stylesheet" href="footer.css" type="text/css"/>
  <link rel="stylesheet" href="header.css" type="text/css"/>
  <link rel="stylesheet" href="php/phpbody.css" type="text/css"/>

</head>

<!--body-->
<body>
	<div id="container">
		<h3 id="h3">Contact Me:</h3>
		<?php
			$s = isset($_GET['s']) ? $_GET['s'] : '';
			if ($s=="1") {
				echo ('<span class="success">Success! Your enquiry has been sent.</span>');
			}else if ($s=="2"){
				echo ('<span class="fail">Sorry! Your enquiry has not been sent. 
					Please ensure you have filled in the form correctly.</span>');
			}
		?>
		<h5 id="h5">To contact me, please use this form, created with PHP:</h5>
		<form id="form1" name="form1" method="POST" action"php/send.php">
			<strong>First Name:</strong><br><input type="text" name="firstname" id="firstname"><br><br>
			<strong>Last Name:</strong><br><input type="text" name="lastname" id="lastname"><br><br>
			<strong>E-mail:</strong><br><input type="text" name="email" id="email"><br><br>
			<strong>Enquiry:</strong><br><textarea name="enquiry" id="enquiry" cols="45" rows="5"></textarea><br><br>
			<strong>Security:</strong> 6 + 4 = <input type="text" name="security" id="security" size="1"><br><br>
			<input type="submit" name="submit" id="submit" value="Submit"/>
		</form>
	</div>	

  <?php include('header.php'); ?>
  <?php include('footer.php'); ?>

</body>
</html>

Send.php:

<?php

$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];
$enquiry = $_POST['enquiry'];
$security = $_POST['security'];

$to = "example@Outlook.com";
$subject= "New Form Enquiry";
$message = "A potential employer has submitted an enquiry from your website:\n\n 
First Name: $firstname\n\n Last Name: $lastname\n\n Email: $email \n\n Enquiry: $enquiry\n\n
You should probably respond.";

if($security = "10"){
	mail($to,$subject,$message);
	header("Location:php.php?s=1"); //php.php being the forms location
}else{
	header("Location:php.php?s=2"); //php.php being the forms location
}

?>

Any ideas would be much appreciated.   Thanks.
Edited by Coplestone, 17 January 2015 - 10:14 PM.