|
PHP - Php Mvc Coding Style Advise Needed
Hello.
I'm in need of help when it comes to page rendering, is it good practice to have own html file for each controller and controller->method OR 1 view file for each controller and then dynamically change content depending on the method?
My structure is like so:
controllers methods
-------------
services-> repair, car glass.....
info-> contact, about me.....
What is the best or good practice to handle the content in the view? The content is always the same.
Thanks in advance.
Similar Tutorialsi want to send products to resellers so they can show it to their clients but to show it not on my domain i thought of sending an email with html designed as my product details page BUT the problem here is that the forwarding action by my reseller will ruin the html mailer i thought of using php to pdf any other solutions thanks Hi, I use the following style for building my websites, I understand this is a fairly common style and was wondering if there is a name for it? Code: [Select] <?php include ('application.php'); include ('cms_config.php'); include ('templates/header.php'); switch ($_GET['action']) { case "home" : display_home(); break; case "services" : display_services(); break; case "testimonials" : display_testimonials(); break; case "contact" : display_contact(); break; default : display_home(); break; } include ('templates/footer.php'); // Function list // Display home page function display_home(){ $qid = mysql_query('SELECT * FROM testimonials ORDER BY RAND() LIMIT 0,1;'); include('templates/home.php'); } // Display services page function display_services(){ include('templates/services.php'); } // Display testimonials page function display_testimonials(){ $qid = mysql_query('SELECT * FROM Testimonials'); include('templates/testimonials.php'); } // Display home page function display_contact(){ include('templates/contact.php'); } ?> Hello guys, I am a beginner in PHP, so please be gentle. I am building this website for a friend of mine. This website is made up by HTML/CSS. i.e., I have a page made with HTML & CSS. there are a few menus on the page. say Home, About Us, Contact Us, etc., Now I want to separate the page elements (like header/footer) from the page so as its easy to work on. the source is something like this Code: [Select] <HTML> <HEAD> <TITLE> My Page </TITLE> <LINK REL="STYLESHEET" HREF="./mystyle.css" TYPE="text/css" /> </HEAD> <BODY> <DIV ID="wrapper"> <DIV ID="header"> <DIV ID="logo"> <UL ID="menu"> <LI> <A HREF="./index.php"><SPAN>Home</SPAN></A> </LI> <LI> <A HREF="./login.php"><SPAN>Login</SPAN></A> </LI> <LI> <A HREF="./contactus.php"><SPAN>Contact Us</SPAN></A> </LI> </UL> <DIV ID="date"> <?php echo Date("d M Y");?> </DIV> </DIV> </DIV> <DIV ID="bodywrapper"> <DIV ID="main"> <DIV ID="content"> THIS IS A TEST! </DIV> </DIV> </DIV> <DIV ID ="clearfooter"></DIV> </DIV> <DIV ID="footer"> © <?php echo date("Y");?> </DIV> </BODY> </HTML> now I will have my content in the DIV called 'content'. now I have separated this one page into three different pages. like this: header.php Code: [Select] <HTML> <HEAD> <TITLE> My Page </TITLE> <LINK REL="STYLESHEET" HREF="./mystyle.css" TYPE="text/css" /> </HEAD> <BODY> <DIV ID="wrapper"> <DIV ID="header"> <DIV ID="logo"> <UL ID="menu"> <LI> <A HREF="./index.php"><SPAN>Home</SPAN></A> </LI> <LI> <A HREF="./login.php"><SPAN>Login</SPAN></A> </LI> <LI> <A HREF="./contactus.php"><SPAN>Contact Us</SPAN></A> </LI> </UL> <DIV ID="date"> <?php echo Date("d M Y");?> </DIV> </DIV> </DIV> footer.php Code: [Select] <DIV ID ="clearfooter"></DIV> </DIV> <DIV ID="footer"> © <?php echo date("Y");?> </DIV> </BODY> </HTML> and index.php Code: [Select] <?php include_once('header.php');?> <DIV ID="bodywrapper"> <DIV ID="main"> <DIV ID="content"> THIS IS A TEST </DIV> </DIV> </DIV> <?php include_once('footer.php');?> Is this the right way to code? I am worried because I have to keep in mind the safety of the website as I have to include a basic login module to this. is there any other style to write this? please do let me know.. thanks I am making a simple shopping cart. To add a product, I use this code: Code: [Select] <?php if (isset ($_GET['action']) && $_GET ['action'] == 'add' ) { $id = intval($_GET['id']); $_SESSION['cart'][] = $id; } $cart = $_SESSION['cart']; if (!$cart) { echo "No product in cart."; } elseif ($cart) { foreach ($_SESSION['cart'] as $id) { echo $id; } } ?> <A href="index.html?action=add&id=1">Add to cart</A> I am going to be selling t-shirts, I'm going to need a size along with the product ID, so now I need to add a 'size' value. I've tried simply doubling up on the code above with this code, but it isn't working. I was wondering if I am going the right way about it? Code: [Select] <?php if (isset ($_GET['action']) && $_GET ['action'] == 'add , size') { $id = intval($_GET['id']); $_SESSION['cart'][] = $id; $size = intval($_GET['size']); $_SESSION['cart'][] = $size; } $cart = $_SESSION['cart']; if (!$cart) { echo "No product in cart."; } elseif ($cart) { foreach ($_SESSION['cart'] as $id) { echo $id; } foreach ($_SESSION['cart'] as $size) { echo $size; } } ?> <A href="index.html?action=add&id=1&size=sizel">Add to cart</A> Hay phpeoples (: I'm new around these parts and I'm looking for a bit of help. I'm trying to answer the following: Quote Upload task8.htm to your web site (found in the zip file you downloaded for this prac set) containing a form with a textbox to enter a customer id, a submit button and a reset button. Create the PHP page named task8.php. This page is the action of task8.htm and will receive the customer ID from the task8.htm page when it submits. Based on that submitted data task8.php should extract the order number, order date, and the shipped field for all orders placed by that customer. Sort the results in ascending order of the order date. Display the results in an appropriate table. Test the PHP script by entering a valid customer id (see your output from task 3 for the customer ids) in the text box of the form and then click submit. Verify that the results you obtain are correct by comparing the resulting data with that obtained from the tables in task 4. Change your SQL query if the data is not correct. Test the script again but this time use a customer id that does not exist. What happens? Modify your task8.php script to better handle this situation with an appropriate error message instead of displaying the table heading. Verify your results. NB: when testing try several valid customer IDs to ensure that the results are correct (never assume that just because you get output that the results are correct). this is my current HTML code: Code: [Select] <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <title>Prac3 Task 8</title> </head> <body> <h1>Task 8</h1> <!-- for the purpose of this and subseqent tasks DO NOT modify the method of this form --> <form id="customerform" action="task8.php" method="get"> <p>please fill in the following form</p> <p>Customer ID: <input type="text" name="custID"/><br/> <p><input type="submit" value="Submit"> <input type="reset" value="Reset"></p> </form> </body> </html> and this is my current php code: Code: [Select] <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <title>Prac 3 Task 3</title> </head> <body> <?php $conn = mysql_connect("localhost", "twastudent", "prac3"); mysql_select_db("warehouse", $conn) or die ('Database not found ' . mysql_error() ); $sql = "select * from orders"; $rs = mysql_query($sql, $conn) or die ('Problem with query' . mysql_error()); ?> <?php $custid = $_GET["custID"]; ?> <?php $row= mysql_fetch_array($rs); if ($custid == $row) ?> <table border="1" summary="Customer Details"> <tr> <th>cID</th> <th>Order number</th> <th>Order Date</th> <th>Shipped</th> </tr> <?php { ?> <tr> <td><?php echo $row["customerID"] ?></td> <td><?php echo $row["orderNumber"] ?></td> <td><?php echo $row["orderDate"]?></td> <td><?php echo $row["shipped"]?></td> </tr> <?php } mysql_close($conn); ?> </table></body></html> Currently it does not show me the records for the number that I type in. <?
// Bank Version 1.0.0 21-05-2014 Desmond O'Toole.
include ("secure/SecureFunctions.php");
include ("secure/SecureFunctionsLibAdmin.php");
session_start();
Session_Init();
$page = "Bank_EE Doc";
define ('hostname16', 'xxx'); // Des-otoole.co.uk
define ('username16', 'xxx');
define ('password16', 'xxx');
define ('database16', 'xxx');
function myErrorHandler($errno, $errstr, $errfile, $errline)
{
switch ($errno) {
case E_USER_ERROR:
$_SESSION['MyError'] = "Gotcha: <br>$errstr<br>$errfile<br>$errline";
mailtoX('Error', $errstr,$_SESSION['MyError']);
$redirect = "Location: myerror.php";
header($redirect);
exit(0);
break;
case E_USER_WARNING:
echo "This is your last warning";
break;
case E_USER_NOTICE:
echo "This is your final warning";
break;
default:
echo "Just go away";
break;
}
/* Don't execute PHP internal error handler */
return true;
}
$old_error_handler = set_error_handler("myErrorHandler");
function connectDB($db)
{
$host = hostname16;
$user = username16;
$pass = password16;
$data = database16;
if(!$link = @mysql_connect($host, $user, $pass))
trigger_error('Can\'t connect to server: ('. $db . ')', E_USER_ERROR);
if(!$database = @mysql_select_db($data, $link))
trigger_error('Can\'t select database on: (' . $db . ')', E_USER_ERROR);
}
connectDB(CURRENT_DB);
echo "Hi there";
?>
Hi this coding works on another website although I have reduced it down here for clarity. I have had my website moved to another server and I can't connect now.If there is a better way? I was given this coding from someone on this website about 4 years ago. I didn't want to use a strait connect because when there was difficulty connecting to the database I received an error giving me and any hacker all the details of the database server. This was to be a more controlled access. Edited by ignace, 09 June 2014 - 01:34 PM. Hello Everyone, I want to create my own Mafia game such as, "Infamous Gangsters" have i come to the right place Basically im new to PHP coding and i want to know a list of things before i start to learn 1.) Does it cost to create a website such as: Infamousgangsters.com? 2.) How long does it take to learn PHP coding before i have enough experience to create one? 3) Does anyone have any useful documents on PHP coding which i can read to learn basic knowledge? Many Thanks, Providence Hi All, I am trying create 4 dropdowns and load the values based on the value selected in the previous dropdown. I am able to do this for 3 dropdowns, but for the fourth dropdown I am no able to populate the value. Could someone help me out with this please? --------------------------------------- ajaxData_1.php
<?php
// Include the database config file
include_once 'dbconfig_1.php';
if(!empty($_POST["solutions_id"])){
// Fetch state data based on the specific country
$query = "SELECT * FROM releases WHERE solutions_id = ".$_POST['solutions_id'];
$result = $db->query($query);
if($result->num_rows > 0){
echo '<option value="">Select release</option>';
while($row = $result->fetch_assoc()){
echo '<option value="'.$row['releases_id'].'">'.$row['releases_name'].'</option>';
}
}
else{
echo '<option value="">Release not available</option>';
}
}
elseif(!empty($_POST["releases_id"])){
$query = "SELECT * FROM versions WHERE releases_id = ".$_POST['releases_id']."";
$result = $db->query($query);
if($result->num_rows > 0){
echo '<option value="">Select version</option>';
while($row = $result->fetch_assoc()){
echo '<option value="'.$row['version_id'].'">'.$row['supported_version'].'</option>';
}
}
else{
echo '<option value="">Version not available</option>';
}
}
elseif(!empty($_POST["versions_id"]))
{
$query = "SELECT * FROM platforms WHERE version_id = ".$_POST['version_id']."";
$result = $db->query($query);
if($result->num_rows > 0){
echo '<option value="">Select Version</option>';
while($row = $result->fetch_assoc()){
echo '<option value="'.$row['platforms_id'].'">'.$row['platforms_name'].'</option>';
}
}
else{
echo '<option value="">Platform not available</option>';
}
}
?>
<?php
if(isset($_POST['submit']))
{
echo 'Selected Solution ID: '.$_POST['solution'];
echo 'Selected Release ID: '.$_POST['release'];
echo 'Selected Version ID: '.$_POST['version'];
echo 'Selected Platform ID: '.$_POST['platform'];
}
?>
Index_3.php
<!DOCTYPE html>
<html>
<head>
<title style="color: 000000">Solution Compatibility Matrix</title>
<style>
select
{
padding: 12px;
min-width:280px;
margin-top:10px;
}
.san{
width:280px;
margin:0 auto;
margin-top:90px;
background-color:#FFFFFF;
padding:55px;
color: 000000;
}
label
{
color:#000000;
margin-bottom:25px;
}
html{
background-color: #3399CC;
}
</style>
</head>
<body>
</body>
</html>
Thanks, Arun Edited April 23, 2020 by cyberRobotAdded code tags
<?php
class Action
{
protected $_request;
protected $_response;
protected $_model;
protected $_view;
public function __construct(Request $request, Response $response)
{
$this->set_request($request)->set_response($response)->set_view($request, $response)->set_model();
// if request requires partial then do this
$partial = Partial::singleton();
$view = $this->get_view();
$view->set_partial($partial);
$partial->set_view(clone $view);
}
protected function set_request(Request $request)
{
$this->_request = $request;
return $this;
}
protected function set_response(Response $response)
{
$this->_response = $response;
return $this;
}
protected function set_view(Request $request, Response $response)
{
$this->_view = new View($request, $response);
return $this;
}
public function get_request()
{
return $this->_request;
}
public function get_response()
{
return $this->_response;
}
public function get_view()
{
return $this->_view;
}
public function dispatch($method, $parameters)
{
if ($this->get_request()->is_dispatched())
{
if(method_exists($this, $method))
{
call_user_func_array(array($this, $method), $parameters);
}
else
{
echo "unable to load method";
}
}
}
public function __get($property)
{
$property = '_' . $property;
if (property_exists($this, $property) &&
$property !== '$this->_request' &&
$property !== '$this->_responce')
{
return $this->$property;
}
return false;
}
public function set_model()
{
$class_name = get_class($this);
$model_name = trim($class_name, "_Controller");
$model_name = strtolower($model_name);
$property_name = '_' . $model_name;
$model_name = Inflection::singularize($model_name);
$model_name = ucfirst($model_name);
$model_class = $model_name . '_Model';
$this->{$property_name} = new $model_class();
}
}
<?php
class View
{
protected $_variables = array();
protected $_helpers = array();
public function __construct(Request $request, Response $response)
{
}
public function __set($name, $value)
{
$this->_variables[$name] = $value;
}
public function __get($name)
{
return $this->_variables[$name];
}
public function __call($name, $parameters)
{
$helper = $this->get_helper($name);
if (!$helper)
{
$helper = call_user_func_array(array(new $name(), '__construct'), $parameters);
$this->set_helper($name, $helper);
}
return $helper;
}
protected function set_helper($helper, $instance)
{
$this->_helpers[$helper] = $instance;
}
protected function get_helper($helper)
{
if (isset($this->_helpers[$helper]))
{
return $this->_helpers[$helper];
}
return false;
}
public function set_partial(Partial $partial)
{
if ($partial instanceof Partial)
{
$this->set_helper('partial', $partial);
}
}
public function render($file)
{
if (preg_match("/\.html$/i", $file))
{
require_once PRIVATE_DIRECTORY . 'application' . DS . 'views' . DS . $file;
}
}
}
<?php
class Partial
{
protected $_view;
protected $_templates;
protected static $_instance = null;
public static function singleton()
{
if (self::$_instance == null)
{
self::$_instance = new self();
}
return self::$_instance;
}
public function set_view(View $view)
{
$this->_view = $view;
}
public function __set($name, $options = array())
{
$this->_templates[$name];
$this->_templates[$name]['path'] = $options[0];
$this->_templates[$name]['variables'] = $options[1];
}
public function __get($name)
{
// when $this->paertial()->header; is called in view template
// it extracts variables and includes template view render() method
$file = $this->_templates[$name]['path'];
$variables = $this->_templates[$name]['variables'];
}
}
Hey guys im trying to make alternations to my personal framework by adding a Partial class as a helper to the View class so that I'm able to add partial templates in my bootstrap and load accordingly in my view template like a header and footer.
what im after is a bit of advise on the functioning of my Action/View and Partial please (not sure if what im doing is really right although it does work)
Basically my Controller will extend my action where a model and view is made for my controller to use. Then my partial class is sent as a helper to my view and a clone of view sent to my partial so that im able to use the view class in my partial to render my header and variables. (is this the correct way? or a good method?)
here's my code...like I said any advise would be greatly appreciated... thank you
Hi, im trying to learn about socket in PHP but unfortunatly not getting anywhere fast. The main issue is, the reason i want to learn about them is for use on a project where i will be connecting to a server, not actually being one. So although i am interested in the server part, its not essential. But to test my php socket code, i need something to connect to for debugging? So i have tried to create (from tutorials) a php server but not had any luck at all, can anyone advise me on where to start here? I basically want a way to send a command from a php file over TCP/IP, but for now just want it to bounce back or get a response, is there any test servers out there or do i have to create one? I have my own windows web server running here next to me for all my testing. Thanks Andy hi again guys n gals. Ive just pre-built a website that works fine. ive just moved all files to another server and now when i try to login it does nothing , also if i try to signup it gives this error ................. Code: [Select] Warning: gethostbyaddr() [function.gethostbyaddr]: Address is not a valid IPv4 or IPv6 address in /home/content/70/6589670/html/gaming/signup.php on line 87 i have NOT edited the code in anyway so m guessing its a server issue ... or could i be wrong ??? any help welcome , thanks for reading Ok. So I just started using prepared statements. One issue I ran into is that after inserting say "abc's" into the table with a prepared statement when I read that row and display it, it shows as abc\'s I have to use stripslashes on the variable before displaying it. I thought that with magic quotes. off this would not be a problem. Am I going to have to strip slashes on all fields now? Is there another way around it? here is my phpinfo for reference magic_quotes_gpc Off Off magic_quotes_runtime Off Off magic_quotes_sybase Off Off And compile options Configure Command './configure' '--host=i686-redhat-linux-gnu' '--build=i686-redhat-linux-gnu' '--target=i386-redhat-linux' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic' '--disable-rpath' '--without-pear' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-expat-dir=/usr' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--with-kerberos' '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr' '--enable-memory-limit' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--without-mime-magic' '--without-sqlite' '--with-libxml-dir=/usr' '--with-xml' '--with-mhash=shared' '--with-mcrypt=shared' '--with-apxs2=/usr/sbin/apxs' '--without-mysql' '--without-gd' '--without-odbc' '--disable-dom' '--disable-dba' '--without-unixODBC' '--disable-pdo' '--disable-xmlreader' '--disable-xmlwriter' '--disable-json' Thanks JT Hey Ok i'd say i'm pretty average with HTML, CSS and PHP I have my own website - www.leedsmethockey.co.uk and i want to develop a new section... i'll try and explain as best i can i have a database with all the players and their email address... When someone is selected for a match i wish the website to email their email address to let them know... please could someone advice me where i need to start and what sort of code i need to be looking into? Many Thanks Before I go digging around for code or conversion to unix time stamp, I'm curious how many of you have a birthday entry on a form which is the least hassle for the person filling out the form. For example a text box and they can enter 12/1/1992 or 12/1/92 or 12-1-1992 or three text boxes for month, day and year and if so, require an 01 or a 08 or 4 characters for year. The second method with three boxes would easily convert to a date stamp entry on the other hand if there is a php conversion that would convert any format (12/1/1992, 12/01/92, etc) to a unix time stamp that would make it easier for the person filling out the form. Thanks in advance for any ideas or help. Mike onkeydown="this.style.fontStyle='normal';"How can I add color: #000; to this? Thanks,
Background:
Question:
My experience: Code Examples:
function getInfo(ProductNumber){
$.ajax({
url:'Ajax-PHP-Page.php?ProductNumber='+ProductNumber,
success: function(html) {
document.getElementById("my_div").value = '';
document.getElementById("my_div").value = html;
}
});
}
function getInfo(ProductNumber) {
if (window.XMLHttpRequest) {
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp = new XMLHttpRequest();
} else {
// code for IE6, IE5
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("my_div").value = this.responseText;
}
};
xmlhttp.open("GET","Ajax-PHP-Page.php?ProductNumber="+ProductNumber,true);
xmlhttp.send();
}
Thank you!! Edited May 5, 2020 by StevenOliverIm making an E-learning system that when Student registers the Teacher will approve.. So i've got here a code that outputs all those who registered via Checkbox. Code: [Select] <form name="formapprove" method="POST" action="valval3.php" > <div id="apDiv12"><input type="image" src="images/Approve.png" name="approve" value="approve" width="170" height="35" border="0" > </div> <div id="apDiv11"> <input type="image" src="images/reject.png" name="reject" width="170" height="35" border="0" value="reject"> </div> <div id="apDiv14">'; $host="localhost"; $username="root"; $password=""; $db_name="dbreg"; $tbl_name="account"; mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sql="SELECT * FROM $tbl_name"; $result=mysql_query($sql); echo "<table border=\"5\" width=\"400\" >"; echo "<tr><th>List of Student to be approve</th>"; if(mysql_num_rows($result)) { while($row = mysql_fetch_assoc($result)) { echo "<tr><td>"; echo "<input type='checkbox' name='list[]' value='".$row['Username']."'>".$row['famname'].",".$row['gname']. ",".$row['mname']. ".<br/></td>"; echo "</tr></input>"; } } else { echo "<tr><td align=\"center\"> No Student to be Approve / Reject </td></tr>"; } echo' </form> Then the file "valval3.php" will be the one that will save the variables in my database.. Code: [Select] <?php session_start(); if(isset($_SESSION['uname2']) || ($_SESSION['section'])){ $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } if(isset($_POST['approve_x'], $_POST['approve_y'])) { mysql_select_db("dbreg", $con); $uname = $_SESSION['uname2']; $sec = $_SESSION['section']; $sql="SELECT * FROM account where sec='$sec'"; $result=mysql_query($sql); if(mysql_num_rows($result)) { while($row = mysql_fetch_assoc($result)) { $fullname = "" .$row['famname']. ", " .$row['gname']. " " .$row['mname']. "."; } foreach ($_POST['list'] as $checkbox) { $sql="SELECT * FROM account WHERE sec='$sec'"; } $result=mysql_query($sql); if(mysql_num_rows($result)) { while($row = mysql_fetch_assoc($result)) { $username = $row['Username']; $password = $row['Password']; $gname = $row['gname']; $mname = $row['mname']; $famname = $row['famname']; $sec = $row['sec']; $studnum = $row['studnum']; $fullname = "" .$row['famname']. ", " .$row['gname']. " " .$row['mname']. "."; $username = stripslashes($username); $password = stripslashes($password); $username = mysql_real_escape_string($username); $password = mysql_real_escape_string($password); $gname = stripslashes($gname); $famname = stripslashes($famname); $gname = mysql_real_escape_string($gname); $famname = mysql_real_escape_string($famname); $mname = stripslashes($mname); $mname = mysql_real_escape_string($mname); foreach ($_POST['list'] as $checkbox) { mysql_query("INSERT INTO dbaccount (Username, Password, gname, famname, mname, sec, studnum, fullname) VALUES ('$username', '$password', '$gname', '$famname', '$mname', '$sec', '$studnum', '$checkbox')") or die(mysql_error); mysql_query("DELETE FROM account WHERE sec='$sec'") or die(mysql_error); } echo '<script type="text/javascript"> {alert("Approved!");} </script>'; echo '<meta http-equiv="REFRESH" content="0;url=approvereject2.php">'; mysql_close($con); } } else { echo '<meta http-equiv="REFRESH" content="0;url=approvereject2.php">'; } }elseif(isset($_POST['reject_x'], $_POST['reject'])) { mysql_select_db("dbreg", $con); foreach ($_POST['list'] as $checkbox) { $sql="SELECT * FROM account WHERE sec='$sec'"; } $result=mysql_query($sql); if(mysql_num_rows($result)) { foreach ($_POST['list'] as $checkbox) { mysql_query("DELETE FROM account WHERE sec='$sec'") or die(mysql_error); } echo '<script type="text/javascript"> {alert("Rejected!");} </script>'; echo '<meta http-equiv="REFRESH" content="0;url=approvereject2.php">'; } else { echo '<meta http-equiv="REFRESH" content="0;url=approvereject2.php">'; } } else { echo '<meta http-equiv="REFRESH" content="0;url=approvereject2.php">'; } } } else { header("location:failunautho.php");; } ?> I tested my codes. Its only working if theres only 1 user registered ( which means one checkbox would appear in page) But when i tested to have 3 users registered and not yet approve, There would be an error saying.. Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 49 Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 49 $username = mysql_real_escape_string($username); <-- line #49 Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 50 Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 50 $password = mysql_real_escape_string($password); <-line #50 Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 54 Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 54 Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 55 Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 55 $gname = mysql_real_escape_string($gname); <-line #54 $famname = mysql_real_escape_string($famname); <-line# 55 Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 58 Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 58 mname = mysql_real_escape_string($mname); <-line #58 Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 64 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 64 mysql_error VALUES ('$username', '$password', '$gname', '$famname', '$mname', '$sec', '$studnum', '$checkbox')") or die(mysql_error) <-line #64 Then still it saves 3 variables.. but all the same. Hope Someone could help me .. I have 4 files like attached.... if i clicked on index.php content-1 link... that open templet.php and body load with content-1.txt please helpme Hi All I am fairly new to the PHP world so please excuse my ignorance. (I am trying!) Basically I bought a commercially available PHP script and created my own script to work alongside the bought one. What happened then is that the developers of the script I bought released a new version of the software. My script no longer works and is throwing up the following error PHP Fatal error: Using $this when not in object context in C:\wamp\www\classifieds\system\core\System.php on line 175 I've worked out that the script fails on this line, in the new version of the software. $dbhost = System::getSystemSettings('DBHOST'); On review of the commercial script's coding, I noticed that where the old version used the syntax above, the new version uses a syntax as shown below $this->appContext->getSystemSettings('DBHOST'); So I went and modified my script (mismatched.php) to read as follows $dbhost = $this->appContext->getSystemSettings('DBHOST'); But im now getting the following errors PHP Parse error: syntax error, unexpected T_REQUIRE_ONCE, expecting T_FUNCTION in C:\wamp\www\classifieds\admin\mismatched.php on line 5 I'd appreciate any ideas you may have that could help me get my script (mismatched.php) working again. Thanks again Ali Hey, I would there be a way i could create a form in which upon entering a domain name/URL it will tell you how many connections there are to the site and how many (if any) MySQL queries are running? If I add this line to a wordpress footer it displays the number of sql queries. Code: [Select] <?php echo get_num_queries(); ?> queries in <?php timer_stop(1); ?> seconds. Any help is greatly appreciated. Thanks. |
|||||||