Can you provide us with the link to the application and the code for the sql query. Check the format of the values submitted to the database and the table columns format that correspond to these values. Do you think the format match ?
I was in your same situation. It was hard to pick in which way to go, but after I tried to do everything from scratch, I realized how much code I had to write, so I felt that I really should use a framework which have everything built to me (MVC structure, Libraries, Helpers etc...). There are many free frameworks available online. CI is really powerful, and has the best guide and many free tutorials. Here's a graph that compares the google search for many known frameworks. http://www.google.com/trends/explore#q=zend%20framework%2C%20%20codeigniter%2C%20%20symfony%2C%20%20yii%2C%20%20kohana&cmpt=q
You need to check the rest of the code, it looks like it was a delete a record page. Try this, but you need to secure it by restricting the variable passed to accept only integer values, otherwise it will redirect to 'X.php'or display an error.
<?php
session_start();
// default user's name
$user = '';
// if visitor is logged in
$loggedIn = (!empty($_SESSION['user']));
// since user is logged in, let us retrieve user's name from $_SESSION
if ($loggedIn) {
$user = $_SESSION['user'];
} else {
// we only allow logged in user to see this page
// if visitor not logged in, redirect visitor to login page
header('Location: index.php');
exit;
}
// the file that contains your database credentials like username and password
require_once('config/database.php');
// see Lecture Webp_Week13_14_Using_PHPandMySQL(updating).pptx Slide 4 aka Step 1
$mysqli = new mysqli($database_hostname, $database_username, $database_password, $database_name) or exit("Error connecting to database");
// Slide 5 aka Step 2
$stmt = $mysqli->prepare("INSERT INTO assignment_speeches ( id,subject,body,tags,image )
SELECT id,subject,body,tags,image
FROM assignment_speeches
WHERE id = ?");
// Slide 6 aka Step 3 the bind params must correspond to the ?
$stmt->bind_param("i",$_GET['id']); // 1 ? so we use i. we use i because id is INT
// Slide 7 aka Step 4
$successfullyDeleted = $stmt->execute();
// Slide 8 aka Step 5
// we won't check the delete result here.
// Slide 9 aka Step 6 and 7
$stmt->close();
$mysqli->close();
// if we successfully delete this, we
if ($successfullyDeleted) {
$_SESSION['message'] = 'Successfully deleted';
} else {
$_SESSION['message'] = 'Unable to delete';
}
header('Location: homepage.php');
?>
okay I was replying from my mobile... In you copyspeech.php, you should retrieve the information passed using the $_GET. I'm not sure where you want to replicate the information (I mean to which table). But you should have this on your page:
$id = $_GET['id'];
if(isset($_GET['id']) && !empty($_GET['id']) && is_numeric($id)){
$sql="INSERT INTO assignment_speeches_copy ( id,subject,body,tags,image )
SELECT id,subject,body,tags,image
FROM assignment_speeches
WHERE id = $id";
mysql_query($sql);
}
You may need to make some modifications but this is the main concept of replicating a data.
I agree with your first point, but some people suggest this website without convincing the user. Why is w3school a good start ?!
use your search engine instead of your w3schools bookmark - you may be surprised at the quality of tutorials out there.
w3schools was always a good introduction for html tags, and google first result is this website. It has a very friendly interface and a 'try it yourself' option. I think it's really what a biginner needs ...
It depends on what you want to do ... HTML CSS for web deisgn PHP for dynamic websites (or ASP) it's a long list .... Choose which field you want to learn more about to know which language best fits your needs.
<?php
session_start();
include "func.php";
foreach($_GET as $k=>$v)
$id.=$k;
$id=validatet($id);
if($id !="") {
if($_SESSION["refid_session"]=="") {
$_SESSION["refid_session"]=$id ;
}
}
include "header.php";
include "config.php";
$rs=mysql_query("select * from pages where ID=1") or die(mysql_error());
$arr=mysql_fetch_array($rs);
echo stripslashes($arr[2]);
include "footer.php";
?>
you don't need to go to phpmyadmin!! Just modify your code, where it's written mysql_query("....."), just appand to it 'or die(mysql_error())' so the final code is: mysql_query("....") or die(mysql_error()) do this every time you use the mysql_query function.
to do an online offline system u nees to set a column for the last_active to store when the user was lastly active (this is used in case the user close the browser without signing out) and u need to set another column is_online to check if the user is online when logged in or offline when signed out In this case, the condition to check if the user is online is: check if the user is online and the last_active is less than 10min
First of all the server is running linux or windows ? For linux you can use the lampp which is provided by the same company that created the xampp. To access the server from another computer, type the ip of the server in the browser so you will be able to access the xampp as a normal user. To access files you need an FTP software like filezilla.
If you are new to this field, I recommend you to read a PHP & MySQL book (For dummies is a good collection) or buy on online tutorial. Here are the steps you need to learn: 1- Basic PHP code 2- Learn the SQL operations (select, insert, update, delete) 3- Learn how to integrate PHP and MySQL
And trust me it's one of the easiest open source CMS to create a website (usually a blog). Just download it from the official website http://wordpress.com/ , then intall it on your local host and check how easy it is.
why don't you keep both -moz- and -webkit- at the same time ? and why are you using them .. you can do this with simple css no need for moz and webkit, personally i use them only to round corners
Very easy,here's a detailed connection PHP & MySQL:
//$variables to use in the connection
$host = 'localhost'; //Most of the time it''s 'localhost' but may be different
$user = 'root'; //username
$pass = ''; //password
$db = 'daniweb';
//first you have to make the connection, if not made => mysql_error()
$connection = mysql_pconnect($host,$user,$password);
//select the datbase you want to use, if not found => mysql_error()
mysql_select_db($db,$connection) or die(mysql_error());
//now the sql part
$query = mysql_query("SELECT * FROM table");
//fetch results
$row = mysql_fetch_assoc($query);
//Count results (optional)
$row_num = mysql_num_rows($query);
okay i think that's becuz the $_POST['Name'] is not set in print.php. actually u are redirecting to the page print.php and not submitting the input values ... In other words u may use the post in the save.php cuz the form action is pointing to save.php but not in print.php. To fix this u can use the $_GET['name'] in print.php. Like this:
you can easily fix that by using the percentage %. Let's say that the background div has an id of 'context', then the css would contain:
context:{width:100%};
if you don't want to complicate your self by opening the css file and save and refresh. Use the firebug plugin on firefox or use the inspect element of google chrome browser so you can preview changes directly on the browser without affecting your files. When you're ok with the width, apply the changes to your files. Good luck
It's very easy, just use photoshop to crop the button and the box field. Then in HTML create a form that contain a input for the search box and submit button for the search, to do so:
what does it give you when you enter the ip on the browser from the other pc, for example when entering 192.168.x.x ? Is it page not found or access forbidden or what?
