joel24

September 28, 2010

after the query string put in

 
$query = "INSERT INTO driversnew (id, name, location, date_of_birth, car_number, favourite_track, least_favourite_track, achievements, sponsors, email, image)

echo $query; 
exit();

VALUES ('$_POST[id]', '$_POST[name]', '$_POST[location]','$_POST[date_of_birth]', '$_POST[car_number]','$_POST[favourite_track]', '$_POST[least_favourite_track]','$_POST[achievements]', '$_POST[sponsors]','$_POST[email]', '$image_name')";

mysql_query( $query ) or die( '<br>Query string: ' . $query . '<br>Created error: ' . mysql_error() );

so you can view the mysql query and debug

September 28, 2010

and are you pointing to the txt file correctly,

i.e. is the file in the same directory as the PHP script, or is it in a subfolder?

September 28, 2010

use rtrim()

i.e. rtrim($string, "0"); then you'll have to remove decimal aswell

September 28, 2010

use the round() function if you want an integer instead of a decimal, you can round it when you echo the distance or when you insert into the db...

September 28, 2010

you're only reading 5 bytes of the text file... read up on fread here

$theData = fread($fh, 5);
//the 5 indicates 5 bytes to be read, change this to filesize($myFile). i.e.

<?php $myFile = "indexbody.txt";
$fh = fopen($myFile, 'r');
$theData = fread($fh, filesize($myFile));
fclose($fh);
echo $theData;?>

September 28, 2010

for starters, you're inserting the image_name into the email field, not the image field and also, you need to wrap the values in {} when accessing an array value in quotes, and the index must be wrapped in single quotes i.e. $_POST[id] should be {$_POST['id']}

for that code you need to verify an image is uploaded before you insert the row into the database, and do the changes to the code mentioned above... also it would probably be best to have a default value for that field (image), so that if no value is sent mysql automatically sets it to the default value.

i.e.

if ($image_name=='')
{
$image_name = "xxx.jpg";
}

mysql_query("INSERT INTO driversnew (id, name, location, date_of_birth, car_number,
   favourite_track, least_favourite_track, achievements, sponsors, email, image)
VALUES ('$_POST[id]', '$_POST[name]', '$_POST[location]','$_POST[date_of_birth]', '$_POST[car_number]','$_POST[favourite_track]', '$_POST[least_favourite_track]','$_POST[achievements]', '$_POST[sponsors]','$_POST[email]', '0')");

September 28, 2010

you'll need to cycle through a loop and echo out each clip ID/url in the object url.

a foreach loop will cycle through every index in an array, no need for count like in your for loop.

and then if you wish to use the current embed code string, you'll have to replace __YOUTUBE_ID__ with the corresponding youtube id with str_replace()


<?php

$number = 0;
$youtubeIds = array("MX0D4oZwCsA","2v-v3jh-Cco","WuYDSa4BRaw","zwo48StJSr4","exOxUAntx8I");

$embedCode = '<object width="480" height="385"><param name="movie" value="http://www.youtube.com/v/__YOUTUBE_ID__?fs=1&hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/__YOUTUBE_ID__?fs=1&hl=en_US" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="480" height="385"></embed></object>';

$string = implode($youtubeIds);


?>

<!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" lang="en" xml:lang="en" xmlns:fb="http://www.facebook.com/2008/fbml" xmlns:og="http://opengraphprotocol.org/schema/">
<head>
<title>Youtube Videos</title>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="language" content="en" />
</head>

<body>
<h1>Youtube Videos</h1>

<p><?php
foreach($youtubeIds as $value)
{
//replace
echo '<div>' . str_replace("__YOUTUBE_ID__", $value, $embedCode) . '</div>';
} ?> </p>
</body>
</html>

September 28, 2010

you need to set the timezone in the PHP.ini file,

look for

date.timezone = "YOUR_TIME_ZONE"

and set it to your timezone, a list of timezones can be found here

September 28, 2010

I don't use PHPmyadmin, I'm sure there is a default value option for each column?

if you were writing the create table query in SQL, it would look something like

CREATE TABLE articles (

  articleID int(11) NOT NULL auto_increment,

  name varchar(50) NOT NULL default '',

  articleText TEXT NOT NULL default '',

  image varchar(150) NOT NULL default 'default.jpg',

  PRIMARY KEY  (articleID)

)

... or if you've already created the table, you can alter it with sql

ALTER TABLE articles MODIFY image varchar(150) NOT NULL DEFAULT 'default_image.jpg';

September 27, 2010

something like this will get you started.

//text array
$my500lines = array();
$tempText = '';

$string = "line 1
line 2
....
line 3453
line 3454
etc...";

$count = 0;

foreach(preg_split("/(\r?\n)/", $string) as $line){
    $count++;

if ($count == 500)
{
//reset count and temptext
$my500lines[] = $tempText;
$tempText = '';
$count = 0;
}
else
{
$tempText .= $line;
}

}

September 27, 2010

you need to enclose the string you wish to echo inside quotes unless they are constants... which they're not in that script

i.e.

<?php
$link = mysql_connect  ('localhost','root', 'PASSWORD');
if (!$link)
   print "unsuccessful";
else
   print :successful";
mysql_close($link);
?>

September 27, 2010

i would have a db table like

articleID | title | articleText | image

with the image column storing the filename of the image, i.e. image1.jpg

I would then wait for the image script to execute and then if that is successful insert the article details into the DB.

i.e. swap the last part of the upload script to something like

// move file into the directory and the path name into the database// also must execute if no image has been uploadedif (move_uploaded_file($image['tmp_name'], $TARGET_PATH)){        $sql = @mysql_query("INSERT INTO xxx SET rarara = rara, image = {$image['name']}");if ($sql){$success = "successful!";}else{$error = "error!";}        exit;}else{                $_SESSION['error'] = "Could not upload file.  Check read/write persmissions on the directory";                exit;}

then you will have to ensure the script is capable of allowing a user to upload an article without an image, i.e. set the mysql image field to default to "default.jpg" and then ensure default.jpg exists in the images folder.

September 26, 2010

I added the alert (pop box) line in so you could ensure the correct data was being sent to the PHP page.

you can remove the line "alert(option);" in the jquery / javascript.

as for the 'Array ( [select] => option2 ) ", that is the print_r($_GET); telling us what is being received by $_GET.

You should use a switch statement instead of all your if/else ifs. read about switch here

switch ($_GET['select']) {
    case "option1":
        echo "option1";
        break;
    case "option2":
        echo "option2";
        break;
    case "option3":
        echo "option3";
        break;
default:
echo "No Option Selected";
}

//you can finish switch code to include all your options and their corresponding data

######

and also, the problem in your current code is that you are trying to echo $_GET['select2'], then $_GET['select3'] etc when in your Jquery you are sending the $_GET variables with the index "select" in "select:option"

    $.get('option.php', {select:option}, function(data) {
      $('#result').html(data).hide().fadeIn(1000);
    });

if you wish to have it sent via $_GET with index option2, option3 etc, you can change select:option in the jquery to $(this).attr("name") > the name of the form element

//put in 
<script src="http://code.jquery.com/jquery-latest.js" type="text/javascript"></script><br>

<script type="text/javascript">

$(document).ready(function(){
  $('.select').change(function() {
                        
var myIndex = $(this).attr("name");
    var option = $(this).val();
alert(option);
    $.get('option.php', {myIndex:option}, function(data) {
      $('#result').html(data).hide().fadeIn(1000);
    });
  });

});
</script>

September 26, 2010

//put in 
<script src="http://code.jquery.com/jquery-latest.js" type="text/javascript"></script><br>

<script type="text/javascript">

$(document).ready(function(){
  $('.select').change(function() {
                        
    var option = $(this).val();
alert(option);
    $.get('option.php', {select:option}, function(data) {
      $('#result').html(data).hide().fadeIn(1000);
    });
  });

});
</script>

and then change the PHP script to echo all $_GET values

<?php

print_r($_GET);
exit();

   // Multiple Selections
if ($_GET['select'] == 'option1' && $_GET['select2'] == 'option3') {
  echo 'the option you have chosen is 1 and 3';} 
elseif ($_GET['select2'] == 'option4' && $_GET['select3'] == 'option5' && $_GET['select4'] == 'option7') {
  echo 'the option you have chosen is 4, 5 and 7';}   
  
  // and so on
  
  //Selection 1
  elseif($_GET['select'] == 'option1') {
  echo 'the option you have chosen is 1';} 
  elseif($_GET['select'] == 'option2') {
  echo 'the option you have chosen is 2';} 
  
  //Selection 2
  elseif($_GET['select2'] == 'option3') {
  echo 'the option you have chosen is 3';} 
  elseif($_GET['select2'] == 'option4') {
  echo 'the option you have chosen is 4';} 

  //Selection 3
  elseif($_GET['select3'] == 'option5') {
  echo 'the option you have chosen is 5';} 
  elseif($_GET['select3'] == 'option6') {
  echo 'the option you have chosen is 6';} 

  // Selection 4
  elseif($_GET['select4'] == 'option7') {
  echo 'the option you have chosen is 7';} 
  elseif($_GET['select4'] == 'option8') {
  echo 'the option you have chosen is 8';} 

?>

this should help you to rectify the problem, knowing what $_GET values are being sent and ensuring they are as they should be.

September 26, 2010

use htmlentities()

*edit: if you want it exactly the same, i.e. not translated with HTML entities, you can wrap the input value in single quotes and ensure none are in the string, or vice-versa i.e.

$test = '<object height="81" width="100%"> <param value="http://player.soundcloud.com/player.swf?url=http%3A%2F%2Fsoundcloud.com%2Fgeneralpie%2Fdukebox001&secret_url=false" name="movie"> <param value="always" name="allowscriptaccess"> <embed height="81" width="100%" type="application/x-shockwave-flash" src="http://player.soundcloud.com/player.swf?url=http%3A%2F%2Fsoundcloud.com%2Fgeneralpie%2Fdukebox001&secret_url=false" allowscriptaccess="always"> </object>';

//html, ensure to wrap in single quotes as $test string contains double quotes.
<input type='text' value='<?php echo $test; ?>' />

September 23, 2010

should work, the $_SERVER['http_referer'] must not be getting set...

i.e. try this

//print $_server variables to see that the referer is being set.
print_r($_SERVER);

//test code
$xsblock = "http://www.bob.com/testchan";
$url = "testchan";
$pos = strpos($xsblock, $url);
if ($pos == false) {
echo "not found";
} else {
echo "found";
}

September 23, 2010

have a look at this PDF;

http://php.net/manual/en/function.mysql-real-escape-string.php...

mysql_real_escape_string() is a good function to start with

September 22, 2010

also, do a print_r($_GET); to ensure that the $_GET values are being sent as suspected.

//remove this line once everything is working
print_r($_GET);

switch($_GET){

case 'topic':
include 'modules/pages/posts.php';
break;
case 'forum':
include 'modules/pages/topics.php';
break;
case 'parent':
include 'modules/pages/parents.php';
break;
case 'do':
if ($_GET['do'] == 'unanswered') {

include 'modules/pages/unanswered.php';

} elseif (isset($_GET['do']) == 'today') {

include 'modules/pages/today.php';

}
break;

//default, include forums page
default:
include 'modules/pages/forums.php';
break;

}

September 21, 2010

when the session is started, you can set a session variable with the current unix timecode... then check to see if it is more than 1hour past the sign in time...

session_start();

//log in etc etc
//when login authenticated, add this line
$_SESSION['sessionStart'] = time();

then in your script where it checks the user is logged in each time a page is viewed, add a line like

if ((time() - $_SESSION['sessionStart']) > 60*60)
{
session_destroy();
exit("Session expired");
}

September 21, 2010

you won't learn anywhere near as much by using templates. read some of those books and they have tutorials guiding you through building mockup sites

September 21, 2010

... because isset($_GEt['do']) is returning true, or false.

so your if statement is transformed to

elseif (true/false == 'today')

you need to have

} elseif (isset($_GET['do']) && $_GET['do'] == 'today') {

September 21, 2010

Another learning route would be to get the book "Build Your Own Database Driven Website Using PHP&MySQL"... I found this book extremely useful when I began learning PHP & SQL...

September 20, 2010

if you don't know the name of the file, you'll need to loop through the files in the directory with readdir(), there is an example on the PHP.net site

then you'll need to read the information held within those files and hope the data is formatted in a way that you can pull it out... tutorial on reading txt files is here http://www.tizag.com/phpT/fileread.php

*edit: posted wrong link

September 20, 2010

have a look at jQuery's $.post and $.ajax... or if you're set on traditional javascript/ajax try this tutorial...

September 16, 2010

:confused:

you want to echo the value of a constant...?... but not the name of the constant?

define("MyConstant", "testing");
echo "This will echo my constant: " . MyConstant;

Sign In

joel24

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by joel24

if no image insert image with value

insert text into the body content from a .txt file

Only display decimals if they're present

Only display decimals if they're present

insert text into the body content from a .txt file

if no image insert image with value

NOOB help: Dynamically Embed php

mysql_connect problem

upload form help

Split $string to several smaller chunks of lines

mysql_connect problem

upload form help

Multiple dropdown list to load content

Multiple dropdown list to load content

echo'ing out embed codes

Stop XS posting?

Class to clean HTTP data

elseif

session expire time

Website and Lack of skills

elseif

Website and Lack of skills

parse filename and contents of textfile

Ajax status code problem

db and defined constants

Browse

Activity

Important Information