Learn VBA & Macros in 1 Week!

PHP - Issues With For [warning: Noob Question]

Full Excel VBA Course - Beginner to Expert

Issues With For [warning: Noob Question]	View Content

hey guys!

I just got started with php (yesterday) and im currently trying to write a script that cuts email signatures off.

The first filter ($sig[0]) works fine, the string is cut and posted- and, well, that's it.
I think i did sth wrong within the for- but i cant find it.

So please help me out.
A hint would be fine already.

Thanks in advance- and here is some code:

Code: [Select]
<?php
$string="TESTSTRING!! I AM AN EMAIL TEXT!!! SO RANDOM! --- I AM A SIGNATURE!! HERP DERP CUT ME OFF";

//define possible sig starts (=filter)
$sig[0]=("#==");
$sig[1]=("---");
$sig[2]=("the name of an enterprise");
$sig[3]=("___");

for ($i=0; $i<=3; $i++) { /* or count($sig) ? */
$sigpos=strpos($string,$sig[$i]);
if($sigpos>0) {
$string= substr($string,0,$sigpos);
break;
echo $string;
}
else
{
echo $string;
break;
}
}
?>
<br>
<?
//show where the sig is cut off
echo $sigpos;
?>

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Preg_match_all Array And Foreach [warning: Noob Question]

<{[warning]}>ultra Hard Question! Do Not Enter Unless You Are 1337<{[warning]}>

Srry Noob Question

Noob Question About Databases

Quick Noob Question....

Absolute Noob Question

Noob Question - Best Way To Add A Class To A Doc

I'm Such A Noob, But I Have A Question About My Code

Noob Question Sessions And Forms

Random String? (noob Question :p)

Ultra Noob Question About Strings

Paging System (very Noob Question)

Noob Question - Displaying Count By Group

Failed To Open Stream (noob Question)

Php Warning: Session_start(): Cannot Start Session When Headers Already Sent In And Warning: Cannot Modify Header Information

Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource, Boolean Given In (please Help Me With This Warning I Really Need This)

Noob Question About "->"

Am I In Row Number 1 ? Noob Noob Here ...

Error Csv To Mysql :warning: Fopen() And Warning: Fopen()

Learn VBA & Macros for Excel in 1 Week!

Preg_match_all Array And Foreach [warning: Noob Question]

Similar Tutorials

hey guys!

Im trying to get hashtags out of a string.
The function works so far- but i cant transfer the insides of the preg_match_all array into the string.

A hint would be fine already.

Thanks in advance- and here is some code

Code: [Select]
<?php
//example string
$strcontent = "ima string... #wat #taggy #taggytag im in your stringz, stealing your charz!";

//find hashtags
preg_match_all("/(#\w+)/", $strcontent, $matches);
echo $matches;            //the output is just "array" -> why?
foreach ($matches as $match)
{
//  $tempmatch=$match[1]; #####like this?
        //hiding the hashtags via span
$strtemp="<br>ima span<br>" . $match . "<br>ima /span<br>" . $strcontent;
$strcontent = $strtemp;
echo $strcontent;
}
#echo $strcontent;

  # <span style="display:none;"></span>
?>

<{[warning]}>ultra Hard Question! Do Not Enter Unless You Are 1337<{[warning]}>

Similar Tutorials

I am running to an issue that I have never delt with before and am not sure if there is even a possible solution:

I have two files:

fileA and fileB

fileA contains a loop that loops 30 times each time its called. in the loop there is a 2second delay

$i = 1;
do {
   $i++; sleep(2);
   if(!isset($_SESSION['user'])
  {
        break;
   }
} while($i < 31);

if fileB i have a simple destroy session

$_SESSION = array();
session_destroy();

I call both files via ajax, and that is where i run into my problem.

if I call fileA first, then call fileB through ajax, the code in FileB does not execute until fileA has run its course.

Is it possible to get around this?

Like set the priority of one over the other?

Noob Question.

Similar Tutorials

Hi all i have a silly noob question....

When i directly query my database with the following i get the exact result i want.......

Code: [Select]
SELECT * FROM posts WHERE postTopic=3 AND postSubject=business;

However when i try this using the following PHP.......

$sql = "SELECT * FROM posts WHERE postTopic =" . mysql_real_escape_string($_GET['id']) . "AND postSubject='" . $_SESSION[forum] . "'";

I get no result

I also get the correct results from

$sql = "SELECT * FROM posts WHERE postTopic =" . mysql_real_escape_string($_GET['id']) . ";

and

$sql = "SELECT * FROM posts WHERE postSubject='" . $_SESSION[forum] . "'";

mysql_real_escape_string($_GET['id']) is an integer and $_SESSION[forum] is a string.

I know this has something to do with the manner in which the query is passed with the AND and the string but i can't for the life of my work out where i am going wrong.

Thanks for any help.

Srry Noob Question

Similar Tutorials

But how do I check input to make sure that the input has to be seperated by commas and has to be a integer

like "1,2,3,4,5" is correct

if a user puts "1,:25,,l2@" or something funky, I can error out

Thanks

also is there a php function that does this already? and is this way safe? im trying to store comma seperated id's

Noob Question About Databases

Similar Tutorials

OK, so I have a question about databases and how they sort things being loaded into them. I have a database that I have images uploaded to (some people dont like to do it this way but this is what is going to work for my project). I have it set up with an id column that auto-increments. When I upload the files for some reason it is putting the highest id number first and the second one is the lowest then it goes in order from there. Why would this be happening and how do I correct it?

Quick Noob Question....

Similar Tutorials

Long story short i'm paginating database results. So pages = results / res-per-page-limit

but 28 / 10 will be 2.8 should i use round() or ceil()?

Absolute Noob Question

Similar Tutorials

I'm really sorry if this has been answered (I assume it has) I'm unfamiliar with search terms of what I am trying to do.

I have this web page

Code: [Select]
<html>
<body>

<?php
$con = mysql_connect("localhost","user","pass");
if (!$con)
  {
  echo "Fail";
  die('Could not connect: ' . mysql_error());
  }

echo "Triumph";
?>

</body>
</html>
Which I got from a snippet. I load the webpage expecting to see fail or triumph, but I see nothing.

My question is how to run the php script so I see something on the page (hopefully triumph.

I apoligise for my noobness, I'm a PHP know nothing at the moment.

Noob Question - Best Way To Add A Class To A Doc

Similar Tutorials

OK so sorry if my understandings a bit off, but if a I want to introduce a class into my doc is the best way to fo this with the include() function?

I'm Such A Noob, But I Have A Question About My Code

Similar Tutorials

I hope no one rolls their eyes at me, lol, but I literally, just made my first PHP script, but I ran into a snag. Okay so the code I did was <!DOCTYPE html>
<html>
<body>

<?php

echo <h1>"my First PHP script"</h1>;

?>

</body>
</html> but in firefox the outcome is always "my first PHP script?> I had added the h1 tags because it wouldn't print at all before I did. I'm trying to figure out what I did wrong.

Noob Question Sessions And Forms

Similar Tutorials

I'm almost embarrassed to ask such a simple question but I just cannot get this to work. I'm trying to figure out how to use sessions that takes the information from a form on the first page and displays it on the last.
I have this on page 1:
<?php
session_start();
?>
<form action="test2.php" method="post">
<p>Page 1</p>
<p>First Name <input type="text" name="first" /></p>

<p><input type="submit" value="Next page 2" /></p>

And this for page 2:
<?php
SESSION_START();

$_SESSION['first'] = $_POST['first'];
echo $_SESSION['first'] = $_POST['first'];

?>
<form action="test3.php" method="post">
<p>Page 2</p>
<input type="submit" value="Next page 3" />
</form>

And this for page 3:
<?php
SESSION_START();

$_SESSION['first'] = $_POST['first'];
echo $_SESSION['first'] = $_POST['first'];

?>

<p>Page 3</p>
<p>You're done</p>

I can get it to display on page 2 but not on page 3. Can anyone tell me why? I've been at this for a long time and it should be simple but I cannot get it to work. Thanks in advance.

Random String? (noob Question :p)

Similar Tutorials

Hi everyone

Well I've started learning php yesterday and now I encountered my first problem, I looked around but I don't really know what to search for if I want my answer so here I come

Code: [Select]
<html>
<body>
<?php
$names = array('Peter','Quagmire','Joe');
$ages = array("Peter"=>32, "Quagmire"=>30, "Joe"=>34);
$who = rand(0,2);
$who2 = $names[$who];
echo "$names[$who] is $ages[$who2] years old";
?>
</body>
</html>
This is the script I have, and there is the kind of script I expected:

Code: [Select]
<html>
<body>
<?php
$names = array('Peter','Quagmire','Joe');
$ages = array("Peter"=>32, "Quagmire"=>30, "Joe"=>34);
$who = rand('Peter','Quagmire','Joe');
echo "$who is $ages[$who] years old";
?>
</body>
</html>
But after some search I concluded that rand is only used for random numbers

So, my question is, which function should I use to achieve my goal? Is there any randstring('string1','string2',etc) command?

Tnx for your time

Ultra Noob Question About Strings

Similar Tutorials

So I'm using simplexml_load_file($url) to load up a client's XML file so I can use it with a jQuery slide show right.

My problem is that some of the strings within the xml files are often times sentences and when I echo, for example...

Code: [Select]
echo $xml->images->categories->category[$gallery]->images->image[0]->description[0];

I should see Dream as if you'll live forever, Live as if you'll die today but all I'm getting is Dream as if you

It appears as though php is getting confused when it sees those little single quotes.

Anyone?

Paging System (very Noob Question)

Similar Tutorials

Hello everyone!

I'm completely new to PHP and Databases. I've managed to do some nice work by reading, but now I've encountered a problem I can't solve.

I made a site with trailers and got tierd of adding them manually. So I created a form which sends the trailer info to my database.

There's now trailers in specific organized genres. But the list is beginning to get really big so I wanted to show just 10 trailers per page. And so I found out I could use a paging system which I ALMOST got working. Just one last thing that needs to be fixed and that is when I click on next page "http://www.xxxxxxxx.com/test.php&page=2" it doesn't show the content. While "http://www.xxxxxxxx.com/test.php" does.

So I just need that next button to work, I don't know if theres something missing or what it is...

Note: I'm new to all this so please excuse my very very bad coding.

Here is my code:

test.php
<link rel="stylesheet" type="text/css" media="all" href="http://www.xxxxxxxxxxxxx.n.nu/createdfiles/trailers/style-twentyten.css" />
<link rel="stylesheet" type="text/css" media="all" href="http://www.xxxxxxxxxxxxx.com/paginate.css" />

<?php

$rpp = 10; // results per page
$adjacents = 4;

$page = intval($_GET["page"]);
if(!$page) $page = 1;

$reload = $_SERVER['PHP_SELF'];

// connect to your DB:
$link_id = mysql_connect("server","username","my password");
mysql_select_db("database");

// select appropriate results from DB:
$sql = "SELECT * FROM blablabla WHERE Genre LIKE '%Drama%' ORDER BY `blablabla`.`sort` DESC LIMIT 0, 9999";
$result = mysql_query($sql, $link_id);

// count total number of appropriate listings:
$tcount = mysql_num_rows($result);

// count number of pages:
$tpages = ($tcount) ? ceil($tcount/$rpp) : 1; // total pages, last page number

$count = 0;
$i = ($page-1)*$rpp;
while(($count<$rpp) && ($i<$tcount)) {
    mysql_data_seek($result,$i);
    $query = mysql_fetch_array($result);

    // output each row:
    echo "<br />--------------------------------------------------------------------------------------------------------<br /><br />";
?><strong> <img src=" <?php echo $query['Poster'];?>" /><?php
  echo "<br /> <br />";

//////////////////////////////
//SHOW TITLE, YEAR AND GENRE//
//////////////////////////////

  echo "<H1>";
  echo $query['Title'];
  echo "<br /> <br />";
  echo "</h1>";
?></strong> <?php
  echo "<H2>";
  echo $query['Year'];
  echo "</H2>";
  echo "<br />";
  echo "<H3>";
  echo $query['Genre'];
  echo "</H3>";
?>
<a href="
<?php

//////////////////////////////
//SHOW IMDB, ACTORS AND PLOT//
//////////////////////////////

  echo $query['IMDB'];
?>
" target="_self">Link to IMDb</a>
<?php
  echo "<br /> <br />";
  echo "<H2>Stars:</H2>";
  echo "<br />";
  echo "<H3>";
  echo $query['Actors'];
  echo "</H3>";
  echo "<br />";
  echo "<H2>Plot:</H2>";
  echo "<br />";
  echo "<H3>";
  echo $query['Plot'];
  echo "</H3>";
  echo "<br /> <br />";
  echo "<H2>";

////////////////
//SHOW TRAILER//
////////////////

?>
<div id="<?php echo $query['ID'];?>" style="display: none;">
<?php
  echo $query['Youtube'];
  echo "</div>";
?>
<a href="javascript:ReverseDisplay('<?php echo $query['ID'];?>')">Click to show/hide trailer.</a>
<?php
  echo "</H2>";
  echo "<br /> <br />";

    $i++;
    $count++;
}

// call pagination function:
include("paginate_one.php");
echo paginate_one($reload, $page, $tpages);
?>

<?php
////////////////////////////////
//SCRIPT FOR SHOW/HIDE TRAILER//
////////////////////////////////
?>

<script type="text/javascript" language="JavaScript"></script>

paginate_one.php
<?php
/*************************************************************************
php easy :: pagination scripts set - Version One
==========================================================================
Author:      php easy code, www.phpeasycode.com
Web Site:    http://www.phpeasycode.com
Contact:     webmaster@phpeasycode.com
*************************************************************************/
function paginate_one($reload, $page, $tpages) {

$firstlabel = "First";
$prevlabel  = "Prev";
$nextlabel  = "Next";
$lastlabel  = "Last";

$out = "<div class=\"pagin\">\n";

// first
if($page>1) {
$out.= "<a href=\"" . $reload . "\">" . $firstlabel . "</a>\n";
}
else {
$out.= "<span>" . $firstlabel . "</span>\n";
}

// previous
if($page==1) {
$out.= "<span>" . $prevlabel . "</span>\n";
}
elseif($page==2) {
$out.= "<a href=\"" . $reload . "\">" . $prevlabel . "</a>\n";
}
else {
$out.= "<a href=\"" . $reload . "&page=" . ($page-1) . "\">" . $prevlabel . "</a>\n";
}

// current
$out.= "<span class=\"current\">Page " . $page . " of " . $tpages . "</span>\n";

// next
if($page<$tpages) {
$out.= "<a href=\"" . $reload . "&page=" .($page+1) . "\">" . $nextlabel . "</a>\n";
}
else {
$out.= "<span>" . $nextlabel . "</span>\n";
}

// last
if($page<$tpages) {
$out.= "<a href=\"" . $reload . "&page=" . $tpages . "\">" . $lastlabel . "</a>\n";
}
else {
$out.= "<span>" . $lastlabel . "</span>\n";
}

$out.= "</div>";

return $out;
}
?>

Here you can view a test of it all in action: http://www.mansgullberg.com/test.php please dont hack my site

I'm thankfull for all of your answers! Really nice forum this!

/kvickan

Noob Question - Displaying Count By Group

Similar Tutorials

Hi guys,

Sorry - I know this is a basic question but I've been out of the game for a year now and need to jog my memory.

I am trying to count the number of rows per group. e.g:

$sql = "SELECT *, COUNT(id) FROM image GROUP BY city";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);

echo $row['COUNT(id)'];

So if there are, for example, 5 New York's in the table, 3 London's and 2 Sydney's I want the echo to display 5, 3, 2

Should I use a loop for this?

Cheers

Failed To Open Stream (noob Question)

Similar Tutorials

Hello there.
I used this code so many times long ago, but I still don't remeber and don't know what I'm doing wrong.
http://circus.ka-blooey.net/

If I try to click on any link below the post, I got the error:
Code: [Select]
Warning: include(.php) [function.include]: failed to open stream: No such file or directory in /home/kablooey/public_html/circus/index.php on line 5

Warning: include(.php) [function.include]: failed to open stream: No such file or directory in /home/kablooey/public_html/circus/index.php on line 5

Warning: include() [function.include]: Failed opening '.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/kablooey/public_html/circus/index.php on line 5
-----------------------x

My index is:

Code: [Select]
<?php
include("header.php");
?>

<? if (empty($_GET["boo"])) {$boo="news/show_news";} include "$boo.php"; ?>

<?php
include("footer.php");
?>
and the footer, where the links are is:

Code: [Select]
<br />
<div id="menu"><center><a href="http://circus.ka-blooey.net">clear</a> ---x--- <a href="?boo=out">links out</a> ---x--- <a href="?boo=credits">credits</a></center></div><br />
<br />
<br />
<div id="footer"><img src="http://circus.ka-blooey.net/layout/circus_footer.jpg" /></div>
</div>
</div>
</div>

</body>
</html>
Help please? =/

Php Warning: Session_start(): Cannot Start Session When Headers Already Sent In And Warning: Cannot Modify Header Information

Similar Tutorials

Hi Everyone

I am having a few issues with my website. I have developed in on my xampp local host and it works ok but when I upload the files and try to renew a membership using stripe I get the following messages.

Warning: session_start(): Cannot start session when headers already sent in /customers/a/d/f/mywebsite.co.uk/httpd.www/mywebsite/inc/settings.php on line 2

Warning: Cannot modify header information - headers already sent by (output started at /customers/a/d/f/mywebsite.co.uk/httpd.www/mywebsite/procedures/payments/charge.php:1) in /customers/a/d/f/mywebsite.co.uk/httpd.www/mywebsite/procedures/payments/charge.php on line 141

I have some includes that appear on every page. This is the bootstrap.php file. This file holds the settings.php which connects to my database and other function files.

In this settings page I call the session_start() php function and then connect to my database.

I call the bootstrap.php file on every page to there for call the session_start() on every page.

I am using sessions alot so is this the right thing to do?

I have attached the renew_membership payment page which holds the form. The user fills out the payment page and the form data gets sent to a script called charge.php which uses the stripe objects to make the payment. I then want to do a redirect to the paymentSuccess.php page to output to the user that the payment was made successfully. This is where the issues arrise. I have split the charge file into 3 screen shots so it is more readable.

Hope someone can help me.

Thanks a lot

David

Edited April 26 by Irish_Dave

Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource, Boolean Given In (please Help Me With This Warning I Really Need This)

Similar Tutorials

<?php
if(isset($_POST['submit'])){
$name = $_POST['name'];
}
?>
<form method="POST" action="hist1.php">
<br />
<input type="hidden" name="name" value="<?php echo $name ?>" />
<?php
$q = mysql_query("SELECT * FROM histact1 ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question1 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5]; 
?>


<div class="Qset" id="q1"><br /><br />
<label class="items">1st Question :</label> <br />
<center>
<textarea class="textareaQ" name="question1" readonly><?php echo $question1; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad1" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />


<input type="radio" name="rad1" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />


<input type="radio" name="rad1" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt"  href="#q2"><label title="Proceed to 2nd Question">Next</label></a>
</center> 
</div> 
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>


<br /><br />
<?php
$q = mysql_query("SELECT * FROM histact1 ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question2 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5]; 
?>


<div class="Qset" id="q2"><br /><br />
<label class="items">2nd Question :</label> <br />
<center>
<textarea class="textareaQ" name="q2" readonly><?php echo $question2; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad2" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />


<input type="radio" name="rad2" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />


<input type="radio" name="rad2" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt"  href="#q1"><label title="Proceed to 1st Question">Back</label></a> &nbsp;|&nbsp; 
<a class="nxt"  href="#q3"><label title="Proceed to 3rd Question">Next</label></a>
</center> 
</div> 
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>


<br /><br />
<?php
$q = mysql_query("SELECT * FROM histact1 ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question3 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5]; 
?>


<div class="Qset" id="q3"><br /><br />
<label class="items">3rd Question :</label> <br />
<center>
<textarea class="textareaQ" name="q3" readonly><?php echo $question3; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad3" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />


<input type="radio" name="rad3" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />


<input type="radio" name="rad3" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt"  href="#q2"><label title="Proceed to 2nd Question">Back</label></a> &nbsp;|&nbsp; 
<a class="nxt"  href="#q4"><label title="Proceed to 4th Question">Next</label></a>
</center> 
</div> 
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>


<br /><br />
<?php
$q = mysql_query("SELECT * FROM histact1 ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question4 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5]; 
?>


<div class="Qset" id="q4"><br /><br />
<label class="items">4th Question :</label> <br />
<center>
<textarea class="textareaQ" name="q4" readonly><?php echo $question4; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad4" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />


<input type="radio" name="rad4" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />


<input type="radio" name="rad4" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt"  href="#q3"><label title="Proceed to 3rd Question">Back</label></a> &nbsp;|&nbsp; 
<a class="nxt"  href="#q5"><label title="Proceed to 5th Question">Next</label></a>
</center> 
</div> 
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>


<br /><br />
<?php
$q = mysql_query("SELECT * FROM histact1 WHERE question != '$question1' AND question != '$question2' AND question != '$question3' AND question != '$question4' ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question5 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5]; 
?>


<div class="Qset" id="q5"><br /><br />
<label class="items">5th Question :</label> <br />
<center>
<textarea class="textareaQ" name="q5" readonly><?php echo $question5; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad5" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />


<input type="radio" name="rad5" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />


<input type="radio" name="rad5" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt"  href="#q4"><label title="Proceed to 4th Question">Back</label></a> &nbsp;|&nbsp; 
<input type="submit" title="Submit Answers" name="submit" class="submit" value=" Submit " onclick="return confirm('Are you sure you want to submit your answers?\nYou can review your answer by click the Back link')" />
</center> 
</div> 
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>
</form>

Edited by mac_gyver, 09 October 2014 - 10:51 AM.
code in code tags please

Noob Question About "->"

Similar Tutorials

Hey all,

I have read as much as I could about "->" (I guess its called the arrow operator)

anyway I cant seem to comprehend what it is.

Could someone please explain it in the most simplistic way?

Thanks in advanced.

Am I In Row Number 1 ? Noob Noob Here ...

Similar Tutorials

Please bear with me.
In an html file there is an


.....


I need to draw a separation hr between all rows escept the first one.
I believe I need a counter.
Please show me how to do this.

Thank you.

Error Csv To Mysql :warning: Fopen() And Warning: Fopen()

Similar Tutorials

So I am tryting to create a script to upload a CSV file into a MySql DB. It has like 10K records into SQL My Code is copy below ... I get the following errors. Line 16 is the $handle line 18 is the While Statement Error: Warning: fopen(): Filename cannot be empty in C:\local\htdocs\ADPStorage\DemandCSV.php on line 16

Warning: fopen()expects parameter 1 to be resource, boolean given in C:\local\htdocs\ADPStorage\DemandCSV.php on line 18 I use my script for another table and it worked like a charm. Less data and less colums do. Bad Code: (good Code sample below. this one)

<?php

$today = date("m.d.y.h.m.s");                       
echo $today;

$BPTD_fy = '2014';
$BPTD_updatedate = $today;

  $conn = mysql_connect("Localhost","root","password") or die (mysql_error());
  mysql_select_db("ds_storage",$conn);
  
	if(isset($_POST['submit']))
	{
		$file = $_FILES['file']['tmp_name'];
		  
		  $handle = fopen($file, "r");
		
		while(($fileop = fgetcsv($handle, 100000, ",")) !==FALSE)
		{
			$BPTD_fy = $fileop[0];
			$BPTD_Status = $fileop[1];
			$BPTD_Classification = $fileop[2];
			$BPTD_ProcureCat = $fileop[3];
			$BPTD_Product = $fileop[4];
			$BPTD_Project = $fileop[5];
			$BPTD_DSCategory = $fileop[6];
			$BPTD_Calculated = $fileop[7];
			$BPTD_CapacityType = $fileop[8];
			$BPTD_Amount = $fileop[9];
			$BPTD_Jul = $fileop[10];
			$BPTD_Aug = $fileop[11];
			$BPTD_Sep = $fileop[12];
			$BPTD_Oct = $fileop[13];
			$BPTD_Nov = $fileop[14];
			$BPTD_Dec = $fileop[15];
			$BPTD_Jan = $fileop[16];
			$BPTD_Feb = $fileop[17];
			$BPTD_Mar = $fileop[18];
			$BPTD_Apr = $fileop[19];
			$BPTD_May = $fileop[20];
			$BPTD_Jun = $fileop[21];
			$BPTD_Location = $fileop[22];
			$BPTD_Env = $fileop[23];
			$BPTD_Requester = $fileop[24];
			$BPTD_ServiceArea = $fileop[25];
			$BPTD_ServiceGroup = $fileop[26];
			$BPTD_DepHead = $fileop[27];
			$BPTD_Recgroup = $fileop[28];
			$BPTD_RecOwner = $fileop[29];
			$BPTD_Entrydate = $fileop[30];
			$BPTD_updatedate = $fileop[31];
			
			
			$sql = mysql_query("INSERT INTO inv_bpt_demand (Status, Classification, ProcureCat, Product, Project, DSCategory, Calculated, CapacityType, Amount, Jul, Aug, Sep, Oct, Nov, Dec, 
			Jan, Feb, Mar, Apr, May, Jun, Location, Env, Requester, ServiceArea, ServiceGroup, DepHead, Recgroup, RecOwner, Entrydate, updatedate) 
			
			VALUES ('$BPTD_Status', '$BPTD_Classification', '$BPTD_ProcureCat', '$BPTD_Product', '$BPTD_Project', '$BPTD_DSCategory', '$BPTD_Calculated', '$BPTD_CapacityType', '$BPTD_Amount',
			'$BPTD_Jul', '$BPTD_Aug', '$BPTD_Sep', '$BPTD_Oct', '$BPTD_Nov', '$BPTD_Dec', '$BPTD_Jan', '$BPTD_Feb', '$BPTD_Mar', '$BPTD_Apr','$BPTD_May', '$BPTD_Jun','$BPTD_Location',
			'$BPTD_Env','$BPTD_Requester', '$BPTD_ServiceArea', '$BPTD_ServiceGroup','$BPTD_DepHead', '$BPTD_Recgroup','$BPTD_RecOwner','$BPTD_Entrydate','$BPTD_updatedate')");
			
			if($sql)
			{
			echo 'Data Uploaded Successfully';
			
			}
		}
	}
  
?>

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <title>BPT Demand CSV</title>
  <link rel="stylesheet" type="text/css" href="file:///C|/local/htdocs/style/style.css" />
  <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
</head>
<body>
  <div id="mainWrapper">

    <form method="post" action="https://localhost/Storage/DemandCSV.php" enctype="multipart/form-data">
        <input type="file" name="file" />
        <br />
        <input type="submit" name="submit" value="Submit" />
    </form>
    
  </div><!--end mainWrapper-->
</body>
</html>

Similar Working code (good)

<?php
  $conn = mysql_connect("Localhost","root","password") or die (mysql_error());
  mysql_select_db("ds_storage",$conn);
  
	if(isset($_POST['submit']))
	{
		$file = $_FILES['file']['tmp_name'];
		  
		  $handle = fopen($file, "r");
		
		while(($fileop = fgetcsv($handle,1000,",")) !==FALSE)
		{
			
			$PC_Num = $fileop[0];
			$PC_Name = $fileop[1];
			$PC_BPTNUM = $fileop[2];
			$PC_busclass = $fileop[3];
			$PC_Note = $fileop[4];
			$PC_Acro = $fileop[5];
			$PC_type = $fileop[6];
						
			///echo $fileop[1];
			$sql = mysql_query("INSERT INTO inv_names (PC_Num, PC_Name, PC_BPTNUM, PC_busclass, PC_Note, PC_Acro, PC_type) 
			VALUES ('$PC_Num', '$PC_Name', '$PC_BPTNUM', '$PC_busclass', '$PC_Note', '$PC_Acro', '$PC_type')");
			
			if($sql)
			{
			echo 'Data Uploaded Successfully';
			
			}
		}
	}
  
?>

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <title>Upload CSV</title>
  <link rel="stylesheet" type="text/css" href="file:///C|/local/htdocs/style/style.css" />
  <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
</head>
<body>
  <div id="mainWrapper">

    <form method="post" action="https://localhost/Storage/Storage_CSV.php" enctype="multipart/form-data">
        <input type="file" name="file" />
        <br />
        <input type="submit" name="submit" value="Submit" />
    </form>
    
  </div><!--end mainWrapper-->
</body>
</html>

Please help and thx in advance ~J