PHP - Many To Many Or Single Table

How to pull just I record of a column out of the 20 columns? This is not showing the results.

$SomeVar = 'pets';
$query =  "SELECT field1 FROM db1 WHERE id1 = '".$SomeVar."'";
$results=mysql_query($link);

echo $link;

Hi,

I'm trying to delete a string that's single quoted. From: Cyto's to Cyto, but doesn't work. It works when I add 's to the string with stripslashes, but I can't seem to delete a quote from a string.
Does someone know how?

My $_post code:
Code: [Select]
$name=mysql_real_escape_string(stripslashes($_POST["ename"]));
Cheers

how do I call only a single column in a MySQL?

This is not working.
$SomeVar = $_POST['finco'];
$query = "SELECT * FROM idb WHERE name = '".$SomeVar."'";
$results = mysql_query($query);
$psend = $results["fincos"];
echo($psend);

I was talking to some friends, who are just as new as me in programming, and they think it would be better to use a single navigation file for every link in a web site.

Something like this:

Code: [Select]
<a href="nav.php?id=home&otherparams" >Home</a>
<a href="nav.php?id=products&otherparams" >Products</a>
<a href="nav.php?id=contact&otherparams" >Contact</a>
I told them I think this might be easier to maintain, but also might take up on loading time, as the site viewer will have to go through an extra node to get where he wants.
Is this single navigation file a good practice or should it be avoided?

Thanks for any comments...

hello.

I have some oop code that pulls information about a page out of a mysql db but i dont want to put the code on every page. Instead in want to put it in the a function and pass it back to each page.

do i put it in a function in my functions.php file or can i put it into my includes/pages.php includes file ??

the code looks for the page name on the page and then pulls that pages info from the db.
this code works on the page - home.php

Code: [Select]
<?PHP
require_once("../includes/initialize.php");

$currentPages = Pages::find_all();

$pName = "adminHome";

$page_id = "";
$visible = "";
$pageZones = "";
$pageCRUD = "";
$pageTypes = "";
$module = "";
$title = "";
$sub_title = "";
$description = "";
$image = "";
$about = "";


foreach($currentPages as $currentPage){

$page_id = $currentPage->id;
$pageName = $currentPage->pageName;
$visible = $currentPage->visible;
$pageZone = $currentPage->pageZones_id;
$pageCRUD = $currentPage->pageCRUD_id;
$pageType = $currentPage->pageTypes_id;
$module = $currentPage->module_id;
$title = $currentPage->title;
$sub_title = $currentPage->sub_title;
$description = $currentPage->description;
$image = $currentPage->image;
$about = $currentPage->about;



if($pageName == $pName){

echo $pageName.'<br/>';
echo $page_id.'<br/>';
echo $visible.'<br/>';
echo $pageZone.'<br/>';
echo $pageCRUD.'<br/>';
echo $pageType.'<br/>';
echo $module.'<br/>';
echo $title.'<br/>';
echo $sub_title.'<br/>';
echo $description.'<br/>';
echo $image.'<br/>';
echo $about.'<br/>';
}
}
?>

i would like to be able to just put global $page or something like that to get all the db info for each page.


i tried this in my  includes/pages.php includes file but it cant get the page name.

Code: [Select]
public static function find_by_pageName(){
global $database;
global $pName;

$sql = "SELECT * FROM ".self::$table_name." WHERE pageName=".$pName."";
$result_array = self::find_by_sql($sql);
return !empty($result_array) ? array_shift($result_array) : false;
}



any suggestions ???? whats the best way to do this ?

thanks
ricky

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=358810.0

==> MySQL version    5.0.91-community

So once upon a time I was working on a CMS.
I worked on it for 3 months, had to wipe my computer - but didn't worry about it because I backed up the files on a flash drive... which got smushed by some boxes when I moved <.< awesome -.-
Anyway, a year later (ie: today), I've decided to start again from scratch.

For me - for whatever reason - the simplest things always seem to give me the most trouble.

I decided to start with a "user" table - naturally - and began working on the first page: user_view.php and added an include file that connects to the database (connectDB.php). Since I started today, everything is simple - no design elements yet - just good 'ol code.

The View Users Page is simply a page that grabs all the rows from Table: users and prints the information to the screen, as if you were viewing a Members page on a forum.  This Page works fine. No complaints, does everything I need it to, prints all the rows and cols from Table Users.

Then I created the Edit User Page. When I did this a year ago, and I wanted to print out all the data from the table, I used the while loop. When I wanted to only grab certain variables from a table, I just created a new set of variables, as show below. Using the same method from a year ago, I started working on printing various data to the screen (such as "Welcome $username"). 5 minutes of typing... refresh page... nada.
So I stripped away just about every tag but the essentials and it still wouldn't work

Code: [Select]
<?php
...
$userID = 3;
$sql = "SELECT * FROM users WHERE userID='$userID'";
$result = mysql_query($sql);
$rows = mysql_fetch_row($result);

echo $rows['username'];
...
?>
Normally, this would just grab the username from a row in Table users where the userID = 3
But instead - it does nothing. I just see a blank page. It's a simple 5 lines of code and it's like "im just gonna do w.e the fk i wanna do mmmk thxforplaying"

 

PS: Keep in mind there is nothing wrong with the connection to the database, and as already stated I'm able to print ALL values from the Users Table using this same method: Code: [Select]
<?php
...
$user_sql = "SELECT * FROM users ORDER BY username ASC";
$user_result = mysql_query($user_sql);
while ( $user_rows = mysql_fetch_array($user_result) )
...
?>

Hi Guys,

This is what I am trying to do.  I have multiple link one 1 page and when a user clicks on that link it will print that file for them.


Code: [Select]
page.php containts 20+ images

image1 - Print
image2 - Print
image3 - Print
etc....

<a href="page.php?cid=1">Print</a>
<a href="page.php?cid=2">Print</a>
<a href="page.php?cid=3">Print</a>

So what I need to do is if user clicks cid=2 then it goes to page.php?cid=2 shows the image and prints with javascript.

That is not a problem I already to this with html but I am changing over to php mysql due to simplicity and ease of use. and also to reduce to pages from 30+ pages down to 1 page for this section.

so this is what I am having trouble with
Code: [Select]

switch($cid)
case $cid
{
echo image and print
}
default {
echo all images and print link
}
 
So the problem I am having is the case $cid

The problem is that this is so simple and I have been playing with it for so long I don't see the fix.

hey everyone

will you please assist.

I'm getting data from a mysql database.

And I want to assign the data to a single value, if possible

For example, in my database I have 2 columns, name and group

Lets say John, Peter and Cathy belongs to group 555, where Sally and Marcus belongs to group 777.

So my sql query outputs all users in group 555

Is there a way to assign the search result to a vlue, for example $result = ???

and If I said echo $result, it should show the users who belongs to group 555 as an example.

I tried to use row[Name][1]; but it doesnt work.

The thing is, I can display the data the way I am familiar with, but I'm sending an automated email to myself, containing the users. So if I would used a for each statement, the mail will trigger and send a copy for every count, in this case, 3 times. And thats my huge problem.

The mail must trigger only once, containing the users in my search query, in this case, group 555.

Any help will be appreciated

Thank you

I want to use all five results separately in order to use in a Jquery slider.

Code: [Select]
<?php
           $a = "SELECT * FROM blog_posts ORDER BY id DESC LIMIT 5";
   $query = mysql_query($a) or die (mysql_error());
           $query_results = mysql_fetch_array($query);
?>

I know if i was going to grab vars from an normal array i would just use...

Code: [Select]
<?php echo $array_reults['0'] ?>

Can any one help me with this problem?

Hello,

I have a simple multiple-step form and I use sessions to save the data. Now i have 1 single checkbox and i would like to know how i can save that data (if one checked it or not). I am not very advanced with sessions, nor PHP, thus i tried the following:
Code: [Select]
if (isset($_POST['newsletter']))
{
  $_SESSION['newsletter']=$_POST['newsletter'];
}
$newsletter = $_SESSION['newsletter'];

// do not really know what if statement to use
if($newsletter == 'yes')
{
$newsl = '1';
}


//checkbox html here
<input type="checkbox" class="styled" name="newsletter" value="yes" />

Obviously the above won't work. Can explain to me how to save checkbox data in a session?
Thanks a lot in advance.

I can use the first while loop, but there is no data in the second while loop. Is there a better way as I have never done this before...

Code: [Select]
              <?php
                $featured_results = mysql_query("SELECT * FROM products LEFT JOIN product_images ON products.product_id=product_images.product_id WHERE products.product_featured='1' AND products.product_active='1' AND thumb='1'");

$fa=0;
while($featured_row = mysql_fetch_assoc($featured_results))
   {
$fthumb_result = mysql_query("SELECT image_name FROM product_images WHERE product_id='".$featured_row['product_id']."' AND thumb='1'");
$fthumb = mysql_fetch_row($fthumb_result);

if ($fa==0) {
echo "\n<img id=\"home-slider-photo-".$fa."\" class=\"home-slider-photo preload\" src=\"/includes/getimage.php?img=".$fthumb[0]."&w=370&h=370\" alt=\"\" />";
} else {
echo "\n<img id=\"home-slider-photo-".$fa."\" class=\"home-slider-photo preload home-slider-photo-unsel\" src=\"/includes/getimage.php?img=".$fthumb[0]."&w=370&h=370\" alt=\"\" />";
}
$fa++;
}

echo "<div id=\"home-slider-photo-price\">";
$fb=0;
while($featured_row2 = mysql_fetch_assoc($featured_results))
   {
if ($fb==0) {
echo "\n<div id=\"home-slider-photo-price-".$fb."\" class=\"home-slider-photo-price\">\n<span>only</span>$".$featured_row2['product_price']."\n</div>";
} else {
echo "\n<div id=\"home-slider-photo-price-".$fb."\" class=\"home-slider-photo-price home-slider-photo-price-unsel\">\n<span>only</span>$".$featured_row2['product_price']."\n</div>";
}
$fb++;
}
echo "</div>";
?>

I am having a problem applying pagination to my page when I only have one record displayed.  I would like to have it set up to where one record is followed by the next one in the list.  I have tried several ways but they are for whole tables moving to the next page.  I think I am missing something small but not sure.  Any help will be greatly appreciated, thanks.

Could somebody please point me in the right direction....

I want to block the US, AUS, NZ, CAN, IRE from the index.php of my site. But not the rest of the site.

The following site (like many others) provides a pretty neat list for the htaccess http://www.ipinfodb.com/ip_country_block.php

I did a test. I got the list for blocking the UK. After copying the UK list to my htaccess i couldn't view my site.

The thing i don't get is... my ip address was not in the list but i was still blocked,

The 1st 2 sets from my ip are '2.100'

The only ip's in the list starting with 2 a
deny from 2.24.0.0/13
deny from 2.96.0.0/13
deny from 2.120.0.0/12
deny from 2.136.0.0/13

How exactly is this all working? And what's the best way of blocking the above countries from just my index.php?

Any links to manuals or anything here would be great...


Thank You.

John

Greetings,

I'm trying to execute a shell command with a user-supplied password as input.  The password may contain apostrophes and and virtually any other character.  Unfortunately, when using escapeshellarg(), the password argument is interpreted as two separate arguments, as escapeshellarg() will handle apostrophes (single quotes) by breaking out of the already quoted text and using a backslash escape.


$password = escapeshellarg("ex'ample!%");  // The password will actually be supplied by an HTML form.

$command = ('echo '.$password);

echo "$command";

// Returns 'ex'\''ample!%'


Does anyone have any input on how to accomplish what I'm trying to do?  I'd like to allow obscure passwords without disallowing specific characters, while still being "safe" in passing the information to a shell command.  Double quotes would work for passing single quotes, but I'm afraid I might break other characters there.

Thanks.