Search found 30 matches

by maideen
Sat Sep 16, 2017 6:34 pm
Forum: PHP coding => General
Topic: Problem in inserting partial data from dropdown to mysql using PHP
Replies: 1
Views: 370

Problem in inserting partial data from dropdown to mysql using PHP

Hi I have an issue to insert data from dropdown to mysql. It is inserting the partial data to database Example: if selection is Account Dept, but inserted only Account. missing Dept if selection is Non Active, inserted only Non. missing Active. whatever coming after space, it cannot be inserted. It ...
by maideen
Tue Sep 12, 2017 8:57 pm
Forum: PHP coding => General
Topic: How to display image from mysql BLOB data type using PHP
Replies: 1
Views: 258

How to display image from mysql BLOB data type using PHP

Hi I am new. I am using Bootstrap css. I have an issue to display image with data type BLOB, Really I don't know how to do this. Pls advise me how to do this. Thanks maideen My PHP Insert code if(isset($_POST['add'])) { if($_SERVER["REQUEST_METHOD"] == "POST") { $sid =$_POST['sid']; $sname =$_POST['...
by maideen
Sat Sep 09, 2017 5:47 pm
Forum: PHP coding => General
Topic: display data in input text and Option from my sql using php
Replies: 1
Views: 410

display data in input text and Option from my sql using php

Hi I could not load data into input text and select option control. I don't know where i did wrong. Pls advice me Thank you in advence maideen <?php require_once '../inc/header.php'; ?> <?php if($_SERVER["REQUEST_METHOD"] == "GET") { $id=$_GET['id']; $sql ="Select * from tbl_parameter where id ='$id...
by maideen
Mon Apr 21, 2014 7:23 pm
Forum: mySQL & php coding
Topic: Insert PHP Grid Data into Mysql Table
Replies: 0
Views: 770

Insert PHP Grid Data into Mysql Table

Hi I have one issue. I do not know how to solve and also no idea. It is my scenario. I have Product table with details,selling price, purchase price and so on. I want to invoice to clients. Clients can buy lots of item in single invoice. If I select product, it will display the Name of item,Sell pri...
by maideen
Tue Apr 08, 2014 11:38 pm
Forum: mySQL & php coding
Topic: How to validate email address in php
Replies: 1
Views: 1075

How to validate email address in php

Hi. I am new. I don't know how to validate certain data like emai, web site and numeric value. Here is my code which is work fine. Below is my code. Pls Help me add.php <?php include_once '../inc/header.php'; ?> <Script Language="javascript"> function change_action() { var frm_obj=document.getElemen...
by maideen
Tue Apr 08, 2014 5:26 am
Forum: PHP General
Topic: problem in insert command
Replies: 3
Views: 812

Re: problem in insert command

hi adicooldude I have echoed. It is fine. But the below error It is echoed. it is fine 500 Kinney 661.64 af blandit.mattis@nonleoVivamus.ca www.mujveqthwgg.oys supplier Warning: mysqli_query(): Couldn't fetch mysqli in C:\xampp\htdocs\bkstore\customer\add_data.php on line 59 pls help me. maideen
by maideen
Mon Apr 07, 2014 6:26 am
Forum: PHP General
Topic: could not update mysqli
Replies: 2
Views: 828

could not update mysqli

Hi I have another issue in Update. Could not be updated. pls help me if (isset($_POST['update']) && $_POST['update'] != "" ) { $id=$_POST["id"]; $name = $_POST["name"]; $address = $_POST["address"]; $tel = $_POST["tel"]; $fax = $_POST["fax"]; $email = $_POST["email"]; $website = $_POST["website"]; $...
by maideen
Mon Apr 07, 2014 2:42 am
Forum: PHP General
Topic: problem in insert command
Replies: 3
Views: 812

problem in insert command

hi I am new in php. I could not insert the data into mysql table. and there is no error prompt Below is my code. Pls help me. <?php include_once '../inc/header.php'; if (isset($_POST['submit']) && $_POST['submit'] != "" ) { $name = $_POST["name"]; $address = $_POST["address"]; $tel = $_POST["tel"]; ...
by maideen
Thu Apr 03, 2014 3:26 am
Forum: PHP General
Topic: how to pass the selected id to another page
Replies: 2
Views: 1028

Re: how to pass the selected id to another page

I am telling the scnario. I have page with all customer data as grid format. last column is "UPDATE". If I select 5th row and click update, next page open the details of 5th row customer data. My sql command: $sql="select id,name,firstname,age from customer where id='$id'" How can i pass the id for ...
by maideen
Wed Apr 02, 2014 3:59 am
Forum: PHP General
Topic: how to pass the selected id to another page
Replies: 2
Views: 1028

how to pass the selected id to another page

Hi I am new, Pls help me the following issue. When click the update button, ID should be to another page to process the update function. Below is my entire code index.php <?php include_once '../../inc/config.inc.php'; $sql="SELECT * FROM demo order by id"; try { $result = mysqli_query($con,$sql); in...
by maideen
Thu Mar 20, 2014 6:42 am
Forum: mySQL & php coding
Topic: Error in select command in php
Replies: 0
Views: 595

Error in select command in php

Hi I am new in php. Below code works fine. But If I change Select Command Like this: $sql = "SELECT login_id,password FROM user_right WHERE login_id = '$username' and password = '$password'"; It shows error recorde not found. Also I need to show the role of select user. Pls Help me <?php include_onc...
by maideen
Thu Mar 20, 2014 6:40 am
Forum: mySQL & php coding
Topic: Error in select command in php
Replies: 0
Views: 651

Error in select command in php

Hi I am new in php. Below code works fine. But If I change Select Command Like this: $sql = "SELECT login_id,password FROM user_right WHERE login_id = '$username' and password = '$password'"; It shows error recorde not found. Also I need to show the role of select user. Pls Help me <?php include_onc...
by maideen
Tue Jun 18, 2013 9:59 pm
Forum: PHP coding => General
Topic: search any text in data
Replies: 6
Views: 1952

Re: search any text in data

Hi Thank you all of you to give the suggestion. The problem was in search.php Here is the code which is working fine <?php $query = $_GET['query']; echo $query; $stmt = $dbh->query("SELECT * FROM CompanyInfo WHERE (Name LIKE '%".$query."%' OR Address LIKE '%".$query."%')"); $stmt->setFetchMode(PDO::...
by maideen
Tue Jun 18, 2013 9:35 pm
Forum: PHP coding => General
Topic: search any text in data
Replies: 6
Views: 1952

Re: search any text in data

hi

Thank you

I have checked too

Nothing happend

Maideen
by maideen
Tue Jun 18, 2013 8:07 pm
Forum: PHP coding => General
Topic: search any text in data
Replies: 6
Views: 1952

Re: search any text in data

hi

I have changed according to your suggestion, but still I could not get result. Nothing appeared in page

Pls

Maideen
by maideen
Tue Jun 18, 2013 6:57 am
Forum: PHP coding => General
Topic: search any text in data
Replies: 6
Views: 1952

search any text in data

Hi I have one problem. I need search any string data. Below is my code. When I click, no result, I am using MSSQL and PDO index.php <?php include_once '../templete/header.php'; ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />...
by maideen
Fri Jun 14, 2013 11:54 pm
Forum: PHP General
Topic: print report data to printer directly
Replies: 1
Views: 1131

print report data to printer directly

print data to printer hi. i have a problem in printing the report to printer. Now i can print the php reports, but it will open both printer dialog and page together. But I need only one to printer dialog box. Pls help me Below my code Connection database ` <?php try { $hostname = "sqlserver2005"; /...
by maideen
Thu May 30, 2013 4:01 pm
Forum: PHP coding => General
Topic: php page send to print
Replies: 3
Views: 1462

Re: php page send to print

hi john

I have tested but appear page with data but not output printers.

where this command should be given? I have given top of page but no response.

Pls

Maideen
by maideen
Thu May 30, 2013 4:16 am
Forum: PHP coding => General
Topic: php page send to print
Replies: 3
Views: 1462

php page send to print

Hi Following code is working fine. But On click the print button it display data on another page not going to print. Can any body know, pls let me know. Pls help me It is HTML Page <style type="text/css"></style> <?php include '../templete/header.php'; ?> <Script Language="javascript"> function chan...
by maideen
Thu May 30, 2013 3:56 am
Forum: PHP coding => General
Topic: redirect pages
Replies: 2
Views: 1184

Re: redirect pages

hi Thank you all problem have been solved by using this code <?php include '../templete/header.php'; ?> [color]<Script Language="javascript"> function change_action() { var frm_obj=document.getElementById("frm"); frm_obj.action="data.php"; } </Script>[/color] <table class="tbl_table" align="center">...
by maideen
Sun May 26, 2013 8:08 pm
Forum: PHP coding => General
Topic: redirect pages
Replies: 2
Views: 1184

redirect pages

Hi I have two button in my page One is 'search' and another is 'print' But i could not re direct and passing date to another page. code is working fine for search. But print I am blur of this. Pls help me how i can redirect the page by using button click. Pls help me Below my code index.php <?php in...
by maideen
Sun May 26, 2013 7:44 pm
Forum: PHP coding => General
Topic: ageing report
Replies: 4
Views: 1556

Re: ageing report

Hi I have solved by using store procedure in mssql server. It is this [code]USE [CMSHCK] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[php_usp_AgeingReportNew] @dtCurrent datetime AS BEGIN -- if @dtCurrent = '' begin -- Set @dtCurrent = GetDate() -- end select code as MV...
by maideen
Sat May 25, 2013 8:26 am
Forum: PHP coding => General
Topic: ageing report
Replies: 4
Views: 1556

Re: ageing report

Hi

I could not find whether the producing

maidene
by maideen
Fri May 24, 2013 8:52 pm
Forum: PHP coding => General
Topic: ageing report
Replies: 4
Views: 1556

ageing report

hi. I need to generate the ageing report like Code Name 30days 60days 90days 120days 0001 abc 500.85 675.90 100.78 56.90 0002 def 123.00 0.00 21.00 67.09 My code is below. But Nothing is appear. Pls if anyone knows pls help me connection.inc.php <?php try { $hostname = "server"; //host $dbname = "da...
by maideen
Fri May 17, 2013 8:22 pm
Forum: PHP coding => General
Topic: grouping the data and their total in php page
Replies: 0
Views: 656

grouping the data and their total in php page

Hi I have generated the Php page with sales data with total of sales and work fine. But In same page I need the sales by group like product-1 My html code is available in below Currently I have generated like what is below. But I need to calculate by group (based on ID) ID Date Price Qty 0001 201301...