MrDaisy

December 3, 2015

table{
 table-layout:fixed;
 width:400px;
 word-break:break-all;
}
http://www.w3schools.com/cssref/pr_tab_table-layout.asp

i tried this already, it's not working..

December 3, 2015

Dear all,

i am getting the following issue with my tables, as they resize according to text size,

how can make it all same size and auto break text to second line to make it more readable and consistent ( the following image is the test i was running )

i tried to change the css and do style for table however it didn't work..

here my css

/* my style sheet */
body {font-family:verdana;}
body{width:100%;}
a:hover {text-decoration:none; color:red;}
h1 {color:blue; text-align:center;}
h3{
color:Blue;
	text-align:center;
}
p{
	font-size;10pt;
	text-align:center;
	}
header{
	width:75%; 
	padding:10px; 
	margin-top: 0px;
	margin-right: auto;
	margin-bottom: 0px;
	margin-left: auto;
	border:solid;
	background-color:#8F9779;
	opacity:0.8;
  filter:alpha(opacity=80); /* For IE8 and earlier */
	}
	
nav{
	width:75%; 
	padding:10px; 
	margin-top: 0px;
	margin-right: auto;
	margin-bottom: 0px;
	margin-left: auto;
	border:solid;
	background-color:#8F9779;
opacity:0.9;
  filter:alpha(opacity=90); /* For IE8 and earlier */
}

main{
	width:75%; 
	padding:10px; 
	margin-top: 0px;
	margin-right: auto;
	margin-bottom: 0px;
	margin-left: auto;
	border:solid;
	background-color:#8F9779;
	opacity:0.9;
  filter:alpha(opacity=90); /* For IE8 and earlier */
	}

footer{
	width:75%; 
	padding:10px;	
	margin-top: 0px;
	margin-right: auto;
	margin-bottom: 0px;
	margin-left: auto;
	border:solid;
	background-color:#8F9779;
	opacity:0.9;
  filter:alpha(opacity=90); /* For IE8 and earlier */
	}
	
table{ margin-left:auto;} 
table,th,td {
	border:solid 1px;	
	}

	table.table-style-one {
		font-family: verdana,arial,sans-serif;
		font-size:11px;
		color:#333333;
		border-width: 1px;
		border-color: #3A3A3A;
		border-collapse: collapse;
	}
	table.table-style-one th {
		border-width: 1px;
		padding: 8px;
		border-style: solid;
		border-color: #3A3A3A;
		background-color: #B3B3B3;
	}
	table.table-style-one td {
		border-width: 1px;
		padding: 8px;
		border-style: solid;
		border-color: #3A3A3A;
		background-color: #ffffff;
	}
	body {
    background: no-repeat fixed;
    -webkit-background-size: cover;
    -moz-background-size: cover;
    -o-background-size: cover;
    background-size: cover;
}
ul {
    list-style-type: none;
    margin: 0;
    padding: 0;
    overflow: hidden;

}

li {
    float: left;

}

a:link, a:visited {
    display: block;
    width: 110px;
    font-weight: bold;
   /* color: #3B444B;
     3B444B background-color: #8F9779;*/
    text-align: center;
    padding: 4px;
    text-decoration: none;
    text-transform: uppercase;
}
/*
a:hover, a:active {
    background-color: #F0FFFF;
}*/
#category ul {
    float: left;
    width: 100%;
    padding: 0;
    margin: 0;
    list-style-type: none;
}

#category a {
    float: left;
	padding: 0;
    margin: 0;
    text-decoration: none;
    border-right: 1px solid black;
}

#category a:hover {
    background-color:  #F0FFFF;
}

#category li {
    display: inline;
}
.wrapper {
        text-align: center;
    }
    .wrapper ul {
        display: inline-block;
        margin: 0;
        padding: 0;
        /* For IE, the outcast */
        zoom:1;
        *display: inline;
    }
    .wrapper li {
        float: left;
        padding: 2px 5px;
    }

and here the code for the tables in the image

       echo "<table class=table-style-one align=center>";

     /*       echo "<tr>";
             //   echo "<th>Review ID</th>";
			//	echo "<th>Posted On:</th>";
                echo "<th>By:</th>";
                echo "<th>Title:</th>";
                echo "<th>Rate:</th>";
                echo "<th>Review</th>";
                
            echo "</tr>";*/
        do{
            // display first review and then fetch rest of the reviews
         //   echo "<tr>";
		 echo "<center>";
		 echo "<br>";
            //    echo "<td>" . $row['Review_ID'] . "</td>";
			echo "<tr><th> Review Number " . $row['Review_ID'] . " For " . $row['Product_Name'] . "</th></tr>";
			echo "<tr><th> Review Title: " . $row['Review_Title'] . " Rated with ". $row['Review_Rate'] . "/5</th></tr>";
			echo "<td><p>This Review is posted on " . $row['Review_Date'] . " By " . $_SESSION['client_name'] . "</align></p></td>";
			echo "<tr><th>Review</th></tr>";
            echo "<td><center>" . $row['Review'] . "</center></td>";
				echo "</center>";
				echo "</table>";
				echo "<table class=table-style-one align=center>";
           // echo "</tr>";
        }while($row = mysqli_fetch_array($result));
        echo "</table>";
		echo "<br>";
		echo "<br>";
        ?>
        </table>
        <?php
    }
		
	
	?>

December 2, 2015

i did the following,

added a primary key for OrderHistoryID and change the insert into,

$sql ="INSERT INTO `cib4003_h00233671_at`.`orderhistory`(`OrderHistoryID`,`order_id`, `Product_ID`, `Product_Name`, `client_ID`, `quantity`) VALUES (NULL, '".$_GET['HID']."', '".$_GET['Product_ID']."', '".$_GET['Product_Name']."', '".$_SESSION['client_ID']."', '".$_GET['qty']."');";

however, still the database empty after the insert

December 2, 2015

Dear all,

i have been working in my college project and i reached a point were i can't get my cart orders into Order history, as it's not working and keep giving me the following error page,

Error : INSERT INTO `cib4003_h00233671_at`.`orderhistory`(`order_id`, `Product_ID`, `Product_Name`, `client_ID`, `quantity`) VALUES ('', '', '', '2', '');
Duplicate entry '0' for key 'PRIMARY'

^ i checked the databse and all values are 0 except the Client_ID... thats why i am getting Duplicate entry, however, i tried to fix the problem for the past few hours and i can't find the issue,

here my cart page code

<?php
if (!isset($_SESSION)) {session_start();}  //start session
if (!isset($_SESSION['client_ID'])) {
	//echo "<script>alert('not logged in');</script>";
	header("Location: index.html"  );
	}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="keywords" content="Games, Gaming, PS4, PS3, XBOX, Video games">
<meta name="description" content="Games 4 You">
 <meta name="viewport" content="width=device-width, initial-scale=1.0">
 <meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Games 4 You</title>
<link rel="stylesheet" type="text/css" href="Styles/ProductsStyle.css">
    <!-- javascript/jQuery -->
<script src="http://code.jquery.com/jquery-1.11.0.min.js"></script>

</head>
<body>
<!--Add the following script at the bottom of the web page (before </body></html>)-->
<script type="text/javascript" async="async" defer="defer" data-cfasync="false" src="https://mylivechat.com/chatinline.aspx?hccid=42206151"></script>
 <script>// disable zoom to keep image fit and always in position
  document.firstElementChild.style.zoom = "reset";
  </script>

<script type="text/javascript">

    // declare list of backgrounds
    var images = ['bg-01.jpg', 'bg-02.jpg', 'bg-03.jpg', 'bg-04.jpg', 'bg-05.jpg', 'bg-06.jpg', 'bg-07.jpg'];

    // declare function that changes the background
    function setRandomBackground() {
        // choose random background
        var randomBackground = images[Math.floor(Math.random() * images.length)];

        // set background with jQuery
        $('body').css('background-image', 'url("Images/' + randomBackground + '")');
    }

    // declare function that sets the initial background, and starts the loop.
    function startLoop() {
        // Set initial background.
        setRandomBackground();

        // Tell browser to execute the setRandomBackground every 5 seconds.
        setInterval(setRandomBackground, 5 * 1000);
    }

    // One the page has finished loading, execute the startLoop function
    $(document).ready(startLoop);

</script>
<header id="header">
  <div class="container">

<center><img src="Images/Title.png" alt="Title"></div>
</center>
</header>
<center>
<nav>
	<?php
echo "<p> Welcome ".$_SESSION['client_name']."</p>";
	//create connection
   $con = new mysqli("localhost", "student", "student", "cib4003_h00233671_at");
	if ($con->connect_errno) { //failed
    echo "Failed to connect to MySQL: (" . $con->connect_errno . ") " . $con->connect_error;
	}?>
	<div class="wrapper">
	<ul id="category" >
  <li><a href="Products.php">Home</a></li>
  <li><a href="Products.php">Products</a></li>
  <li><a href="Productscart.php">View Cart</a></li>
  <li><a href="About.php">About</a></li>
  <li><a href="Settings.php">Settings</a></li>
  <li><a href="logout.php">Logoff</a></li>
</ul>
</nav>
</div>
</center>
<main><!-- start with main tags which will include the php and tables -->
<h3>Order Check Out</h3><!-- text above the table using style to move it  -->
<?php
   //new connection
   $con = new mysqli("localhost", "student", "student", "cib4003_h00233671_at");
	if ($con->connect_errno) { //failed
    echo "Failed to connect to MySQL: (" . $con->connect_errno . ") " . $con->connect_error;
	}
 //success 

	// run sql 
	$sql="SELECT * FROM products,clientscarts WHERE products.Product_Name=clientscarts.Product_Name AND clientscarts.client_ID=".$_SESSION['client_ID'];
	$result = mysqli_query($con,$sql);
	//output 
	if(mysqli_num_rows($result)==0) //no records found
		{
header("Location: products.php"  );
		}
		else // records were found in DB
		{
		//echo "<p>You have: ".mysqli_num_rows($result)." pizza(s)</p>";
	//	echo "<p>You have: ".$totalPizza." pizza(s)</p>";
		
?>

<?php 
	?>
		

                <table class="table-style-one"  align="center">
                    <tr>
					<th>Order ID</th>
					<th>Product Name</th>
					<th>Product Image</th>
					<th>Price ($)</th>
					<th>quantity</th>
					</tr>

           
	<?php 
while ($row =mysqli_fetch_array($result)){
			echo "<tr>";
			echo "<td size=2>".$row['Order_ID']."</td>";
			echo "<td><center><img src='".$row['picture']."'</center>";
			echo "<td size=2>".$row['Product_Name']."</td>";
			   if ($_SESSION['User_Type'] == "VIP" && $row['Discount_VIP'] < 1 ){
            echo "<td>".($row['Price'] * $row['Discount_VIP'] )."$<h4 style=font-size:3> After Discount</h1></td>";
				   }
				   else  if ($_SESSION['User_Type'] == "Platinum" && $row['Discount_Platinum'] < 1 ){
            echo "<td>".($row['Price'] * $row['Discount_Platinum'] )."$<h4 style=font-size:3> After Discount</h1></td>";
				   }
				   else if ($_SESSION['User_Type'] == "Gold" && $row['Discount_Gold'] < 1 ){
            echo "<td>".($row['Price'] * $row['Discount_Gold'] )."$<h4 style=font-size:3> After Discount</h1></td>";
				   }
				   else if ($_SESSION['User_Type'] == "Silver" && $row['Discount_Silver'] < 1 ){
            echo "<td>".($row['Price'] * $row['Discount_Silver'] )."$<h4 style=font-size:3> After Discount</h1></td>";
				   }
				   else
				   {
		    echo "<td>".$row['Price']."$ </td>";
				   }
            echo "<td><center><a href='increasequantity.php?PID=".$row['Order_ID']."'/><h4>Increase ➕</h4></a>".$row['quantity']."<a href='decreasequantity.php?PID=".$row['Order_ID']."'/><h4>Decrease ➖</h4></a></center></td>";
	$total=$total+($row['Price']*$row['quantity']);
	$totalGames=$totalGames+($row['quantity']);
}
echo "<center>";
echo "<tr><td colspan='5'><center>Total of<b> ".$totalGames."</b> Game's with total of <b>".$total."$</b> </center></td>";
// echo "<form method=POST action=OrderHistory.php?HID='".$row['order_id']."'>";
echo "<tr>
		<th>Payment option:</th>
		<td><select name='paymentoption'><option>MasterCard</option><option>Visa</option><option>Pay in delivery</option></select></td>
		<td><img src=Images/CC.gif alt=CC></td>
		</tr>";
echo "<tr>
		<th>Name of Card Holder: </th>
		<td><input type=text size=35 maxlength=35 name=NCH required placeholder=Enter Card holder name></td>
		<td rowspan='3'><img src=Images/Front-of-Card.png alt=CCFront></td>
		</tr>";
echo "<tr>
		<th>Card Number: </th>
		<td><input type=text size=19 name=CardN placeholder=1234-5678-9012-3456 pattern=[0-9]* maxlength=19 required title=19 characters Maximum>
		</td>
		</tr>";
echo "<tr>
		<th>Expiration date: </th>
		<td>
		<input type=text size=2  maxlength=2 name=YED pattern=.{2,}  required title=2 characters Maximum placeholder=Month>
		<input type=text size=4  maxlength=4 name=YED pattern=.{4,}  required title=4 characters Maximum placeholder=Year>
		</td>
		</tr>";
echo "<tr>
		<th>CCV: </th>
		<td>
		<input type=text size=3 maxlength=3 name=CardN pattern=.{3,} required title=3 characters Maximum placeholder=CCV>
		</td>
		<td><img src=Images/Back-of-Card.png alt=CC></td>
		</tr>";
		
echo "<td colspan=3 align=center><a href='OrderHistory.php?HID='".$row['order_id']."'><img width=200 height=96 src=Images/checkout.png></a></td>";
//echo "<td align=center colspan=3><input type=submit value=submit></td>";
echo "</center";
	echo "</tr>";
	echo "</table> ";
 }

?>

   </h2>
</main>
</body>
<!-- main tag closed followed by closing body tag -->
<footer><!-- footer start here with in-line style plus using underline for website link HCT Portal -->
  <div id="google_translate_element"></div><script type="text/javascript">
function googleTranslateElementInit() {
  new google.translate.TranslateElement({pageLanguage: 'en', layout: google.translate.TranslateElement.InlineLayout.HORIZONTAL, multilanguagePage: true}, 'google_translate_element');
}
</script><script type="text/javascript" src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script>
        
</footer><!-- Close footer -->
</html><!-- close HTML tag -->

and here my history php where i do the insert part

<?php
if (!isset($_SESSION)) {session_start();}  //start session
if (!isset($_SESSION['client_ID'])) {
	//echo "<script>alert('not logged in');</script>";
	header("Location: index.html"  );
	}
?>
<?php
	if (!isset($_GET['HID'])) {
	header("Location: index.html"  );
	}
   //new connection
   $con = new mysqli("localhost", "student", "student", "cib4003_h00233671_at");
	if ($con->connect_errno) { //failed
    echo "Failed to connect to MySQL: (" . $con->connect_errno . ") " . $con->connect_error;
	}
 //success 

	// run sql  
	$sql ="INSERT INTO `cib4003_h00233671_at`.`orderhistory`(`order_id`, `Product_ID`, `Product_Name`, `client_ID`, `quantity`) VALUES ('".$_GET['HID']."', '".$_GET['Product_ID']."', '".$_GET['Product_Name']."',  '".$_SESSION['client_ID']."', '".$_GET['qty']."');";
	if ($con->query($sql) === TRUE) {echo "<h3> New record created successfully</h3>";
	header("Location: Products.php"  );
	} else {
		echo "Error : " . $sql  . "<br>" . $con->error;
	}
	$con->close();
?>

Sign In

MrDaisy

Posts

Joined

Last visited

Content Type

Profiles

Forums

Events

Posts posted by MrDaisy

Tables output differ

Tables output differ

Cart Order to History Order table

Cart Order to History Order table

Browse

Activity