PHP - Minor Changes & Tailoring Of A Regex - That Allready Works Very Fine

 FOR the CMS go to http://sandeepthapa.com.np/project/admin
and login in
username: user
pasword: 123456
with both Chrome and IE. pleease
 
and site is http://sandeepthapa.com.np/project/

it works fine with Chrome, but not with IE.
please help me
this is my first CMS . i am learning..  it
i use joommla templetefor design. oz i am not a designer



//..here is the code for process_login.php  page

<?php require_once("includes/session.php"); ?><?php require_once("includes/connection.php"); ?><?php require_once("includes/functions.php"); ?><?php

   if (logged_in()) {
      redirect_to("content.php");
   }

   
   if (isset($_POST['submit']))
 {
   
   
      
      
      if(!$_POST['username'])
      {
      echo ' Make sure u type in username';
      }
      if( !$_POST['password'])
      {
      echo 'make sure you type password';
      }

      $username = trim(mysql_prep($_POST['username']));
      $password = trim(mysql_prep($_POST['password']));
      $hashed_password = sha1($password);
   
      
   
         // Check database to see if username and the hashed password exist there.
         $query = "SELECT id, username ";
         $query .= "FROM users ";
         $query .= "WHERE username = '{$username}' ";
         //$query .= "AND hashed_password = '{$hashed_password}' ";
         $query .= "AND hashed_password = '{$hashed_password}' ";
         $query .= "LIMIT 1";
         $result_set = mysql_query($query) or die(mysql_error());
         if(!$result_set)
         {die("Database connection failed: " . mysql_error());}
         confirm_query($result_set);
         if (mysql_num_rows($result_set) == 1) {
            // username/password authenticated
            // and only 1 match
            $found_user = mysql_fetch_array($result_set);
            //echo $found_user['id'];
            
            
            $_SESSION['user_id'] = $found_user['id'];
            $_SESSION['username'] = $found_user['username'];
            
         
            
            //echo 'test query';
         
            redirect_to("content.php");
               }
}
               
                 
            
         
            
      
         
   else
   {
      
   
   echo 'error'.mysql_error();
   
   }
?>
</body>
</html>

Hi all,

I wonder if any of you have this problem before..

I have a login page with "checked box remember me" - It is working fine in my localhost machine I can see the COOKIE in my browser's option setting (Firefox).

But now the problem is: When I run the script in my test server; and do exactly the same thing..the COOKIE did not seem know.

When I logged in as an admin and checked the box. And closed all the browser. Then, open the browser (Firefox)and go to the index page (landing page) then it redirect me to the login page instead. I looked the at COOKIE setting in my Firefox and I can it is stored there.

Any ideas whats wrong?

I have strange problem with SOAP. My file SchoolAPI look like that:


<?php
require_once('../require/constants.php');
require_once('../require/connection.inc.php');
 
class SchoolAPI{

private $dbh;

   

public function __construct()
    {
 

 

$this->dbh = new PDO(DRIVER.':host='.HOST.';dbname='.DB, USER, PASSWORD);
  

}
  

//function return all subcjects

public function getSubjects(){

$sth = $this->dbh->prepare('  SELECT id, nazwa ROM subjects');

$sth->execute(); 

 

return $sth->fetchAll(PDO::FETCH_NUM); 

//return array(array("1", "subject1"),array("2", "subject2"));

}

//function return all classes

public function getClasses(){

$sth = $this->dbh->prepare('  SELECT id, nazwa FROM classes');

$sth->execute();  
 

return $sth->fetchAll(PDO::FETCH_NUM);

//return array(array("1", "class1"),array("2", "class2"));

}
  
}
ini_set("soap.wsdl_cache_enabled", "0");
$server = new SoapServer("SchoolAPI.wsdl");
$server->setClass("SchoolAPI");
$server->handle();
?>


wsdl file is named SchoolAPI.wsdl and look like that:


<wsdl:definitions  

xmlns="http://schemas.xmlsoap.org/wsdl/" 

xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" 

xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" 

xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" 

xmlns:xsd="http://www.w3.org/2001/XMLSchema" 

xmlns:tns="http://schema.example.com" 

targetNamespace="http://schema.example.com" >
  
  <wsdl:types>
  

<xsd:schema targetNamespace="http://schema.example.com">

<xsd:complexType name="myarry2">

<xsd:sequence>

<xsd:element minOccurs="0" maxOccurs="unbounded" name="row" nillable="true" type="xsd:string" /> 

</xsd:sequence>

</xsd:complexType>

</xsd:schema>
    <xsd:schema targetNamespace="http://schema.example.com">

<xsd:complexType name="myarray">

<xsd:sequence>

<xsd:element minOccurs="0" maxOccurs="unbounded" name="table" nillable="true" type="tns:myarry2" /> 

</xsd:sequence>

</xsd:complexType>

</xsd:schema>
  </wsdl:types>

  <wsdl:message name="getSubjectsRequest"></wsdl:message>
  <wsdl:message name="getSubjectsResponse">
    <part name="getSubjectsReturn" type="tns:myarray"/>
  </wsdl:message>

  <wsdl:message name="getClassesRequest"></wsdl:message>
  <wsdl:message name="getClassesResponse">
    <part name="getClassesReturn" type="tns:myarray"/>
  </wsdl:message>

  <wsdl:portType name="SchoolAPIPortType">
    <wsdl:operation name="getSubjects">
      <wsdl:input message="tns:getSubjectsRequest"/>
      <wsdl:output message="tns:getSubjectsResponse"/>
    </wsdl:operation>

    <wsdl:operation name="getClasses">
      <wsdl:input message="tns:getClassesRequest"/>
      <wsdl:output message="tns:getClassesResponse"/>
    </wsdl:operation>
  </wsdl:portType>

  <wsdl:binding name="SchoolAPIBinding" type="tns:SchoolAPIPortType">
    <soap:binding transport="http://schemas.xmlsoap.org/soap/http"/>
    <wsdl:operation name="getSubjects">
      <soap:operation soapAction="urn:SchoolAPI/getSubjects" style="document"/>
      <wsdl:input> <soap:body use="literal"/></wsdl:input>
      <wsdl:output><soap:body use="literal"/></wsdl:output>
    </wsdl:operation>
    <wsdl:operation name="getClasses">
      <soap:operation soapAction="urn:SchoolAPI/getClasses" style="document"/>
      <wsdl:input> <soap:body use="literal"/></wsdl:input>
      <wsdl:output><soap:body use="literal"/></wsdl:output>
    </wsdl:operation>
  </wsdl:binding>
  
  <wsdl:service name="SchoolAPI">
    <wsdl:port name="SchoolAPIPort" binding="tns:SchoolAPIBinding">
      <soap:address location="http://localhost:82/myschool/webservices/SchoolAPI.php" />
    </wsdl:port>
  </wsdl:service>
</wsdl:definitions>


The problem is that correct data is returned olny by first function declarated in <wsdl:binding> section. In this example correct data will be return by getSubjects function, and function getClassses return null. However, if we change order and put getClasses operation first in binding section like this:


  <wsdl:binding name="SchoolAPIBinding" type="tns:SchoolAPIPortType">
    <soap:binding transport="http://schemas.xmlsoap.org/soap/http"/>

 <wsdl:operation name="getClasses">
      <soap:operation soapAction="urn:SchoolAPI/getClasses" style="document"/>
      <wsdl:input> <soap:body use="literal"/></wsdl:input>
      <wsdl:output><soap:body use="literal"/></wsdl:output>
    </wsdl:operation>
    <wsdl:operation name="getSubjects">
      <soap:operation soapAction="urn:SchoolAPI/getSubjects" style="document"/>
      <wsdl:input> <soap:body use="literal"/></wsdl:input>
      <wsdl:output><soap:body use="literal"/></wsdl:output>
    </wsdl:operation>
  </wsdl:binding>


then correct data will be return by getClasses function, and getSubjects will return null. Do you know what is going on? I do my best to solve this problem and I have no idea what is wrong...

hi i have the script below which copies data from one table to another but will only insert new data update current data or delete old data from tempproducts to products then it will delete the tempproducts from the db however i keep getting this error:

Warning: mssql_query() [function.mssql-query]: Query failed in E:\UpdateProducts.php on line 33

updateproducts.php
Code: [Select]
<?php
include('../../otherscripts/functions.php');
$log = new Logging(); 

// create DB connection
 $host = "localhost";
 $user = "user";
 $pass = "pass";
 $mydb = "db";

 $db = mssql_connect($host,$user,$pass);
 
//Select Database
 mssql_select_db($mydb);
 

 // delete all old data
    $sql0 = "SELECT * FROM tempproduct";
    $sql1 = "INSERT INTO products SELECT * FROM tempproduct WHERE manf_part_no NOT IN (SELECT manf_part_no FROM products) AND supp_id NOT IN (SELECT supp_id FROM products)";
    $sql2 = "DELETE FROM products WHERE manf_part_no NOT IN (SELECT manf_part_no FROM tempproduct) AND supp_id NOT IN (SELECT supp_id FROM tempproduct)";
    $sql3 = "UPDATE p1 SET p1.avail_qty = t1.avail_qty, p1.cost_price = t1.cost_price, p1.rrp = t1.rrp, p1.date_added = t1.date_added, p1.description = t1.description FROM Products p1 INNER JOIN tempproduct t1 ON (p1.manf_part_no = t1.manf_part_no AND p1.supp_id = t1.supp_id)";
    $sql4 = "TRUNCATE TABLE tempproduct";

//If tempproduct is empty done Execute Commands if it is full then execute commands

$query = mssql_query($sql0) or die($log->lwrite('Failed to select for count from db'));
$rowcount = mssql_num_rows($query);

if($rowcount == 0){
$log->lwrite('Teh tempproduct am emptyish');
}
else{
   mssql_query($sql1) or die($log->lwrite('Failed to insert to db'.$sql1));
   mssql_query($sql2) or die($log->lwrite('Failed to Delete from db'));
   mssql_query($sql3) or die($log->lwrite('Failed to Update db'));
   mssql_query($sql4) or die ($log->lwrite('Failed to TRUNCATE db'));
}
?>

if i run $sql1 command in the sql manager it runs fine and no errors occur?

I got this code

<?php
// Check if session is not registered, redirect back to main page. 
// Put this code in first line of web page. 
session_start();
if (!isset($_COOKIE["user"])) {
header("location:login.php");
}
include 'connection.php';
?>
<html>
<head>
<meta name="viewport" content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=no">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="HandheldFriendly" content="true">
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> 
<title>EBS Service Skjema</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>

<body>
<?php
include 'menu.php';
echo "<div class=\"bluebox\">";

if (isset($_GET['sted'])) {

 require_once('graph/jpgraph.php');
 require_once('graph/jpgraph_line.php'); 
 include 'connection.php';
 //  data

	$sql = mysqli_query($con, "SELECT * FROM diesel WHERE sted = '".$_GET['sted']."' GROUP BY WEEK(dato)");

	    
$ydata = array();	
$ydate = array(); 
while($row = mysqli_fetch_array($sql))
		{
			$ydata[]=$row['krl'];
			$ydate[]=$row['dato'];
		}


// Create the graph. These two calls are always required
$graph = new Graph(600,250);
$graph->SetScale('textlin');
$graph->title->Set('Pris Historikk');
$graph->xaxis->title->Set("Dato");
$graph->yaxis->title->Set("Pris");
$graph->xaxis->SetTickLabels($ydate);
// Create the linear plot
$lineplot=new LinePlot($ydata);
$lineplot->SetColor('blue');
//$lineplot->SetFillColor('orange@0.5');

// Add the plot to the graph
$graph->Add($lineplot);

// Display the graph
$graph->Stroke();
}

else {
	echo "Du får ikke tilgang på denne måten.";
}


echo "</div>";
?>

</body>
</html>

but I get headers allready sent. I was earlier told to learn and code or make my apps different, but I'm totaly stuck cause I need to make a page with those stats. Not sure how I can make all my code be processed first then put into the html area. Is a function the way to go here ?   Thanks for reading and hope someone can enlighten me

hey guys,

i need some help with my php/mysql iplogger. My code:

<?php

    //finds out ip
    $ip = $_SERVER['REMOTE_ADDR'];
    //conects to the mysql server
    $connection = mysql_connect('localhost', 'root', '');
    //sellects the database
    mysql_select_db('iplog', $connection);
    //looks for duplacute ips
    $dup = mysql_query("SELECT COUNT(number) FROM logged_ips WHERE ip_address = '$ip'",$connection);
    $count = mysql_result($dup, 0);
    //checks to see if there is a duplecate name
    if ($count == 0){
        //inserts the ip in to the database
        $string = 'INSERT INTO `logged_ips` (`aid`, `ip_address`, `ip_visits`) VALUES (\'' . null . '\', \'' . $ip . '\', \'0\')';
        mysql_query($string, $connection);
    }else{
        //adds a visit to the database
        $string2 = "UPDATE `logged_ips` SET `ip_visits` =  '++1' WHERE `ip_address` = $ip LIMIT 0,1";
        mysql_query($string2, $connection);
    }
    //outputs the ip
    echo $ip;
?>

error:

Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\randoms\logger\test.php on line 11
127.0.0.1

It also doesnt put anything in to the mysql database. Please help.

Thanks jragon

Hi All,

I have been handed a site from a friend of mine to fix as there were a few errors on it. I have only had very little experience with php coding and believe im doing well so far as i only have one more error to rectify on this particular site. Is any one familiar with the following error codes and how to resolve them?


Warning: include(list_.inc.php) [function.include]: failed to open stream: No such file or directory in /home/user/public_html/list.php on line 13

Warning: include(list_.inc.php) [function.include]: failed to open stream: No such file or directory in /home/user/public_html/list.php on line 13

Warning: include() [function.include]: Failed opening 'list_.inc.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/user/public_html/list.php on line 13

Iv done a bit of research and to me it doesn't seem like a huge fix and i think its something i am capable of doing myself i just need a bit of guidance. Any help greatly appreciated.

Michael

ok , this is to request someone to be your friend and i keep getting an error saying "mysql_error() expects parameter 1 to be resource" i dont know what is wrong , it worked before ... please help.
Code: [Select]
<?php

if ($_POST["request"] == "requestFriendship") {

    $mem1 = preg_replace('#[^0-9]#i', '', $_POST['mem1']); 
    $mem2 = preg_replace('#[^0-9]#i', '', $_POST['mem2']); 
//
if (!$mem1 || !$mem2 || !$thisWipit) {
echo  'Error: Missing data';
     exit(); 
}
//
if ($mem1 == $mem2) {
     echo  'Error: You cannot add yourself as a friend';
     exit(); 
} 


//See if already friends
$sql1 = "SELECT id FROM friends WHERE mem2='$mem1' AND mem1='$mem2' LIMIT 1";
$result1 = mysql_query($sql1) or die (mysql_error("sql1 failed")); 
$data1 = mysql_fetch_row($result1);
    if ($data1[0]) {
echo  'This member is already your Friend'; 
exit(); 
}
//Check if user already requested to be friends
$sql2 = "SELECT id FROM friends_requests WHERE mem1='$mem1' AND mem2='$mem2' Limit 1";
$result2 = mysql_query($sql2) or die (mysql_error("sql2 failed")); 
$data2 = mysql_fetch_row($result2);
    if ($data2[0]) {
echo '<img src="images/round_error.png" width="20" height="20" alt="Error" /> You have a Friend request pending for this member. Please be patient.';
        exit(); 
}
//Check if friend already requested to be friends
$sql3 = "SELECT id FROM friends_requests WHERE mem1='$mem2' AND mem2='$mem1' Limit 1";
$result3 = mysql_query($sql3) or die (mysql_error("sql3 failed"));  
$data3 = mysql_fetch_row($result3);
    if ($data3[0]) {
echo '<img src="images/round_error.png" width="20" height="20" alt="Error" /> This user has requested you as a Friend already! Check your Requests on your profile.';
        exit(); 
}
//If still here make insert
$mem1=mysql_real_escape_string($mem1);
$mem2=mysql_real_escape_string($mem2);
$sql = mysql_query("INSERT INTO friends (mem1, mem2, timedate) VALUES('$mem1','$mem2',now())") or die (mysql_error("Friend Request Insertion Error"));
echo '<img src="images/round_success.png" width="20" height="20" alt="Success" /> Friend request sent successfully. This member must approve the request.';
    exit(); 
}
?>

Hi   I have a small script, on a single file that needs to be optimized. file is about 300 lines (16Kb), and basiccaly looks like the "PHP-monster" threw up on it. Script is working ok, but surely could be much better.   PM if interested and I can send you a copy of file. If possible leave price/hourly rate.

I have a form with a table that contains ONLY dropdown menus for users to select quantities from 25 dinner items.  It contains some Javascript, but nothing fancy.  In an effort to establish my database and TEST to see how some PHP functions might respond so I could improve my form, I created a mini version of the db in MySQL.

But when I click the submit button, the page blinks, the address bar fills with field names, but there is no connect.  No error messages.  No data transfer.  NO NOTHING!

I searched the web and copied a form and plugged it in (an html form, a php insert file, and a MySQL database) and it worked fine.  I peared down my page to mirror it, and still, no success.

What little detail am I missing??  If I have 25 fields but create a db for the first 6, should it function?
If I reduce it and try to re-use the same db, am I persuing a problem?
I've tried error trapping and changing the form inputs, but it just still doesn't connect.

Please help!

Hey guys im having 2 minor problems with my script if someone can give me some advise please? (all 2 problems are commented on the script itself)   1.  highlighting string characters when typed. 2. also im trying to add "Hide Suggestions" at the bottom of my menu so people can turn on/off autocomplete

$(document).ready(function()
{	
	function search_autocomplete(selector, tags, default_value)
	{	
		
		$('#' + selector).focus(function() 
		{
			if($('#' + selector).val() == default_value)
			{
				$('#' + selector).val('');
			}
		});
		
		$('#' + selector).blur(function() 
				{
					if($('#' + selector).val() == '')
					{
						$('#' + selector).val(default_value);
					}
				});
		
	    $('#' + selector).autocomplete(
	    {
	    	source: tags,
	    	timeout: 0,
	    	
	    	select: function (a, b) 
	    	{
	    		$(this).val(b.item.value);
	    	    //submit
	    	},
	    	
	    	create: function () 
	    	{
	            $(this).data('ui-autocomplete')._renderItem = function (ul, item) 
	            { 	
	            	// not highlighting when string characters match
	            	var re = new RegExp('^' + this.term);
	            	var t = item.label.replace(re, "<span id='dropdown-item-highlight'>" + "$&" + "</span>");
	            	
	            	
	                return $('<li></li>')
	                .append('<a>' + t + ' in ' + item.type + '</a>')
	                .addClass( 'dropdown-item' )
	                .appendTo(ul);
	                
	            };
	    	}
	    }); 
	    
	    $(this).data('ui-autocomplete')._renderMenu = function (ul, item) 
        { 	
	    	// unable to show "Hide Suggestions at the bottom of the autocomplete menu
    		return $('<ul></ul>')
    		.append('<a>Hide Suggestions</a>')
    		.addClass( 'dropdown-menu' );
        };
	
	}
	
	var availableTags = [{"label" : "XBOX 360", "type":"Electronics"},
	                     {"label":"XBOX One", "type":"Electronics"},
	                     {"label":"Nike", "type":"Clothing & Footwear"}];
	
	search_autocomplete('query', availableTags, 'Search...');
});

thanks

I just installed this new script here http://webhost.pro/domain-check.php it's a basic domain availability tool.

I am trying to make a form that can be used on any page forward to this page with the content.

The page loads with this in the url webhost.pro/domain-check.php?domain=dwhs.net and will run the page.

So I can make a form that just submits to that page and sends the details.

I made this page for testing

http://webhost.pro/test.html

But no go, here is the code:

<form id="search" action="/domain-check.php" method="GET">
<input type="text" name="s">
<a onClick="document.getElementById('search').submit()" class="button1">Search</a>
<div class="clear"></div>
</form>


Thanks!

This script was working fine yesterday i havn't changed anything?? not it don't register the user upon completing the script no error, just when you hit submit it refreshes and does nothing?

<?php
//check for submit
$submit =$_POST['submit'];

//gather POST variable
$fullname =strip_tags($_POST['fullname']);
$email =strip_tags($_POST['email']);
$username =strip_tags($_POST['username']);

$password =strip_tags($_POST['password']);
$password2 =strip_tags($_POST['password2']);


if ($submit) 
{
//check that fields were filled in
if ($fullname&&$email&&$username&&$password&&$password2)
{
//check to see if our two password fields match
if ($password==$password2) 

{
$password = md5($password);

// register the user
 //open database
$connect = mysql_connect("localhost", "root", "");
mysql_select_db("users");


//begine insert
$queryreg = mysql_query("INSERT INTO members VALUES ('','inet_aton('127.0.0.1')','$fullname','$email','$username','$password')");
if ($queryreg) {
echo "Thanks, For Registering! Click <a href=\"index.php\">HERE</a>To Login!";
}

}

//otherwise if passwords don't match
else {
echo "<font color='red'>The passwords you entered do not match</font>";
//end of checking password
}

}

else {
echo "<font color='red'>Please enter all fields!</font>";
}

}

//end check for submit 
?>
<form action='testreg.php' method="post">
<table align="center">
<tr>
     <td>
     Your Full Name:
        </td>
        <td>
        <input type="text" name="fullname" value="<?php echo $fullname; ?>">        
        </td>
    </tr>
     <tr>
     <td>
     Email Address:
        </td>
        <td>
        <input type="text" name="email" value="<?php echo $email; ?>">        
        </td>
     <tr>
     <td>
     Choose Username:
        </td>
        <td>
        <input type="text" name="username" value="<?php echo $username; ?>">        
        </td>
    </tr>
     <tr>
     <td>
     Password:
        </td>
        <td>
        <input type="password" name="password">        
        </td>
    </tr>
     <tr>
     <td>
     Retype Password:
        </td>
        <td>
        <input type="password" name="password2">        
        </td>
    </tr>
</table>
<p>
<center><input type="submit" name="submit" value="Register"></center>

</form>

hey guys im after the pattern to replace , and & symbols please?...any help would be great   thank you