Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

PHP Mysql matching data loop until ended

I have a database which has Work Orders each work order has a parent so say WO 123 as a parent of 234. but then you will get children of children etc. what i have got with my code so far is it works for two levels to main work order number searched for then the child but for children of children. is there a way to make it loop until there is no parents so its a lone work order. plus you will see from the code i also need this WO number help for it to check Timewrite PO and SMS tables. hope i make sense. its creating a csv by the way so can be saved as text and put into excel

Wonum,Desc,Status,RepBy,Parent,Eqnum,EqDesc,Location,LocDesc,JobOwner,WorkType,Tstart,TComp,acctperson,Estimate,ApproveHoldStop,Initial
<?php
include ("include.php");
$query0111 = "SELECT * FROM ineos_evwo WHERE Wonum = '$woid'";
$result0111 = mysql_query($query0111) or die("Error: " . mysql_error());
$count0111 = mysql_num_rows($result0111);
while($row0111 = mysql_fetch_array($result0111)){
?>
<? echo $row0111['Wonum'];?>,<? echo'"';echo $row0111['description'];echo'"';?>,<? echo $row0111['Status'];?>,<? echo $row0111['RepBy'];?>,<? echo $row0111['Parent'];?>,<? echo $row0111['Eqnum'];?>,<? echo'"';echo $row0111['EqDesc'];echo'"';?>,<? echo $row0111['Location'];?>,<? echo'"';echo $row0111['LocDesc'];echo'"';?>,<? echo $row0111['JobOwner'];?>,<? echo $row0111['WorkType'];?>,<? echo $row0111['Tstart'];?>,<? echo $row0111['TComp'];?>,<? echo $row0111['acctperson'];?>,<? echo $row0111['Estimate'];?>,<? echo $row0111['ApproveHoldStop'];?>,<? echo $row0111['Initial'];$cr = "\n";print"$cr";?><?php } ?>
<?php
include ("include.php");
$query = "SELECT * FROM ineos_evwo WHERE Parent = '$woid'";
$result = mysql_query($query) or die("Error: " . mysql_error());
$count = mysql_num_rows($result);
while($row = mysql_fetch_array($result)){
?>
<? echo $row['Wonum'];?>,<? echo'"';echo $row['description'];echo'"';?>,<? echo $row['Status'];?>,<? echo $row['RepBy'];?>,<? echo $row['Parent'];?>,<? echo $row['Eqnum'];?>,<? echo'"';echo $row['EqDesc'];echo'"';?>,<? echo $row['Location'];?>,<? echo'"';echo $row['LocDesc'];echo'"';?>,<? echo $row['JobOwner'];?>,<? echo $row['WorkType'];?>,<? echo $row['Tstart'];?>,<? echo $row['TComp'];?>,<? echo $row['acctperson'];?>,<? echo $row['Estimate'];?>,<? echo $row['ApproveHoldStop'];?>,<? echo $row['Initial'];$cr = "\n";print"$cr";?><?php } ?>
<?php
include ("include.php");
$query22 = "SELECT * FROM ineos_evwo WHERE Parent = '$woid'";
$result22 = mysql_query($query22) or die("Error: " . mysql_error());
$count22 = mysql_num_rows($result22);
while($row22 = mysql_fetch_array($result22)){
?><? $woid00 = $row22['Wonum']; ?>
<?php
include ("include.php");
$query = "SELECT * FROM ineos_evwo WHERE Parent = '$woid00'";
$result = mysql_query($query) or die("Error: " . mysql_error());
$count = mysql_num_rows($result);
while($row = mysql_fetch_array($result)){
?>
<? echo $row['Wonum'];?>,<? echo'"';echo $row['description'];echo'"';?>,<? echo $row['Status'];?>,<? echo $row['RepBy'];?>,<? echo $row['Parent'];?>,<? echo $row['Eqnum'];?>,<? echo'"';echo $row['EqDesc'];echo'"';?>,<? echo $row['Location'];?>,<? echo'"';echo $row['LocDesc'];echo'"';?>,<? echo $row['JobOwner'];?>,<? echo $row['WorkType'];?>,<? echo $row['Tstart'];?>,<? echo $row['TComp'];?>,<? echo $row['acctperson'];?>,<? echo $row['Estimate'];?>,<? echo $row['ApproveHoldStop'];?>,<? echo $row['Initial'];$cr = "\n";print"$cr";?><?php } } ?>
PO No,P Line,Desc,Issue Type,Post Date,Qty,Unit Cost,Line Cost,WONUM,WO Status,WO Rep By,Invoice No,GL Debit,BP/Ineos
<?php
include ("include.php");
$query01 = "SELECT * FROM ineos_pos WHERE WONUM = '$woid'";
$result01 = mysql_query($query01) or die("Error: " . mysql_error());
$count01 = mysql_num_rows($result01);
while($row01 = mysql_fetch_array($result01)){
?>
<? echo $row01['PONUM'];?>,<? echo $row01['PLINE'];?>,<? echo'"';echo $row01['DESCRIPTION'];echo'"';?>,<? echo $row01['ISSUETYPE'];?>,<? echo $row01['POSTINGDATE'];?>,<? echo $row01['QUANTITY'];?>,<? echo $row01['UNITCOST'];?>,<? echo $row01['LINECOST'];?>,<? echo $row01['WONUM'];?>,<? echo $row01['WOSTATUS'];?>,<? echo $row01['WO_REPORTEDBY'];?>,<? echo $row01['INVOICENUM'];?>,<? echo $row01['GLDEBITACCT'];?>,<? echo $row01['BPineos'];$cr = "\n";print"$cr";?><?php } ?>
<?php
include ("include.php");
$query = "SELECT * FROM ineos_evwo WHERE Parent = '$woid'";
$result = mysql_query($query) or die("Error: " . mysql_error());
$count = mysql_num_rows($result);
while($row = mysql_fetch_array($result)){
?><? $woid0 = $row['Wonum']; ?>
<?php
include ("include.php");
$query0 = "SELECT * FROM ineos_pos WHERE WONUM = '$woid0'";
$result0 = mysql_query($query0) or die("Error: " . mysql_error());
$count0 = mysql_num_rows($result0);
while($row0 = mysql_fetch_array($result0)){
?>
<? echo $row0['PONUM'];?>,<? echo $row0['PLINE'];?>,<? echo'"';echo $row0['DESCRIPTION'];echo'"';?>,<? echo $row0['ISSUETYPE'];?>,<? echo $row0['POSTINGDATE'];?>,<? echo $row0['QUANTITY'];?>,<? echo $row0['UNITCOST'];?>,<? echo $row0['LINECOST'];?>,<? echo $row0['WONUM'];?>,<? echo $row0['WOSTATUS'];?>,<? echo $row0['WO_REPORTEDBY'];?>,<? echo $row0['INVOICENUM'];?>,<? echo $row0['GLDEBITACCT'];?>,<? echo $row0['BPineos'];$cr = "\n";print"$cr";?><?php } } ?>
<?php
include ("include.php");
$query222 = "SELECT * FROM ineos_evwo WHERE Parent = '$woid'";
$result222 = mysql_query($query222) or die("Error: " . mysql_error());
$count222 = mysql_num_rows($result222);
while($row222 = mysql_fetch_array($result222)){
?><? $woid00 = $row222['Wonum']; ?>
<?php
include ("include.php");
$query333 = "SELECT * FROM ineos_evwo WHERE Parent = '$woid00'";
$result333 = mysql_query($query333) or die("Error: " . mysql_error());
$count333 = mysql_num_rows($result333);
while($row333 = mysql_fetch_array($result333)){
?><? $woid0011 = $row333['Wonum']; ?>
<?php
include ("include.php");
$query0 = "SELECT * FROM ineos_pos WHERE WONUM = '$woid0011'";
$result0 = mysql_query($query0) or die("Error: " . mysql_error());
$count0 = mysql_num_rows($result0);
while($row0 = mysql_fetch_array($result0)){
?>
<? echo $row0['PONUM'];?>,<? echo $row0['PLINE'];?>,<? echo'"';echo $row0['DESCRIPTION'];echo'"';?>,<? echo $row0['ISSUETYPE'];?>,<? echo $row0['POSTINGDATE'];?>,<? echo $row0['QUANTITY'];?>,<? echo $row0['UNITCOST'];?>,<? echo $row0['LINECOST'];?>,<? echo $row0['WONUM'];?>,<? echo $row0['WOSTATUS'];?>,<? echo $row0['WO_REPORTEDBY'];?>,<? echo $row0['INVOICENUM'];?>,<? echo $row0['GLDEBITACCT'];?>,<? echo $row0['BPineos'];$cr = "\n";print"$cr";?><?php } } } ?>
WONUM,DESCRIPTION,LOCLEVEL2,LEADCRAFT,GLACCOUNT,MATLS,BIS,SHIRE,UNSCOPED,PREMIUM,LSUM_LABR,LSUM_MATL,US_FLAG,UNSCOPED_HRS,LSUM_HRS,BPIneos,Ineos,BP
<?php
include ("include.php");
$query11 = "SELECT * FROM ineos_sms WHERE WONUM = '$woid'";
$result11 = mysql_query($query11) or die("Error: " . mysql_error());
$count11 = mysql_num_rows($result11);
while($row11 = mysql_fetch_array($result11)){
?>
<? echo $row11['WONUM'];?>,<? echo'"';echo $row11['DESCRIPTION'];echo'"';?>,<? echo $row11['LOCLEVEL2'];?>,<? echo $row11['LEADCRAFT'];?>,<? echo $row11['GLACCOUNT'];?>,<? echo $row11['MATLS'];?>,<? echo $row11['BIS'];?>,<? echo $row11['SHIRE'];?>,<? echo $row11['UNSCOPED'];?>,<? echo $row11['PREMIUM'];?>,<? echo $row11['LSUM_LABR'];?>,<? echo $row11['LSUM_MATL'];?>,<? echo $row11['US_FLAG'];?>,<? echo $row11['UNSCOPED_HRS'];?>,<? echo $row11['LSUM_HRS'];?>,<? echo $row11['BPIneos'];?>,<? echo $row11['Ineos'];?>,<? echo $row11['BP'];$cr = "\n";print"$cr";?><?php }?>
<?php
include ("include.php");
$query = "SELECT * FROM ineos_evwo WHERE Parent = '$woid'";
$result = mysql_query($query) or die("Error: " . mysql_error());
$count = mysql_num_rows($result);
while($row = mysql_fetch_array($result)){
?> <? $woid1 = $row['Wonum']; ?>
<?php
include ("include.php");
$query1 = "SELECT * FROM ineos_sms WHERE WONUM = '$woid1'";
$result1 = mysql_query($query1) or die("Error: " . mysql_error());
$count1 = mysql_num_rows($result1);
while($row1 = mysql_fetch_array($result1)){
?>
<? echo $row1['WONUM'];?>,<? echo'"';echo $row1['DESCRIPTION'];echo'"';?>,<? echo $row1['LOCLEVEL2'];?>,<? echo $row1['LEADCRAFT'];?>,<? echo $row1['GLACCOUNT'];?>,<? echo $row1['MATLS'];?>,<? echo $row1['BIS'];?>,<? echo $row1['SHIRE'];?>,<? echo $row1['UNSCOPED'];?>,<? echo $row1['PREMIUM'];?>,<? echo $row1['LSUM_LABR'];?>,<? echo $row1['LSUM_MATL'];?>,<? echo $row1['US_FLAG'];?>,<? echo $row1['UNSCOPED_HRS'];?>,<? echo $row1['LSUM_HRS'];?>,<? echo $row1['BPIneos'];?>,<? echo $row1['Ineos'];?>,<? echo $row1['BP'];$cr = "\n";print"$cr";?><?php } }?>
<?php
include ("include.php");
$query222 = "SELECT * FROM ineos_evwo WHERE Parent = '$woid'";
$result222 = mysql_query($query222) or die("Error: " . mysql_error());
$count222 = mysql_num_rows($result222);
while($row222 = mysql_fetch_array($result222)){
?><? $woid00 = $row222['Wonum']; ?>
<?php
include ("include.php");
$query333 = "SELECT * FROM ineos_evwo WHERE Parent = '$woid00'";
$result333 = mysql_query($query333) or die("Error: " . mysql_error());
$count333 = mysql_num_rows($result333);
while($row333 = mysql_fetch_array($result333)){
?><? $woid0011 = $row333['Wonum']; ?>
<?php
include ("include.php");
$query1 = "SELECT * FROM ineos_sms WHERE WONUM = '$woid0011'";
$result1 = mysql_query($query1) or die("Error: " . mysql_error());
$count1 = mysql_num_rows($result1);
while($row1 = mysql_fetch_array($result1)){
?>
<? echo $row1['WONUM'];?>,<? echo'"';echo $row1['DESCRIPTION'];echo'"';?>,<? echo $row1['LOCLEVEL2'];?>,<? echo $row1['LEADCRAFT'];?>,<? echo $row1['GLACCOUNT'];?>,<? echo $row1['MATLS'];?>,<? echo $row1['BIS'];?>,<? echo $row1['SHIRE'];?>,<? echo $row1['UNSCOPED'];?>,<? echo $row1['PREMIUM'];?>,<? echo $row1['LSUM_LABR'];?>,<? echo $row1['LSUM_MATL'];?>,<? echo $row1['US_FLAG'];?>,<? echo $row1['UNSCOPED_HRS'];?>,<? echo $row1['LSUM_HRS'];?>,<? echo $row1['BPIneos'];?>,<? echo $row1['Ineos'];?>,<? echo $row1['BP'];$cr = "\n";print"$cr";?><?php } } }?>
Warehouse,ISSUETYPE,ITEMNUM,ITEMDESCRIPTION,WONUM,REPORTEDBY,WONSTATUS,WONDESCRIPTION,POSTINGDATE,GLCREDIT,GLDEBITACCT,QUANTITY,UNITCOST,LINECOST,LOCATION,EQNUM,IneosBP
<?php
include ("include.php");
$query22 = "SELECT * FROM ineos_stores WHERE WONUM = '$woid'";
$result22 = mysql_query($query22) or die("Error: " . mysql_error());
$count22 = mysql_num_rows($result22);
while($row22 = mysql_fetch_array($result22)){
?>
<? echo $row22['Warehouse'];?>,<? echo $row22['ISSUETYPE'];?>,<? echo $row22['ITEMNUM'];?>,<? echo'"';echo $row22['ITEMDESCRIPTION'];echo'"';?>,<? echo $row22['WONUM'];?>,<? echo $row22['REPORTEDBY'];?>,<? echo $row22['WONSTATUS'];?>,<? echo'"';echo $row22['WONDESCRIPTION'];echo'"';?>,<? echo $row22['POSTINGDATE'];?>,<? echo $row22['GLCREDIT'];?>,<? echo $row22['GLDEBITACCT'];?>,<? echo $row22['QUANTITY'];?>,<? echo $row22['UNITCOST'];?>,<? echo $row22['LINECOST'];?>,<? echo $row22['LOCATION'];?>,<? echo $row22['EQNUM'];?>,<? echo $row22['BPIneos'];$cr = "\n";print"$cr";?><?php } ?>
<?php
include ("include.php");
$query = "SELECT * FROM ineos_evwo WHERE Parent = '$woid'";
$result = mysql_query($query) or die("Error: " . mysql_error());
$count = mysql_num_rows($result);
while($row = mysql_fetch_array($result)){
?><? $woid2 = $row['Wonum']; ?>
<?php
include ("include.php");
$query2 = "SELECT * FROM ineos_stores WHERE WONUM = '$woid2'";
$result2 = mysql_query($query2) or die("Error: " . mysql_error());
$count2 = mysql_num_rows($result2);
while($row2 = mysql_fetch_array($result2)){
?>
<? echo $row2['Warehouse'];?>,<? echo $row2['ISSUETYPE'];?>,<? echo $row2['ITEMNUM'];?>,<? echo'"';echo $row2['ITEMDESCRIPTION'];echo'"';?>,<? echo $row2['WONUM'];?>,<? echo $row2['REPORTEDBY'];?>,<? echo $row2['WONSTATUS'];?>,<? echo'"';echo $row2['WONDESCRIPTION'];echo'"';?>,<? echo $row2['POSTINGDATE'];?>,<? echo $row2['GLCREDIT'];?>,<? echo $row2['GLDEBITACCT'];?>,<? echo $row2['QUANTITY'];?>,<? echo $row2['UNITCOST'];?>,<? echo $row2['LINECOST'];?>,<? echo $row2['LOCATION'];?>,<? echo $row2['EQNUM'];?>,<? echo $row2['BPIneos'];$cr = "\n";print"$cr";?><?php } } ?>
<?php
include ("include.php");
$query222 = "SELECT * FROM ineos_evwo WHERE Parent = '$woid'";
$result222 = mysql_query($query222) or die("Error: " . mysql_error());
$count222 = mysql_num_rows($result222);
while($row222 = mysql_fetch_array($result222)){
?><? $woid00 = $row222['Wonum']; ?>
<?php
include ("include.php");
$query333 = "SELECT * FROM ineos_evwo WHERE Parent = '$woid00'";
$result333 = mysql_query($query333) or die("Error: " . mysql_error());
$count333 = mysql_num_rows($result333);
while($row333 = mysql_fetch_array($result333)){
?><? $woid0011 = $row333['Wonum']; ?>
<?php
include ("include.php");
$query2 = "SELECT * FROM ineos_stores WHERE WONUM = '$woid0011'";
$result2 = mysql_query($query2) or die("Error: " . mysql_error());
$count2 = mysql_num_rows($result2);
while($row2 = mysql_fetch_array($result2)){
?>
<? echo $row2['Warehouse'];?>,<? echo $row2['ISSUETYPE'];?>,<? echo $row2['ITEMNUM'];?>,<? echo'"';echo $row2['ITEMDESCRIPTION'];echo'"';?>,<? echo $row2['WONUM'];?>,<? echo $row2['REPORTEDBY'];?>,<? echo $row2['WONSTATUS'];?>,<? echo'"';echo $row2['WONDESCRIPTION'];echo'"';?>,<? echo $row2['POSTINGDATE'];?>,<? echo $row2['GLCREDIT'];?>,<? echo $row2['GLDEBITACCT'];?>,<? echo $row2['QUANTITY'];?>,<? echo $row2['UNITCOST'];?>,<? echo $row2['LINECOST'];?>,<? echo $row2['LOCATION'];?>,<? echo $row2['EQNUM'];?>,<? echo $row2['BPIneos'];$cr = "\n";print"$cr";?><?php } } } ?>
LabourGroup,WONUM,DESCRIPTION,LABORCODE,MEMO,REGULARHRS,PAYRATE,LINECOST,POSTINGDATE,ENTERDATE,GLDEBITACCT,LOCATION,EQNUM,BPIneos
<?php
include ("include.php");
$query33 = "SELECT * FROM ineos_timewrite WHERE WONUM = '$woid'";
$result33 = mysql_query($query33) or die("Error: " . mysql_error());
$count33 = mysql_num_rows($result33);
while($row33 = mysql_fetch_array($result33)){
?>
<? echo $row33['LabourGroup'];?>,<? echo $row33['WONUM'];?>,<? echo'"';echo $row33['DESCRIPTION'];echo'"';?>,<? echo $row33['LABORCODE'];?>,<? echo $row33['MEMO'];?>,<? echo $row33['REGULARHRS'];?>,<? echo $row33['PAYRATE'];?>,<? echo $row33['LINECOST'];?>,<? echo $row33['POSTINGDATE'];?>,<? echo $row33['ENTERDATE'];?>,<? echo $row33['GLDEBITACCT'];?>,<? echo $row33['LOCATION'];?>,<? echo $row33['EQNUM'];?>,<? echo $row33['BPIneos'];$cr = "\n";print"$cr";?><?php } ?>
<?php
include ("include.php");
$query = "SELECT * FROM ineos_evwo WHERE Parent = '$woid'";
$result = mysql_query($query) or die("Error: " . mysql_error());
$count = mysql_num_rows($result);
while($row = mysql_fetch_array($result)){
?><? $woid3 = $row['Wonum']; ?>
<?php
include ("include.php");
$query3 = "SELECT * FROM ineos_timewrite WHERE WONUM = '$woid3'";
$result3 = mysql_query($query3) or die("Error: " . mysql_error());
$count3 = mysql_num_rows($result3);
while($row3 = mysql_fetch_array($result3)){
?>
<? echo $row3['LabourGroup'];?>,<? echo $row3['WONUM'];?>,<? echo'"';echo $row3['DESCRIPTION'];echo'"';?>,<? echo $row3['LABORCODE'];?>,<? echo $row3['MEMO'];?>,<? echo $row3['REGULARHRS'];?>,<? echo $row3['PAYRATE'];?>,<? echo $row3['LINECOST'];?>,<? echo $row3['POSTINGDATE'];?>,<? echo $row3['ENTERDATE'];?>,<? echo $row3['GLDEBITACCT'];?>,<? echo $row3['LOCATION'];?>,<? echo $row3['EQNUM'];?>,<? echo $row3['BPIneos'];$cr = "\n";print"$cr";?><?php } } ?>
<?php
include ("include.php");
$query222 = "SELECT * FROM ineos_evwo WHERE Parent = '$woid'";
$result222 = mysql_query($query222) or die("Error: " . mysql_error());
$count222 = mysql_num_rows($result222);
while($row222 = mysql_fetch_array($result222)){
?><? $woid00 = $row222['Wonum']; ?>
<?php
include ("include.php");
$query333 = "SELECT * FROM ineos_evwo WHERE Parent = '$woid00'";
$result333 = mysql_query($query333) or die("Error: " . mysql_error());
$count333 = mysql_num_rows($result333);
while($row333 = mysql_fetch_array($result333)){
?><? $woid0011 = $row333['Wonum']; ?>
<?php
include ("include.php");
$query3 = "SELECT * FROM ineos_timewrite WHERE WONUM = '$woid0011'";
$result3 = mysql_query($query3) or die("Error: " . mysql_error());
$count3 = mysql_num_rows($result3);
while($row3 = mysql_fetch_array($result3)){
?>
<? echo $row3['LabourGroup'];?>,<? echo $row3['WONUM'];?>,<? echo'"';echo $row3['DESCRIPTION'];echo'"';?>,<? echo $row3['LABORCODE'];?>,<? echo $row3['MEMO'];?>,<? echo $row3['REGULARHRS'];?>,<? echo $row3['PAYRATE'];?>,<? echo $row3['LINECOST'];?>,<? echo $row3['POSTINGDATE'];?>,<? echo $row3['ENTERDATE'];?>,<? echo $row3['GLDEBITACCT'];?>,<? echo $row3['LOCATION'];?>,<? echo $row3['EQNUM'];?>,<? echo $row3['BPIneos'];$cr = "\n";print"$cr";?><?php } } } ?>

Open in new window

0
martin69
Asked:
martin69
  • 2
  • 2
  • 2
1 Solution
 
InsoftserviceCommented:
hi,

You mean to say that

parent 1
   ->Child 1
       ->Child2
 
0
 
martin69Author Commented:
Hi yes, what i have found so far is it can be as far as 15 levels child 14 but if it could be more to have it loop until it cant find children or children etc.
0
 
InsoftserviceCommented:
hi,

function data($parent =0)
if($parent != null)
{
$query = select * from table where table.parent = $parent;
$result = mysql_query($query) or die("Error: " . mysql_error());
$count = mysql_num_rows($result);
while($row = mysql_fetch_array($result)){

$x = $row['childrowvalue']
$parentid = $row['parentrowvalue']
$this->data($parentid);
}


Please note this is only algo and not actual code
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
profyaCommented:
In this case you may need a recursive function rather than loops.
0
 
martin69Author Commented:
could i have a ish working example for me to play with?
0
 
profyaCommented:
A recursive function is a function calls itself until it reaches the end of calls, then it returns back on the stack. I know you have a chain of orders, does the first order have its parent NULL? What do you want to make with the order id the function will get, save it to an array? echo it out?
Anyhow, the general idea is:
1. Pass the order id as parameter.
2. Access the database, and if there is a child or more, call the method again.
3. There should be a condition to stop the method from working forever, and to avoid stack overflow message.

For exampe:
function GetOrders($orderID)
{
$sql="SELECT * FROM orders WHERE ord_parent_id=$orderID";
$rs=mysql_query($sql);
if ($rs && mysql_num_rows($rs)>0)
{
        while($rec=mysql_fetch_array($rs))
        {
                  echo $rec['ord_id'];//Print it out.
                  GetOrders ($rec['ord_id']);//Recursive call
        }
}
}

I hope this helps
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now