PHP - Little Push In The Right Direction With My Simple Php Script

Dear friends.

Now I am doing Mobile APP by Flutter and Backend I use PHP,  for normally using like get information and save information it's work by API concept.

so now I would like to push notification to the mobile APP. is it can work by PHP or I need to use feature of firebase?

I use the following code to create a 48x7 array for my application:
Code: [Select]
                    // Loop through each time division
                    for($i=0; $i<$div; $i++)
                    {
                        // Loop through the week we're displaying
                        for($j=0;$j<$dayPerPage; $j++)
                        {
                            $dateArray = getDate( mktime( 0, 0, 0, date("m"), date("d")+$j+$dateOffset, date("Y") ) );
                            $date = sprintf('%04d-%02d-%02d',$dateArray["year"],$dateArray["mon"],$dateArray["mday"]);

                            $datetime[]="$time|$date";
                           
                            list($start_date) = explode('|',$datetime[1]);
                            list($end_date) = explode('|',end($datetime));
                        }
                        $min += $step_size;
                        if($min >= 60)
                        {
                            $min = 0;
                            $hr++;
                        }
                        $time = sprintf('%02d:%02d:00',$hr,$min);
                    }Now, I'm under the assumption that list($start_date) and list($end_date) should give me the beginning and ending dates inside the array (say 2011-10-01 and 2011-10-07), but instead I get the beginning and ending times in it ('00:00:00' AND '23:30:00'). Could someone clarify what I'm doing wrong and how I can fix it? I'm really new to php 

EDIT: Sorry... used the wrong tags for the code the first time around. Fixed.

I need help for get this result in foreach loop. ok64|33|37|Test1|Test2|Test3|   But with my looping i get this result: ok64|Test1|33Test2|37|Test3|

<?
$check = array('ok');
foreach($results as $rows) {
  array_push($check, $rows['votes']."|");
  array_push($check, $rows['value']."|");
 }
?>

i am working on this search engine. and in the advanced section you can turn on/off some of the options. So it you turn on an option it will search another table and so on.

Instead of building a massive query and left joining lots of stuff. I tried a different approach.

There is always a basic query and it returns the results to an array like this


Code: [Select]
$sql = mysql_query("SELECT SQL_CACHE id FROM table WHERE field LIKE '$getquery' ORDER BY field");
  while ($row = mysql_fetch_array($sql)) {
     $idArray[] = $row['id'];
  } mysql_free_result($sql);
and if something is turned on then it adds something like this:

Code: [Select]
if($_POST['value'] == "1") {
$sql = mysql_query("SELECT SQL_CACHE table1_relation_id FROM table2 WHERE field2 LIKE '$getquery' ORDER BY field2");
  while ($row = mysql_fetch_array($sql)) {
    $idArray[] .= $row['table1_relation_id'];
  } mysql_free_result($sql);
} //end if

so basicy i just continue the array and it keeps pumping ids into a big aray. after that i run array_unique and remove all duplicate results and then i foreach and get the whole item info ased on every id. it runs pretty fast.


now i would like to make the second one a function. but when i do that it does not work.

Code: [Select]
function sample($query, $table, $field) {
$sql = mysql_query("SELECT SQL_CACHE naziv_id FROM ".$table." WHERE ".$field." LIKE '$query'");
while ($row = mysql_fetch_array($sql)) {
$return[] .= $row['naziv_id'];
} mysql_free_result($sql);

return $return;

}
before i put it into a function $idArray vas a single continuous array. And if i try to do it like this:

Code: [Select]
$arr[] = sample($query, "table1", "filed_id");
$arr[] .= sample($query, "table2", "filed_id");
it returns the result of the first array ok but if there are more then one results in other arrays it returns and arary inside of the array.

like this:

Code: [Select]
array(4) { [0]=> array(2) { [0]=> string(4) "9057" [1]=> string(5) "14186" } [1]=> string(5) "Array" [2]=> string(5) "Array" [3]=> string(0) "" }
and all i wanna have is a single id variable that has all the id's in it. like $array = 1,2,3,4,5 but from different sources/functions

can you help? thank you so much.

<html>
<head></head>
<body>
My favourite bands a
<ul>

<?php

// define arrays
$morebands = array('Desturbed', 'Anthrax');
$artists = array('Metallica', 'Evanescence', 'Linkin Park', 'Guns n Roses', "$morebands");
// loop over it
// print array elements
foreach ($artists as $a) {
    if ($a != 'Array'){
   echo '<li>'.$a;
}
   Else {
foreach ("${$a}" as $b){
echo '<li>'.$b;
}
}
}

?>

</ul>
</body>
</html>

I can not figure out why this will not work:(
I would like the foreach to run through the array as normal, but if it encounters a nested array, loop it as well.

I know this likely is not the right, or best way to do this, but I am just learning PHP through a tutorial and I learn best by doing... So I take the lessons, make them more complicated, then figure out how to make it happen (like so).

right now I am working on
http://devzone.zend.com/node/view/id/635

anyhow thanks for any help!

I have not coded much for a while, and when I did it was minimal. I played with PHP5 and MySQL a little, but that was a couple of years ago. The last website I built was in 2004 and it was tables upon tables in html. I am starting to learn all over again, can anyone recommend a good starting place or book for what might as well be a beginner.

Thanks

Bill

I want to create a shopping cart system for my website, but a simple shopping cart. I don't want a registration form or anything like that, just a way to add or delete a product..... so, how am I going to achieve this? I don't know! I don't know what I am even suppose to be looking for. Though, I do suspect I need to learn something called "PHP sessions" to store a cookie on someones computer to keep the shopping cart active.

I use MySQL for my database, so I am guessing I will need to also create some form of temporary storage table as well.
To be honest, I am shitting myself and have feared this task for over a month, but I am brave and going to take the plunge. In my head I can picture the process actually being very simple: a cookie is stored on someones computer > adding to cart simply is a HTML form that PHP then adds to MySQL > on purchase PHP calls the data from MySQL and forwards it to the payment gateway API.
... but I am only asking for advice on the PHP session and storing the cart in MySQL... The payment API will be a simple matter of PHP pulling information from MySQL and forwarding it to the API.

Can someone please point me to the right.... concept... or something?

Hi all, Im coding a simple script for my website which just changes the users rank.

Code: [Select]
<?php
session_start();
include "../includes/db_connect.php";
include "../includes/functions.php";
logincheck();

ini_set ('display_errors', 1);
error_reporting (E_ALL);

$username=$_SESSION['username'];

$get = mysql_query ("SELECT * FROM users WHERE username = '$username'");
$fetch = mysql_fetch_object($get);

if ($fetch->userlevel >= "2"){
$newrank = $_POST['newrank'];
$user1 = $_POST['user'];
if (strip_tags($_POST['update'])){
mysql_query("UPDATE users SET `rank` = '$newrank' WHERE username='$user1'") or die (mysql_error());
echo ("You have updated $user1's rank to $newrank !");
}
}
else{
echo ("Your userlevel isnt high enouth to be here!");
}
?>
<html>
<head>
<title>Change Rank</title>
<link rel="stylesheet" href="../includes/in.css" type="text/css">
<style type="text/css">
.infobg {
font-family: Arial;
font-weight:normal;
font-size:12px;
border-top: 1px solid #000000;
border-right: 1px solid #000000;
border-bottom: 1px solid #000000;
border-left: 1px solid #000000;
background: URL(textbg1.png);
font-weight:300;
}

.button {
font-size: 12px;
background:url(button.png);
vertical-align: middle;
border-top: 1px solid #000000;
border-right: 1px solid #000000;
border-bottom: 1px solid #000000;
border-left: 1px solid #000000;
color: #FFFFCC;
height:23px;
font-weight:300;
border-radius: 10px;
padding-bottom:2px;
}

</style>
</head>
<body>
<form action='' method='post' name='form1'>
<table width='30%' cellpadding='0' align='center' cellspacing='0' border='1' bordercolor='#000000' bgcolor='#808080' style='border-collapse: collapse'>
<tr>
<td background='../header.jpg' colspan='2' align='center'>Change Rank</td>
<tr>
<td>Username:</td><td><input type='text' name='user'></td>
</tr>
<tr>
<td>Rank:</td><td><input type='text' name='newrank'></td>
</tr>
<tr>
<td>&nbsp;</td><td><input type="submit" name="update" value="Update Rank"></td>
</tr>
</form>
</table>
</body>
</html>
But there seems to be something wrong with that code, which I carnt see or work out. When I click Update submit button it does nothing, but can anyone see why it does nothing?

Thanks.

Good evening guys and gals,

for some reason I cant get my head around something quite simple, basically I am trying to work out a way of simply recording referrals to my site when the potential user registers.

This worded example is basically what I want:

registered user a with a username of smithy invites his friend western to become a member of a site he has joined:

I guess here I would basically use something like mysite.com?refid=smithy as the link he gives he's friend

Now this is where my brain refuses to work, what if western decides to have a look around the site before he decides to register and clicks on a few internal pages? Obviously the referral id will no longer be in the address bar.

So my 1st question is, how can I check to see if a referral is used when accessing the site? I could then store the username in a session or cookie.

If I had something like this:

<?php

$refid = $_GET('refid')

setcookie("user", $refid, time()+3600);
?> 

But how would I check that a refid exists in the url so it doesnt throw up a parse error?

I have more questions but 1 thing at a time!

Many Thanks

i already have the front page that calls the script, but its not letting me login, i don't see the problem i know its returning the rows from the database but i don't understand why its not letting me login and when i do get it to login messing around with the code everybody logs in as an admin, my database has, user, pass, and role inside admin, poweruser, and reg user but when i get it to log in everybody logs in as an admin, can someone please help me ? i even tried the error thing but that doesn't seem to work either



ini_set('display_errors', 1);
error_reporting(E_ALL);
//echo ini_set('display_errors');

session_start();

$username = $_POST['username'];
$password = $_POST['password'];

if (mysql_connect("localhost", "root", ""))
    {
        //echo 'connect';    
    }
    
else
    {
        echo 'failure';
    }

if  (mysql_select_db("athentication"))
    {
        //echo 'connect';    
    }
    
else
    {
        echo 'no connect';
    }

    $result = mysql_query("SELECT * FROM login WHERE user = '$username'");
    $rows = mysql_num_rows($result);
    $role = $rows['role'];

if ($rows != 0)
{
    if ($role == 'admin')
           {
           header('Location: admin.php');
           $_SESSION['username'] = $username;
           }
           
    elseif ($role == 'poweruser')
           {
           header('Location: poweruser.php');
           $_SESSION['username'] = $username;
           }
           
    /*elseif ($role ==' reg')
           {
            echo "WHAT UP";
            $_SESSION['username'] = $username;
           }*/
 }
 else
    echo "enter a valid user name";

Hi everybody, my goal is to get the IP of someone accesing the site, writing the time and date along with his IP into the database. Of course, I would be adding the script to my frontpage when I make it work.
But I get this error:
Quote


Parse error: syntax error, unexpected T_VARIABLE in D:\Program Files\xampp\xampp\htdocs\script1.php on line 8

I've checked line 8, I dont find anything in it that is out of place.
Here is the code:


<?php 
$ip = $_SERVER['REMOTE_ADDR'];
$date = date("m.d.y"); 
$time = time();
mysql_connect ("localhost", "root", "********") or die ('Error: '. mysql_error());
mysql_select_db ("ip");

$query = "INSERT INTO ipdo (time, date, ip) VALUES ('"$time"', '"$date"', '"$ip"')";
mysql_query($query) or die ('Error updating database');

echo "Database updated with: " .$ip. "" ; 
?>


This is the first script I write entirely on my own, so be gentle 
Help?

I was told that you guys could probably help me with this, so heres my situation. I use this program called Activeworlds, and me and my buddies are makeing a "tv show" if you will within the program. To do so, you take screenshots, save the screenshots, and add the image files into a directory on your domain. You need a .php script to present them as a slideshow. Now the problem is, ive searched for scripts already made from other sites, but the thing is, they are all fancy slideshow viewers, meaning they come with control buttons to cycle through the pictures and all kinds of other banners and flashy looking things. The only script im needing, is a simple script that will display and cycle through the raw images, and nothing else, within the web browser, in a slideshow format. Id also like to have a value I can edit that will change how fast the pictures cycle through, 15 seconds or so would be perfect however. If someone could refer me to this code or even make it for me, it would be soo appreciated. I know im probably asking for alot, but it would help me soo much. I wish I knew a little more about .php files to do it myself, or else I would. If you do link me to a script, please give me simple instructions on what to do with it lol because like I said, I dont know anything about the world of .php yet. Thank you all for your time.

Can someone show me a simple mail script that I can run in cli, I can enter a $to = email@email.com and then have it send to my email? just in cli.. Thanks

I'm very new to PhP and one of my asignments in class is to create a simple login using php and mysql. I made a simple page using html, php, and mysql and i keep getting errors. Here is my code so far:
This is my index.php page:
<html>
   <form action = 'login.php' method='POST'>
      Username: <input type='text' name='username'><br>
      Password: <input type='password' name='password'><br>
      <input type='submit' value='Log in'>
   </form>
</html>
This is my login.php page:
<?php
$username = $_POST['username'];
$password = $_POST['password'];

if ($username&&$password)
{
&connect = mysql_connect("localhost", "root", " ") or die ("Couldnt connect");
mysql_selct_db("phplogin") or die("Couldn't find db");
}
else
   die ("Please enter a username and password");
?>
mySql file is very basic: 3 columns, id, username, password

I dont think my problem is with the mySQL page that was the easiest to make

but everytime I hit login in the index.php, the entire script for login.php gets outputted on screen.

I would appreciate all the help.

I've tried Googling this for a long time but I only find complete member systems with ugly code, not something i'm looking for.

What I am looking for is just a simple tutorial or commented code to make a admin login.

What it's going to do is just:

Loading a MD5 salt hasched password from my MYSQL database.
You'll get to fill in one field: Password. If it validates with the MYSQL password it'll show the hidden content; if not it'll just give a "not correct error".

That's basicly it. I have only one page of secret admin stuff so yeah.. it would be awesome to have the ability to logout and I of curse want to have everything in sessions!

It would be to big help!