PHP - Fetch From The Server(mysql) And Then Dump Online Through A Php Page

I've been looking for a simple script that would connect to a game server to see if it is still online. I've found many, but not one of them work. They will permanently send back the text "Online", or "Offline". This is the simplest code I have found:


<?php
$ip = "66.79.190.40"; 
$port = "27960"; 
if (! $sock = @fsockopen($ip, $port, $num, $error, 5)) 
echo '<B><FONT COLOR=red>Offline</b></FONT>'; 
else{ 
echo '<B><FONT COLOR=lime>Online</b></FONT>'; 
fclose($sock); 
} 
?>

I'm also looking into getting it to pull the map name and player-list, but I should be able to figure that out on my own once I get this working. If it helps, this script is supposed to connect to the original Quake games(One, two, and three).

This isn't exactly an application design question, but rather a system design one.   I am about to install an Inventory Control System inside this store I work in.   The store itself also owns a Linode VPS running Centos 6.4 which hosts our website.   This new Inventory System will come built in with a Microsoft SQL Server, and supposedly it is a SQL Anywhere database, but I'm not too sure what that means.     I need to make this database publicly accessible, but only via the Linode VPS.  Surely, setting restrictions is easy enough to address that issue.  That isn't my question.   My first idea is to put this server into the DMZ, easy.  But it doesn't exactly sound safe.  So my next idea was to put a middleman server in the DMZ, this way the Linode can send queries to that middleman server and it will send that data to the SQL Server and back.  This is very vaguely described I know, but I don't want to get too much into details, but rather, understand how I can create that middleman server, and what could Install onto it that would allow me to securely process queries?   My first thought was to install a webservice, that accepts an XML/JSON request and returns an XML/JSON response. Then, I realized directly afterwards that I don't have any experience setting up a webservice like that. What kind of options are there out there?
  Ultimately, my question is, should I just put the Server in the DMZ or should I create the middleman, and if so, can someone point me in the right direction as to getting a webservice set up?
Edited by Zane, 15 July 2014 - 11:28 PM.

Hi,

I'm wondering if theres a shortcut to a potential problem I have.
I'm currently running a query on my website to pull all the fields from a table in my database, for the data to be used on various parts of the page.

Usually I would do something as follows

Code: [Select]
$result = mysql_query("SELECT * FROM table WHERE page='1'");

while ($row=mysql_fetch_array($result))
 {
 $title = $row["title"];
 $data = $row["data"];
 }

And so on and so forth. I would then call the appropriate data by echoing $data for example.
However, my table contains a lot more rows than i've mentioned (Around 25 or so). Rather than assigning each to a variable and having a large portion of variable assignments at the top of the page, is there any clever way of putting all of these values inside of an array.
So for example, I could call $array_data["title"] or $array_data["data"]??
So it keeps the same key, but puts it inside of an array that I don't have to loop through each time?

Hope that makes sense!

Thanks,
Edd

Hi,

I am trying to fetch all data from database.
but any data show  twice.

like this:

Ali
Ali
30
30
Osman
Osman
20
20
Omer
Omer
40
40
Salim
Salim
10
10
Suzan
Suzan
25
25


$mem_qry = "SELECT * FROM tbl_name";
$res = mysql_query($mem_qry);

function mysql_fetch_all($res) {
   $return = array();
   while($row=mysql_fetch_array($res)) {
       $return[] = $row;
   }
   return $return;
}

$all = mysql_fetch_all($res);
foreach($all as $k=>$v) {
foreach($v as $k2=>$v2){
echo $v2.'<br />';
}
}

<?php



require("connection.php");




$query = 'SELECT * FROM job_post WHERE id_jobpost= :Id';
$start = $bdd->prepare($query);
$start->execute(array(':Id' => $_GET['id_jobpost'])); 
$result = $start->fetch();

foreach ($result as $results) {
    $jobtitle = $result['jobtitle'];
    $id_jobpost = $result['id_jobpost'];
    $description = $result['description'];
    
}


?> 

https://prnt.sc/uk3913

Whats wrong with this code

Im not sure where to post this but since it includes php il post it here instead of in the mysql forum.

ok so, i have a table and i get the values using while($row = mysql_fetch_array($result)){ and then echo them in rows.

that works fine but i need to add a class to the last row of my table. I would need somehow to fetch the last row of the array and make it echo something different.

Any help is appreciated

Thank you

Hi guys,

Im having problem on how to achieved this one.. I would like to get the all event of this month (April
) Starting todays date..

Code: (php) [Select]
$now = gmdate("Y-m-d", mktime(gmdate("H")+8, gmdate("i"), gmdate("s"), gmdate("m"), gmdate("d")+8,   gmdate("Y")));

  $week = gmdate("Y-m-d", mktime(gmdate("H")+8, gmdate("i"), gmdate("s"), gmdate("m"), gmdate("d")+30,   gmdate("Y")));
 
if ($result = mysql_query("SELECT * FROM fiesta WHERE sta_date BETWEEN '$now' AND '$week' ORDER BY sta_date LIMIT 10")){

  if (mysql_num_rows($result)) {

  $return = '';
  while ($row = mysql_fetch_array( $result )) {
       
  $date = date("D",strtotime($row["sta_date"]));

  $return .=  "<a href='sta.php' style='font-size:11px;' title='" . $row['fiesta_brgy'] . " " . $row['fiesta_town'] . "'>" . $row['fiesta_brgy'] . " " . $row['fiesta_town'] . "</a> ($date), ";
   }

    echo rtrim($return, ', ');
  }
}

The result of this query will include the events on May..

How can i display only the event on this month(April)? starting todays date.

Thank you

Hello

i want to fetch the content from my MySQL db for one table and show it on a page, i'm using this code:
Code: [Select]
<?php include("inc/connect.php"); ?>
<?php
$result = $_REQUEST['result'];
?> Code: [Select]
<?php
$query = mysql_query("select * from listtest order by id asc");
while($result = mysql_fetch_array($query))
{
?>
  <tr>
    <td><?php echo $result['id']; ?></td>
    <td><?php echo $result['code']; ?></td>
    <td align="center"><a href="edit.php?id=<?php echo $result['id']; ?>">View</a></td>

    <td align="center">&nbsp;</td>
  </tr>
<?php } ?>

it's throwing me this error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in 32qgtf.php on line 30

What am i doing wrong ?

/Edit: line 29/30 is the mysql query / fetch.

I am trying to create a simple calendar where a user can add/remove their availability date. This part works so far. Now what I am having trouble with is highlighting the already selected dates that are fetched from a MySQL database.

 

Here's my code.

// HTML
<div id="datetimepicker1"></div>

// Jquery/Ajax

<script>
$(document).ready(function () {

  $('#datetimepicker1').datepicker({
    dateFormat: "yy-mm-dd",
    multidate: true,
    onSelect: function () {
        var getDate = $("#datetimepicker1").val();

        $.ajax({
             type: "POST", //or GET. Whichever floats your boat.
             url: "snippets/adapter-set.php",
             data: { date: getDate },
             success: function(data) {
              // alert(data);
             },
             error: function() {
                 alert("Error.");
             }
        });
    }
  });
});
</script>

// PHP
// adapter-set.php

$post_date = $_POST['date'];

$find_query = $db->prepare("SELECT user_id FROM user_dates WHERE date_available = :date_available");
$find_query->bindParam(':date_available', $post_date);
$find_query->execute();
$result_find = $find_query->fetchAll(PDO::FETCH_ASSOC);
if(count($result_find) > 0) {
  foreach($result_find as $row) {
    $user_id =	$row['user_id'];
  }
  $delete_query = $db->prepare("DELETE FROM user_dates WHERE user_id = :user_id");
  $delete_query->bindParam(':user_id', $user_id);
  $delete_query->execute();
  $result_delete = $delete_query->execute();
  if($result_delete == false) {
   echo 'delete false';
  } else {
   echo 'delete success';
  }
} else {
  $insert_query = $db->prepare("INSERT INTO user_dates(date_available) VALUES(:date_available)");
  $insert_query->bindParam(':date_available', $post_date);
  $result_insert = $insert_query->execute();
  if($result_insert == false) {
   echo 'insert false';
  } else {
   echo 'insert success';
  }

}

 

The above code works fine. It inserts and deletes a date row in MySQL database table based on a click.

Now what I would like to do is to highlight all the "available" dates that are already inserted into the database; so that the user knows which dates he has already selected. This is my code for that. But it doesn't seem to be working. No errors. It's just not highlighting the inserted dates. Can you tell me what I'm doing wrong?

// JQUERY
<script>
    $(document).ready(function() {

        $.post('snippets/adapter-fetch.php', {}, function(data){
            $("#datetimepicker1").datepicker({
              datesEnabled : data.datesEnabled
            });
        }, 'json');

    });
</script>

// PHP
// adapter-fetch.php

$global_user_id = 5;

$find_query = $db->prepare("SELECT date_available FROM user_dates WHERE user_id = :user_id");
$find_query->bindParam(':user_id', $global_user_id);
$find_query->execute();
$result_find = $find_query->fetchAll(PDO::FETCH_ASSOC);
if(count($result_find) > 0) {
  foreach($result_find as $row) {
    $date_available =	$row['date_available'];

    echo $date_available;
  }
} else {
  echo 'not dates available';
}

 

Hello, I have this simple php form that updates the table, and also shows what the information in it is.

Here it is:


<strong>Update multiple rows in mysql</strong><br>

<?php
$host="localhost"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name="test"; // Database name
$tbl_name="test_mysql"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

// Count table rows
$count=mysql_num_rows($result);
?>
<table width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="">
<tr>
<td>
<table width="500" border="0" cellspacing="1" cellpadding="0">


<tr>
<td align="center"><strong>Id</strong></td>
<td align="center"><strong>Month</strong> <strong>Date</strong> </td>
<td align="center"><strong>Lastname</strong></td>
<td align="center"><strong>Email</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td align="center"><?php $id[]=$rows['id']; ?><?php echo $rows['id']; ?></td>
<td align="center"><input name="month[]" MAXLENGTH="3" size="3" type="text" id="month" value="<?php echo $rows['month']; ?>">-
                   <input name="date[]" MAXLENGTH="2" size="2" type="text" id="date" value="<?php echo $rows['date']; ?>">
</td>
<td align="center"><input name="lastname[]" type="text" id="lastname" value="<?php echo $rows['lastname']; ?>"></td>
<td align="center"><input name="email[]" type="text" id="email" value="<?php echo $rows['email']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</form>
</table>
<?php
// Check if button name "Submit" is active, do this

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

for($i=0;$i<$count;$i++){

$month = $_POST['month'];
$date = $_POST['date'];

$lastname = $_POST['lastname'];
$email = $_POST['email'];

$name = $month."<br>".$date;



$sql1="UPDATE $tbl_name SET name='$name[$i]', month='$month[$i]', date='$date[$i]', lastname='$lastname[$i]', email='$email[$i]' WHERE id='$id[$i]'";
$result1=mysql_query($sql1);
}
}

if($result1){
header("location:update2.php");
}
?>    




<?php
$result = mysql_query("SELECT * FROM test_mysql")
or die(mysql_error());  

echo "<table border='1'>";
echo "<tr> <th>Name</th> <th>Age</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
    // Print out the contents of each row into a table
    echo "<tr><td>"; 
    echo $row['name'];
    echo "</td><td>"; 
    echo $row['lastname'];
    echo "</td></tr>"; 
} 

echo "</table>";
 ?>


What it does is this, it gets the row from the database, echos it and I am able to edit it and then save.

The thing is, it works with the updating but im trying to combine 2 variables into 1 and update that one also.

Im trying to combine month and date textboxes into one variable in the database that is name.

It for some reason updates the column name to A instead of what I had in the 2 fields month and date.

Here is where I combine both fields into one.
$name = $month."<br>".$date;

And here is where $month and $date is set.
$month = $_POST['month'];
$date = $_POST['date'];


Here is a picture.

I've been using this code for a long time and realised it's very repetitive, but the id_column I want changes all the time


function getRows()
{
$query = mysql_query($sql);
$rows = array();

while($row = mysql_fetch_assoc($query))
{
$rows[$row['id_column']] = $row;
}

return $rows;
}


So I wrote this function that will automatically create an array with a column I choose if I wish, but I'm not sure if it's very efficient.


function getRows($query, $column_id = false)
{
$rows = array();

while($row = mysql_fetch_assoc($result))
{
if($column_id === false)
{
$rows[] = $row;
}
else
{
if(isset($row[$column_id]))
{
$rows[$row[$column_id]] = $row;
}
else
{
$rows[] = $row;
}
}
}

        return $rows;
}


I would appreciate some input as to make it better.
Thanks.

Warning: mysql_fetch_array() expects parameter 1 to be resource, string given...


im tryin to put class inside code if $dayNumber and $dan are equal

i tried few ways but all are complicated since i have to call some functions this end up as "simple" solution but i dont know where did i get wrong PS that should be possible?

Code: [Select]
else {
                  echo "<td width='40'";
  $moj_id = $_SESSION['id'];
  $query_event = mysql_query("SELECT * FROM events WHERE id_user='$moj_id' GROUP BY 'event_date'") ;
  $test = mysql_fetch_array('$query_event');
  $date_event = $test['event_date'];
  sscanf($date_event, "%d-%d-%d", $godina, $mjesec, $dan);
  if ($dan==$dayNumber && $mjesec==$month && godina==$year)
  {

  echo " class='radni'";
  }
 
 
  echo"><a href='day_info.php?dan=",$dayNumber,"&mj=",$month,"&gd=",$year,"'>" . $dayNumber . " </a></td>\n";
                  $dayNumber++;                           
              }

Hi,   Does anyone have a clue how I might solve this little issue:   I have a MySQL query, for example:

<?php
// Make a MySQL Connection
$query = "SELECT * FROM staff";
    
$result = mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_array($result)){

    if($row['clock'] < time()) {
    echo "<b>"$row['name']. " - ". $row['age']"</b>";
    echo "<br />";

    } else {

    echo $row['name']. " - ". $row['age'];
    echo "<br />";

    }
}
?>

Taking data from the following table setup:   name - age - clock Timmy Mellowman - 23 - 09:00:00
Sandy Smith - 21 - 12:00:00
Bobby Wallace - 15 - 14:00:00   What im trying to achieve is compare the current time to the time in the clock column and depending if it's earlier or later, change the styling of the results.   The above code does appear to work somewhat however it seems to change the styling of all results in one go, rather than individually when it passes the time in the cell, which is what im looking for.   Thanks

//my controller
<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use DB;

class homeController extends Controller
{
    public function index() {
        
        $employee = DB::table('employee')->orderBy('id','desc')->get();
        
        $department = DB::table('department')->orderBy('id','desc')->get();

    	return view('index', ['employee' => $employee , 'department' => $department]);
    }
}

//my routes

Route::get('index','homeController@index');

//my view using blade temmplating engine
@foreach($employee as $emp)
<div class="employee">
  <b>{{ $emp->name }} </b>
  <a href="employee/{{ $emp->id }}">
	<p class="intro">{{ substr($emp->intro ,0, 50) }}...</p>   
  </a>
</div>
@endforeach

@foreach($department as $dep)
<div class="department">
  <b>{{ $dep->name }} </b>
  <a href="department/{{ $dep->id }}">
	<p class="desc">{{ substr($dep->description ,0, 100) }}...</p>   
  </a>
</div>
@endforeach

I want to fetch using ajax, how can i do it, teach/help me