PHP - Passing To $_get (beginner Question)

My table has 250 rows, but COUNT only seems to see 162 of them.  In phpMyAdmin, for instance, there is a notice in the browse tab: "Showing rows 0-161 (162 total, Query took 0.0030 sec)".  On one of my php pages, I get the same 162 result from this attempt to count the number of entries to my auto-incrementing "id" column :

$result = mysql_query('SELECT COUNT(id) AS id_count FROM MyTable)';

Can anyone suggest the kinds of things I should check/adjust to understand why about 90 rows are not being counted?  Many thanks in advance for any help anyone can offer.

Ok I am testing foreach in an array as my practice. I wonder how can I assign values in the key of the array..

Here's the code


Code: [Select]
<?php


                $username = me_mysql_prep(trim($_POST['username']));
$first_name = me_mysql_prep(trim($_POST['first_name']));
$last_name = me_mysql_prep($_POST['last_name']);
$email = me_mysql_prep($_POST['email']);
$position = me_mysql_prep($_POST['Position']);
$password = me_mysql_prep($_POST['password']);
$hashed_password = sha1($password);



$required_fields = array($username,$first_name,$last_name, $email, $position, $password);



foreach($required as $key => $value)
{
if($value == "")
{
echo $key . " Cannot be empty<br>";
}

}


?>

So the result would be like this...

IF username, first name and last name are EMPTY it will echo:

Quote

username cannot be empty
first name cannot be empty
last name cannot be empty



Anyone?

Hello dear friends, hello community,

i want to parse a site http://www.aktive-buergerschaft.de/buergerstiftungsfinder

Well therefore i have a true beginner-question regarding Array in order to work with the data: beginner question

The results should be stored in a MySQL-Database: well you see. i have a Curl-Approach: and i want to work with the parsed data: and in this case i want to give over the data into an array (if viewing the output in web browser, do view-source to see structured array).

Here the musings that led to the code:

Depending on num dimensions, we could do, foreach($result as $k => $v) {echo $k." ".$v}
to view and work with data (adding sub foreach loops accordingly; i.e. if $v is itself an array)

see the results: What do you think:

Code: [Select]
$ch = curl_init("http://www.aktive-buergerschaft.de/buergerstiftungsfinder");
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); 
$buffer = curl_exec($ch);
curl_close($ch);
$result = explode(",", $buffer);
foreach($result as $k => $v) {echo $k." ".$v}
if $v is itself an array)
   // print_r($result);


look forward to hear  from you!!

db1

A few months ago, and a good amount of time before that, I had people telling me to use isset() instead of performing to see if the variable is empty, such as: !$_GET['']

I know the differences in the function and what they do, but when could isset() be used in a situation where it's better/more efficient then: !$_GET['']

I do use isset(), though.

Hi there,

I've just started learning php and mysql today. I'm putting things together in dreamweaver and everything is running smoothly (ish).

I've got a form written in php that sends data to a database. All fine.

I need to send the time of submission to the database. I've put in a hidden field, what code should I use to set the field value to a mysql field of type DATETIME?

Cheers.

I think this is a simple question, but I'm just starting out and can't figure out how to do this exactly.

I'm making a demo site for a flower shop. The structure is as such (only listing the particular files in question - once this is done, the rest will be easy)

index.php -> inc_show_colors.php -> showColors.php

The index is to be standard through the site, loading include files into a main content area.  Clicking on a link loads inc_by_color.php (index.php -> index.php?page=by_color )

From there, one of the four colors is selected.

showColors.php contains switch statements for each color. I want to load showColors.php into the main content window when a color is selected, and I need to have it work for all four colors. I'm not sure how to do this, as you can't pass a variable to an include from what I understand.

What's the easiest way to go about this? Keep in mind this is an intro class and "best practices" are not necessary yet, just the simplest solution to get it working.

 I want each of these colors to link to another include file, which will load in its place in index.php.


index.php:
Code: [Select]
<div id="maincontent">
<?php
if (isset($_GET['page'])) {
switch ($_GET['page']) {
case 'by_color':
include('includes/inc_by_color.php');
break;
case 'by_type':
include('includes/inc_by_type.php');
break;
case 'by_occasion':
include('includes/inc_by_occasion.php');
break;
case 'view_cart':
include('includes/inc_view_cart.php');
break;
case 'payment_options':
include('includes/inc_payment_options.php');
break;

case 'home_page':
default:
include('includes/inc_home.php');
break;
}
}
else 
include('includes/inc_home.php');

?>
</div>

inc_by_color.php:
The first link I tried doing in the way I thought would work, but it doesn't. It can't find the include file.
The second one works, kind of - but it just loads the page by itself, not into the maincontent div in index.php.
Code: [Select]
<h1>Flowers Categorized by Color</h1>
<div class="picdivcontainer">
<div class="picdiv"><a href="index.php?page=red"><img src="images/image.png" width="90" height="90" alt="Red Flowers" />
  <p>Red</a></p></div>
<div class="picdiv"><a href="showColors.php?color=white"><img src="images/image.png" width="90" height="90" alt="White Flowers" /></a>
  <p><a href="showColors.php?color=white">White</a></p></div>
</div>

and showColors.php:
Code: [Select]
if (isset($_GET['color'])) {
switch ($_GET['color']) {
case 'red':
$result = mysql_query("SELECT * FROM flowers WHERE color='red'") or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
// Set and trim strings and show the resulting flowers from query
$flowername = $row['name'];
$flowerimage = $row['image'];
$image_path = "images/";
$flowername = str_replace('_', ' ', $flowername);
$flowername = ucwords($flowername);
?> <div class="picdiv"><p><?php echo $flowername."<br />";
$flowerimage = str_replace(' ', '_', $flowerimage);
echo "<img src='images/" . $row['image'] . "' />";
?></p></div> <?php
} 
break;
I realize that showColors.php is probably a really messy way of doing this, but I just need to get it functioning ASAP for now.

Code: [Select]
<?php 
$parentesco .=' 

<ul><li><a href="children.php?category_id='.$idc.'&name= '. $name2 . '">'. $name. ' </a></li></ul>'; ?>
in the url string $idc is passing but $name2 is not. $name2 is pickup from a query, I echo that value everywhere in the code and it echo its value but is not passing so how.

Help

I have a link (http://site.com/user/redirect). This link directs me to "site.com/user.php?level=site.com/123.php?hp=1"

How can I echo just "site.com/123.php?hp=1"?

I know how to use $_GET but I don't know how I can apply it to this.

I am seen people have dynamic pages that loads the information from a database and then displays that information from the url. EG domain.com/somedirectory/something I have a website that does this but uses domain.com/something.php?id=something . This works great but when I go to try and get the statistics for that page from facebook for number of people that have liked that page.

When I go to: http://graph.facebook.com/http://likebook.cz.cc/ It shows me the information:
Code: [Select]
{
   "id": "**************",
   "name": "LikeBook",
   "picture": "http://profile.ak.fbcdn.net/hprofile-ak-snc4/hs178.ash2/41817_130259343675613_3465_s.jpg",
   "link": "http://www.facebook.com/pages/LikeBook/130259343675613",
   "category": "Website",
   "description": "Collect every like at LikeBook.cz.cc",
   "fan_count": 3
}
But when I try and go to: http://graph.facebook.com/http://likebook.cz.cc/like.php?id=31 It shows me:

Code: [Select]
{
   "id": "http://likebook.cz.cc/like.php"
}
So what I need to do is. Make a dynamic page within that sub directory.

So that http://likebook.cz.cc/like/31 does grabs the information from line 31 of my database, like http://likebook.cz.cc/like.php?id=31 would do.

Thank you
~AJ

hi all   new to webforum and php, how can I enter $_get['id] as I know this id...my code snippet is below   $sql = "SELECT x,y,z  from tablename WHERE Id='" . $_GET["id"] . "'";   It works fine as it is getting the variable from a another webpage, but I know an id and want to enter it manually just to check a different webpage , thanks in advance....singhy   Please give example if the known id=xyztest

I cannot seem to get my link to work.. I want to build a php script that has more than one $_GET command.. The link I want to make is: index.php?section=tutorial&viewing=18-classes_or_ids.
Here is my PHP code..

<?php
$section = $_GET['section'];
switch ($section)
{
case "home":
include("home.html");
break;
case "register":
include("register.html");
break;
case "tutorial_home":
include("tutorial.html");
break;
default:
include("home.html");
}
$tutorial = "?section=" .  urlencode('tutorial&viewing') . $_GET['tutorial&viewing'];
switch ($tutorial)
{
case "18-classes_or_ids":
include("classesorids.html");
break;
}
?>

Please help me!!

I never really thought about it before, but recently I visited a site with a url like:

www.example.com/?OR

Which made me wonder how you would go about getting that keyname since it is without a value. Any ideas?

I am a new programmer. I am working on a personal project for my portfolio, it is a simple blog.
I am trying to give the user the ability to delete a blog entry. It works fine, the problem is that
when you refresh the page, with out clicking 'delete' the entry is still deleted. $_GET is passing
the $id to my function and it is executing. The code I have posted is my effort to fix the problem.

How can I connect $_GET to the delete button ? I have tried using a hidden value but this is not working.

Any help would be greatly appreciated.
AL


Code: [Select]
// code to display message before deletion
if($_GET['T'])
{
echo("<div style='float:right; width:25%; height:100px; position:absolute; top:150px; right:15%;'>");
echo("<h2>Are you sure you want to delete:<h2>");
echo $_GET['T'];
echo("<form method='get' action='?'>");
echo("<input type='submit' name='button' value='Delete'>");
echo("<input type='hidden' name='submit_check' value='1'>");
echo("</form>");

echo("<form action='http://nuke.industry.com/Blogspiracy/UserPage/index.php'>");
echo("<input type='submit' value='Cancel'/>");
echo("</form>");
echo("</div>");
}

// code to delete a selected blog entry
function delete_blog($id)
{
global $dbh;
$sql = "DELETE FROM tblBlog WHERE tblBlog.id = '$id' LIMIT 1;";
$sth = $dbh->prepare($sql);
$sth-> execute();
return;
}

if (isset($_GET['id']) && ($_GET['submit_check']))  how do I "GET" the hidden value?
{
$remove = delete_blog($_GET['id']);

}

[code]
 

how do i get the id from the url so i can use it

I am really confused about how people use $_GET to give a page a link

so far what I understand is that $_GET grabs the information from a link

So if my link was http://localhost/stargate/users/profile.php?goauld=Sam

how do I turn this into viewing Sams profile soon as i type in that link with out having to hit a search button first

would really appreciate if someone help me understand this please cause it appears i really need to know how to do this.


Code: [Select]
<?php

if(isset($_POST['search'])) {

// searches goaulds then displays them

$search3 = "SELECT goauld,id FROM users WHERE goauld='".mysql_real_escape_string($_POST['goaulds'])."'"; 

$search2 = mysql_query($search3) or die(mysql_error());

WHILE($search1 = mysql_fetch_array($search2)){ 

$grab_goauld = $search1['goauld'];


echo '<table width="300" height="5" border="1" align="center">';  

echo '<th><center>Goauld Statistics</center></th>';     

echo "<tr><td height='340'>$grab_goauld</td></tr>";       

}

}   


echo '</table>';  ?>