PHP - Fetching All Rows For Specific Field

Hi All,

Please can someone help me with this bit of code. I have a mysql database with a table called 'events'. I have six fields namely 'ID, mxitID, type, message, ts, publish'.
I am trying to update the field 'publish' from Yes --> No or if it is already No then back to Yes again. I have two files then main one beacon.php and publish.php
Here is the code:

beacon.php
Code: [Select]
<?php
        // connect to the database
        include('connect-db.php');

        // display data in table
//        echo "<p><b>View All</b> | <a href='view-paginated.php?page=1'>View by Page</a></p>";
//   echo "Select your Carousel: ";
   
   // get results from database
        $result = mysql_query("SELECT * FROM events WHERE type='beacon'")
                or die(mysql_error());

        echo "<table border='1' cellpadding='10'>";
   echo "<a href='index.php'>b Back</a><br><br>";
        echo "<tr> <th>ID</th> <th>mxitID</th> <th>Type</th> <th>Message</th> <th>Timestamp</th> <th>Published</th> <th>Modify</th></tr>";

        // loop through results of database query, displaying them in the table
        while($row = mysql_fetch_array( $result )) {
                
                // echo out the contents of each row into a table
                echo "<tr>";
                echo '<td>' . $row['ID'] . '</td>';
                echo '<td>' . $row['mxitID'] . '</td>';
                echo '<td>' . $row['type'] . '</td>';
      echo '<td>' . $row['message'] . '</td>';
      echo '<td>' . $row['ts'] . '</td>';
      echo '<td>' . $row['publish'] . '</td>';
                echo '<td><a href="publish.php?id=' . $row['ID'] . '"><input name="update" type="submit" id="update" value="Update"></a></td>';
                echo "</tr>"; 
        } 
        // close table>
        echo "</table>";
?>

publish.php
<?php

 // connect to the database
 include('connect-db.php');

 // get id value
 $id = $_GET['id'];
echo "$id";

 $sql="SELECT * FROM events WHERE type='beacon'";
$result=mysql_query($sql);


$active=($result['publish']=='')?'Yes':'No';
echo "$active";

if ($active='Yes') {
    $active='No';
 } else {
    $active='Yes';
}
$sql = "UPDATE events SET publish='$active' WHERE ID='$id'";
$result = mysql_query($sql);

// header("Location: beacon.php");
?>

I cant seem to change the value...any help would be much appreciated. Thank you in advance.

MOD EDIT: code tags added.

Hello, i am trying to get my form to list usernames ascending as an option, but the select field just returns blank.

Here is my code:

Code: [Select]
/**
 * editUserForm - Displays the users database table in
 * a nicely formatted field table.
 */

function editUserForm(){
   $q = "SELECT * "
       ."FROM ".TBL_USERS." ORDER BY username ASC";
   $result = $database->query($q);

while ($row = mysql_fetch_assoc($result))
{
echo '<option value="'.$row["username"].'">'.$row["username"].'</option>';
}
}

Code: [Select]
              <form action="/" method="post">

                <div class="column">
                  <p>
                    <select name="user" id="user" placeholder="Select A User To Edit" class="{validate:{required:true}}">
                      <option>Select A User To Edit</option>
                      <? editUserForm(); ?>
                    </select>
                  </p>

                <div class="action_bar">
                  <input type="submit" class="button blue" value="Submit Post" />
                  <a href="#modal" class="modal button">Cancel</a>
                </div>

              </form>

All help is appreciated

Hello!

I been trying to figure how first read a Google docs CSV (live) to be shown as a custom HTML.

The CSV have 50 lines and each line have 15 cells.

With a bit searching i figure out to this :

Code: [Select]

<?PHP

$file_handle = fopen("https://docs.google.com/spreadsheet/pub?key=0Aus5xZRHSuhydGpmcXBRN0Z2WXM5Sks3TlgydF92R1E&single=true&gid=3&output=csv", "r");

while (!feof($file_handle) ) {

$line_of_text = fgetcsv($file_handle, 1024);

print "<custom code>" . $line_of_text[0] . $line_of_text[1]. $line_of_text[2] . $line_of_text[3] . $line_of_text[4] . $line_of_text[5] . $line_of_text[6] . $line_of_text[7] . $line_of_text[8] . $line_of_text[9] .$line_of_text[10] . $line_of_text[11] . $line_of_text[12] . $line_of_text[13] . $line_of_text[14] . $line_of_text[15] . "<br>";
}

fclose($file_handle);

?>


But what i would need is to view only the row that have the value "(T01S)" in the first cell "A2" or first "$line_of_text[0]" and the header (first line).

I was thinking about just to show a "desired_line" would not help me as if i add a line in the middle many pages would show the wrong line.

Also is it any easy way to show one full line except the first cell? So i can have a custom code on that field? And also so i do not need every pages code if i add more fields?

After many hours of searching i would be very happy for any kind of help!

Im trying to write some code for a raffle, when someone buys one ticket it works well but if someone buys ten tickets. i would like it to put each one on a new row, the last column is the ticket number which is got by another table called count and i want the new count in the last column of each row.

In the actual script there is more than two columns but this is an example just to try to let you know what im trying to do.

As you can see i want the ticket number to increment by one every time someone buys tickets. (the ticket number is in a simple table with just id and ticket number)

EXAMPLE someone buys 2 tickes

name | ticket number

John | 1

john | 2

then someone buys three tickets

jane | 3

jane | 4

jane | 5

This is what i have. (WORKING EXAMPLE of the code tha doesnt work.) as you can see the ticker number stays the same and not increment by one.

<?php
$num //is a number between 1 and 10 
$tr //is the current count got from database (this needs to count up by one every entry) 
include 'includes/connect.php'; 
$num = "3"; // number of tickets someone buys. 
$count = "5"; // count of tickets already sold (so this is start count for this transaction). 
$id = "1"; // this is the line the counter is on to keep count updated for the amount of tickets sold. 
$name = 'john'; //example name 

for($i=0;$i< $num;$i++){ 
                        $count="$count+1"; // increments count by 1 
                        $sql123 = "UPDATE count SET count=$count WHERE id='$id'"; //should update database to new count 
                        
                        $sql = "INSERT INTO test (name, number) VALUES ('$name', '$count')"; 
                        if($result = mysqli_query($con, $sql)){ 
                        echo "<br>tickets bought and entered into database,<br>Thank you<br>"; 
                        } else { 
                        echo "Error: " . $sql . "<br>" . $con->error;
  } 
  }
?>

Not sure what im doing wrong?

Thank you in advance

Nook6

I use the Wholesale Suite Premium Prices plugin with WooCommerce. I have 6 specific wholesale roles out of 15 that I wish to hide two specific shipping methods from being selected for the 6 exceptions. I'm just trying this on my staging server at this time using a code snippet example that I found and modified for my specific conditions. Would the following work for this purpose?

/* Hide specific shipping methods for specific wholesale roles */
add_filter( 'woocommerce_package_rates', function( $shipping_rates ) {
// User role and shipping method ID to hide for the user role
    $role_shipping_method_arr = array(
    'ws_silvia_silver' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_pst_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_tax_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_silver' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_pst_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_tax_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_gold' =>    array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_pst_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_tax_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_gold' =>    array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_pst_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_tax_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    );

    // Getting the current user role
    $curr_user = wp_get_current_user(); 
    $curr_user_data = get_userdata($current_user->ID); 

    // Wholesale Suite Roles 
    if (isset($current_user) && class_exists('WWP_Wholesale_Roles')) {
        $wwp_wholesale_roles = WWP_Wholesale_Roles::getInstance();
        $wwp_wholesale_role = $wwp_wholesale_roles->getUserWholesaleRole(); 

// Loop through the user role and shipping method pair
    foreach( $role_shipping_method_arr as $role => $shipping_methods_to_hide ) {

// Check if defined role exist in current user role or not
    if( in_array( $role, $current_user->roles) ) {

// Loop through all the shipping rates
    foreach( $shipping_rates as $shipping_method_key => $shipping_method ) {
$shipping_id = $shipping_method->get_id();

// Unset the shipping method if found
    if( in_array( $shipping_id, $shipping_methods_to_hide) ) {
unset($shipping_rates[$shipping_method_key]);
}
}
}
}
}
    return $shipping_rates;
});

Any insights as to how to accomplish this would be greatly appreciated. Lyse

hello guys

i heard there is a way that you can make something like a database on a text editor and when ever u want to change the info you just open a text editor and change the information


How is this called? where can i find a tutorial? any tips? thanks you very much 

Hi ,

i am working on a PHP code that would fetch me the" title and the description" from another web page something similar to www.Digg.com .After searching a couple of Open source codes developed by some generous coder I found this piece of code:

I have tested this code and it works fine, but the confusion here is it only works from external internet and Iam not able to extract the contents when i use the same piece of code from my office intranet(Our intranet has full access to the internet ) and the best part is when i use the same url for fetching content from Digg.com from my office intranet it works fine.

The error I get is file_get_contents time out after 60 seconds
OR
I get a blank page result without any content

But the same piece of code when used outside of my intranet works perfectly fine.

Please let me know if you find anything incorrect!

Thanks

Code: [Select]
<?php

if(isset($_POST['submitlink'])) 
{
function getMetaTitle($content){
  $pattern = "|<[\s]*title[\s]*>([^<]+)<[\s]*/[\s]*title[\s]*>|Ui";
  if(preg_match($pattern, $content, $match))
return $match[1];
  else
return false;
}

$url = $_POST['submitlink'];

$data = array();

// get url title
$content = @file_get_contents($url);
$data['title'] = getMetaTitle($content);

// get url description from meta tag
$tags = @get_meta_tags($url);
$data['description'] = $tags['description'];

$dom = new domDocument;

@$dom->loadHTML($content);

$dom->preserveWhiteSpace = false;

$images = $dom->getElementsByTagName('img');

foreach($images as $img)
{
$imgurl = $img->getAttribute('src');       
$alt = $img->getAttribute('alt');
//$size = getimagesize($imgurl);
//echo "Title: $alt<br>";
//echo $imgurl;
//echo '<img src="'.$imgurl.'"  title="'.$alt.'" width="50px"/>';


}

$formdata .= '<table><tr><td>Title:</td><td><a href=';
$formdata .= 'gethome.php?url=';
$formdata .= $url;
$formdata .= '>';
$formdata .= json_encode($data['title']);
$formdata .= '</a></td></tr>';
$formdata .= '<tr><td>Description:</td><td> ';
$formdata .= json_encode($data['description']);
$formdata .= '</td></tr></table>';
}

Hi,
I was wondering if any one can help me out with this little issue. I select some data, and put it on a while loop, so something like while($row = mysql_fetch_array($result)){ body }
but at the very last element in the array I'd like to something a little different than else.

So, i have 4 elements. For the first 3 I'd like to print element1, element2, element 3, element4
Notice the missing comma at element4

what Im basically trying to do is just like a phpmyadmin function... you select rows you want to update with a checkbox and then it takes you to a page where the rows that are clicked are shown in forms so that you can view and edit info in them... and then have 1 submit button to update them all at once.

Hello,

I'm using pbb forum

http://xemix.pl/


When I tried to get topics using rss feeds module, I got this error.

Code: [Select]
Fatal error: Uncaught exception 'Exception' with message 'Erroe occured while loading url by cURL.
Couldn't resolve host 'pbboard.com'' in /home/a5402323/public_html/includes/FeedParser.php:226
Stack trace:
#0 /home/a5402323/public_html/includes/FeedParser.php(157): FeedParser->getUrlContent()
#1 /home/a5402323/public_html/modules/admin/feeder.module.php(218): FeedParser->parse('http://absba.or...')
#2 /home/a5402323/public_html/modules/admin/feeder.module.php(49): PowerBBFeederMOD->_AddFeedStart()
#3 /home/a5402323/public_html/admin.php(89): PowerBBFeederMOD->run()
#4 {main} thrown in /home/a5402323/public_html/includes/FeedParser.php on line 226
the host said thet

Hello,cURL is installed by default here Many Thanks,Helpdesk Staff


any help !!!!

Hello, iam almost done with my project .. except there is one more thing left which somehow i cant manage to figure it out....... i manged to make a proxy array which rotates proxies randomly on every try..... but i want for my users to be able to add them manually via the textarea... so they put their proxies and
as much as they want...... so then i guess explode should be used to fetch the proxies that were added by the user from the textarea and put them in an array like u see down and then with the curl array_rand it randomises them on evry try The real problem is i dnt know how to indetidy the explode cause iam not adding them manually they will be added via textare by users....... so when they add the ips they need to be fetched from the textare.
THNX IN ADVACE

$proxies = array(  
    '000.000.000.00:000',   <----------------- should i keep this ? cause ips will be added from textarea by users ?
    '000.000.000.00:000',  
    '000.000.000.00:000',  
    '000.000.000.00:000',  

);  
curl_setopt($ch, CURLOPT_PROXY,$proxies[array_rand($proxies)]);  <----- AFTER and array is made using exploit this will call it :)

<textarea cols='22' class='area' rows='14' name='proxies'>PROXIES</textarea><br><input type='submit' value='Test'><br></p><p align='center' dir='ltr'><b>  

Edited by madmike3, 20 August 2014 - 05:29 AM.

my current code for getting a page is
<?php 
$page = $_GET['page'];  //Gets the (page=) from the URL
   if($page){  
   $site = file_exists($page.'.html') ? $page.'.html' : 'home.html';}
   else{
   $site = 'home.html'; // Else include the default home.php file.       
   }
   include($site);
?>

the problem with it is it only checks for html pages.
I would like to have it check for html then php pages and it pull up whichever is valid.

i tried to do it myself but im a php n00b. pls help
         <?php 
$page = $_GET['page'];  //Gets the (page=) from the URL
   if($page){  
   $site = file_exists($page.'.html') ? $page.'.html' : 'home.html';}
   elseif
   $site = file_exists($page.'.php') ? $page.'.php' : 'home.html';
else{$site = 'home.html'; // Else include the default home.php file.       
   }
   include($site);
?>

^^ is what i did. any help will be appreciated. Thanks

Hello
I have the following code
Code: [Select]
<?php


// STORE DATABASE VARIABLES
$hostname_cnConnection = "localhost";
$database_cnConnection = "tekou";
$username_cnConnection = "root";
$password_cnConnection = "1234";
$cnConnection = mysql_pconnect($hostname_cnConnection, $username_cnConnection, $password_cnConnection);
mysql_set_charset('utf8',$cnConnection);
// CONNECT TO DATABASE
mysql_select_db($database_cnConnection, $cnConnection);


$data = mysql_query("SELECT * from jos_users") 
 
 or die(mysql_error()); 
// Print "<table border cellpadding=3>"; 
 while($info = mysql_fetch_array( $data )) 
 { 
 // echo $info['id'];
  $prod_id=$info['id'] ;
//  echo "Product ID " .$prod_id; //Show Product Id
  
mysql_query("UPDATE jos_vm_user_info SET first_name = '".$info['name']." WHERE user_id = ".$info['id']) or die(mysql_error());  


  }
echo $info['id'];
 
?>

I want to read every $name and update in jos_vm_user_info the first_name but I think I have error in code because nothing happens.
I quess that .$info['id'] doesnt return a single number but all numbers but I dont know how to fix it.
Please someone to help me.

I'm trying to do a following feed. This feed includes posts and comments that the user is following. The first 3 following types are in the content table and the last following type is in the comments table.   This query fetches the first 3 following types successfully.

$construct = $connectdb->prepare("SELECT parent.*
FROM `content` as parent
JOIN followers ftable on (
(ftable.parent_id=parent.sid AND ftable.userposts='1')
OR
(ftable.`parent_id`=parent.pageid AND ftable.topic='1')
OR
(ftable.parent_id=parent.pageid AND ftable.page='1')
) AND ftable.userid=:userid
WHERE parent.deleted='0'
GROUP BY parent.id
ORDER BY parent.posted DESC");

This query fetches the following comments type successfully

$construct = $connectdb->prepare("SELECT parent.*
FROM `comments` as parent
JOIN followers ftable on ftable.parent_id=parent.postid AND ftable.comments='1' AND ftable.userid=:userid
WHERE parent.deleted='0'
ORDER BY parent.posted DESC");

How do i combine the two queries? In this feed i want the results to be ORDER by posted DESC.

Hi guys,
I am using a search form that's supposed to pull data out of database and display them. I managed to to do that using the following:

while($rows = mysql_fetch_assoc($result))
{

echo "-Title: " . $rows['title'] . "<br/>" . "-Author: " . $rows['author'] . "<br />";

Displays something like this:
-Title: Young One
-Author: Edwards Bonnie.
----------------------------------

I have links related to each book in a folder and I want to make the title clickable and each title should take me to the corresponding book page.

I know that I have to do something like <a href=\"...........\">$rows['title']</a>", but as far as I know all titles will take me to one page using that! please help and thank you.