Posts by urtrivedi Page 13

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

All major DBMS provide file import utility. where you can spceify datatypes/ field separator and record seprators.

Look at your all sources, and find all distinct columns and create table in your destination database with all columns you found in all sources

then case by case (file format by file format), import your files to the new table using import tool

if you using oracle as destination table, you can also take help of sqldeveloper (u can download from oracle website for free). It has facility to import several file formats.

Databases oracle

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: insert value into multiple rows

you check primary key of "list" table, it may be possible that not allowing multiple docno or revno.

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: admin and regular user access to page

I am adding 2 new lines after 38 in your login.php

$_SESSION['user_id'] = $login;
 $retarr=user_data("user_level");
 $_SESSION['user_level']=$retarr['user_level'];

I am posting it again, Have you tried this.

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: how to deploy PHP website on the Web

www.0fees.net, provide free mysql/php server

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: how to deploy PHP website on the Web

I wanted demo forum online so I registered on WWW.PROPHPBB.COM , they give free forum with limited settings. But good one to start free forum.
Most of things you can manage using their admin panel.

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: How to hide textarea when a radio button selected?

I put all together with few changes

<html>
<head>
<script lang='javascript'>
    function onoff(clickedradio)
    {

            if  (clickedradio.checked && clickedradio.value=='1')
            {

                  document.getElementById("divtext").style.display="none";
            }
            else
            {
                  document.getElementById("divtext").style.display="block";
            }

    }

</script>
</head>
<body>
<fieldset id="radios">
    <td width="33" bgcolor="#00FF00" ><font face="Arial"><input type="radio" checked name="ItemName" onclick="onoff(this)" value="1"></font></td>
    <td width="33" bgcolor="#FFFF00" ><font face="Arial"><input type="radio" name="ItemName" onclick="onoff(this)" value="2"></font></td>
    <td width="33" bgcolor="#FF0000" ><font face="Arial"><input type="radio" name="ItemName" onclick="onoff(this)" value="3"></font></td>
</fieldset>

<div id=divtext style='display:none'>        <font face="Arial"><textarea id="txt1" rows="8" name="ISSUE" cols="90"> </textarea></div>

</body>
</html>

Web Development javascript

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: admin and regular user access to page

I am adding 2 new lines after 38 in your login.php

 $_SESSION['user_id'] = $login;
 $retarr=user_data("user_level");
 $_SESSION['user_level']=$retarr['user_level'];

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: admin and regular user access to page

I also asked for table structure of user table, how is ur userleve stored?

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: php Login Module Doesn't Work

type exit after all headers to avoid belwo code to excute;

header('Location: profile.php');
exit;

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: admin and regular user access to page

where is level stored in ur user table, send me login link and your mysql table sql script here

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: php email

You must have mail server configured in yoru network, which ip address you can configure with ur php.

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Need help about french language in my project.

in all browsers?

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Need help about french language in my project.

Mais mon site ne s'affiche pas certains charachter françaises de ce type de texte qui est-ç, é, à etc.in place de ces charachter mon site affiche un symbole.
Que puis-je faire pour montrer ces charachter.

Copy this is it showing in your site or not

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Selecting the top customers from my DB

its not showing any result

what do u mean
1) no rows showed?
2) query giving any error?

you may also try withoug 10 or 15 conition as given below

SELECT `u`.`userid`, `u`.`username`, COUNT(`s`.*) AS `total_sales`
FROM `users` `u`
INNER JOIN `sales` `s` ON (`s`.`userid` = `u`.`userid` AND `s`.`status` = 'delivered')
ORDER BY `total_sales` DESC
LIMIT 10

Web Development mysql php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: A simple guide to Pagination required

refer this i think it will help
http://phpsense.com/2007/php-pagination-script/

Web Development display mysql php ui-ux

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Removing additional characters from a variable

where is the source, who build that link. It not in our control if somebody refter your page like this.

Web Development asp

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Multiple variables passed via querystring in URL

Try this in enquiry.php
<?php

$fac=implode(",",$_GET['facility']) ;
$Body .= "Facility: ".$fac;
 echo $Body;

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Multiple variables passed via querystring in URL

add complete html code, where is form, submit button

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: admin and regular user access to page

after line 38 in your code, you have to set $_SESSION['user_level'] from database with query like

select user_level from usertable where useri_id='$login'

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Multiple variables passed via querystring in URL

you can post your whole php script here, with database sql files if any, with some sample data

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: admin and regular user access to page

your var_dump means, user_level is not set only user_id is set, so in your login page, you also need to set user_level in sesssion

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Uploading files to multiple servers

Web Development file-system php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Is it still useful to learn Oracle SQL (even the basic commands)?

http://w3schools.com/sql/default.asp

Databases oracle

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Query counts different when Joining table; why?

can u post sql script of 3 table with data for that condition

Databases mssql

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Query counts different when Joining table; why?

I think NoDecision is having 2 inquiry.id for any one case so it is adding one more

you can try

count (distint Inquiry.ID)

Databases mssql

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Multiple variables passed via querystring in URL

I agree with paulraj

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Profit Calculation

where is the date?

and I think sql query only can not help, you need to do order by date in query and then you can see result and calculate profie for each row in php.

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: change color of blinking text

<div id="Foo" style='color:red;background-color:black'>news</div>

Web Development javascript

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Uploading files to multiple servers

What i have given you will show http://i1.mysite.com/showimage.php?imgid=i3rft to user. But user will never able to know actual server address where image is stored.

Showimage.php will silently show image from remote server without revealing remote server address

If you want to show like http://i1.mysite.com/upload/image.png and want to get image from remote then I am not sure how to do that

Web Development file-system php

Khav commented: Thanks for the interest +0

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Uploading files to multiple servers

showimage.php

<?php
    $form_no = $_GET['imgid'];


    if($_GET['type']==1)
        $file="p{$form_no}_photo.jpg";
    elseif($_GET['type']==2)
        $file="p{$form_no}_sign.jpg";
    $instr = fopen("http://92.43.223.43/upload/{$file}","rb");//here you can give url of your ftp server
    $bytes = fread($instr,filesize("http://92.43.223.43/upload/{$file}"));
    header("Content-type: image/jpeg");
    print $bytes;
    exit ();

?>

html

<img src ='showimage.php?imgid=i3rft'>

Web Development file-system php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Uploading files to multiple servers

you just keep link as http://67.57.183.23/upload/i3rft.png
No need to wirte i1.mysite.com/...

Web Development file-system php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: PHP Paging issue

not here man you need to do in first page

print "<a href='$page_name?start=$next&id={$_GET[id]}'><font face='Verdana' size='2'>NEXT</font></a>";

where ever you set $start everywhere you have to add $_GET[id]

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: PHP Paging issue

you must also pass id with start

start=$i&id={$_GET[id]}'

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: PHP Paging issue

whtas on screen now

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Uploading files to multiple servers

Yes
I guess you will save i3frt.png name in database somewhere,
then when user uploads it copy that file to ftp server at location server/upload

if you show link in your file like server/upload/image.png
then it will also work fine

Web Development file-system php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: PHP Paging issue

add this 3 lines in the beginging of your page

error_reporting(0);
ini_set("display_errors",0);
if ($_GET['start']=="")
    $_GET['start']=1;

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Uploading files to multiple servers

I usually keep things on same server as I never had big number of files. Huge sites may be keeping file separate server.
I dont think bad performance if you keep files on same server, in case of medium sites

Web Development file-system php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Help with user profile pages

http://www.w3schools.com/php/php_mysql_select.asp

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Help with user profile pages

you have to open mysql connection, you have to write query and you have to keep link in loop

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Help with user profile pages

write code here, not error

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Help with user profile pages

select username,id from members

<a href='members_profile.php?id=<?php echo $row[id];?> >' > <?php echo $row[username];?> </A>

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Help with user profile pages

no as i said only two page

like you see daniweb
it has web develpment topics, you can seee list of around 20 topics then on next page next 20.

If you lick on title of topic this page loaded
so basically there are only 2 pages, one for listing another for vieewing

you just pass userid to the second page and in ur query, u filter records on the base of passed userid

first page

<a href='mem_profile.php?uid=1> Memeber 1<a>
<a href='mem_profile.php?uid=2> Memeber 2<a>
<a href='mem_profile.php?uid=3> Memeber 3<a>
<a href='mem_profile.php?uid=4> Memeber 4<a>

second page (mem_profile.php)

select * from table where userid='{$_GET['uid']}'

display record of uid clicked

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: sql_query doesn't appear to be working

following line

update-server.php?server=$server_id

it should be like this when u click in address bar

update-server.php?server=12

it must be some number or value and not variable name

Web Development php sql

mmcdonald commented: What i've done works fine but thanks for the reply.... +0

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Help with user profile pages

You can create 2 pages.
1) list all members with pagination, with id link to there profile page
2) profile view page (same as you profielpage u did for modifying, but only text no html elements)

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Help with user profile pages

what u did so far?

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Uploading files to multiple servers

I am not sure about performance.
1) you have to upload file using script to same server where script is available.
2) copy that file to another server using ftp funciton of php
3) delete file from script server

Web Development file-system php

Khav commented: From Khav +2

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Profit Calculation

what is table struture?
what is ur database? mysql, mssql or other?
do you have sale date/pur date?

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: reply/ Problem: "Notice: Undefined index"

write these 2 statument in the begining of your php file

<?php
    error_reporting(0);
    ini_set("display_errors",0);
.
.
.
?>

Web Development

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Having issues with php form

The form select name is 'select' in your form, and in code you are looking for 'help' name.

so change your name to 'help'

change following line in your contact.htm

<select name='select'>

<select name='help'>

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

12 Years Ago

Re: Inner join as sub Query

your query will fail if A have no data for id=1, it will also not show summedB even if table B having data for id 1

Databases oracle